apache / apache/hop

[Bug]: Table Input + Text File Output - trailing spaces in output

Open
#4,303 4 comments 0 reactions 0 assignees View on GitHub
awaiting triage Metadata P2 Transforms
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.