[Bug]: Table Input + Text File Output - trailing spaces in output
- Dominant language
- Java
- Stars
- 1.5k
- Forks
- 476
- Avg merge
- 18h 32m
- Merged PRs (30d)
- 216
Description
### Apache Hop version?
2.9.0, 2.10.0 SNAPSHOT
### Java version?
openjdk 21.0.2 2024-01-16
### Operating system
Linux
### What happened?
Steps to reproduce:
1. Create a template pipeline for Metadata Injection, with a Table Input and a Text File Output transforms
2. Create a second pipeline, inject in the previous one a query on an Oracle connection and the file in which writing the output
The VARCHAR2/String values are always written in the file with the trailing spaces needed to match their maximum length, regardless you choose or not the flag "Right pad fields?".
A workaround would probably be to use a String operations to trim data manually, but to use that you need to specify the table/view schema (so you can't use it with Metadata Injection)
### Issue Priority
Priority: 2
### Issue Component
Component: Metadata, Component: Transforms
Contributor guide
Research direction
Reproduce the issue with a Metadata Injection pipeline containing Table Input and Text File Output, using an Oracle query and output file. Inspect the metadata and transform handling for VARCHAR2/String values and the "Right pad fields?" option. Done means output values no longer contain unwanted trailing spaces when right padding is disabled.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- data-engineering, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 38/100