apache / apache/hop

[Bug]: JSON Input step output results cannot distinguish between empty string and null

Open
#4,373 0 comments 0 reactions 0 assignees View on GitHub
awaiting triage P3 Transforms
Dominant language
Java
Stars
1.5k
Forks
476
Avg merge
18h 32m
Merged PRs (30d)
216

Description

### Apache Hop version?

2.9

### Java version?

11

### Operating system

Windows

### What happened?

1. create new pipeline.
2. new data grid step. add content
![image](https://github.com/user-attachments/assets/ae7d8eb6-2c2a-40d0-9661-eab67c56db4f)
![image](https://github.com/user-attachments/assets/57b7fb88-2b1f-4fdf-bb5a-c5a5fa119373)

4.new JSON input setp.
![image](https://github.com/user-attachments/assets/10104ac2-2de1-43d7-89ab-fb8d93b8f39e)
![image](https://github.com/user-attachments/assets/90e9dae9-cd8f-4e02-aabe-f1e0c9f2b56a)
5. run (Meet expected results)
![image](https://github.com/user-attachments/assets/579981aa-ebeb-4449-8c35-9b3323e73105)
7. update HOP_EMPTY_STRING_DIFFERS_FROM_NULL=Y
![image](https://github.com/user-attachments/assets/ea04f3f0-aa4c-4477-bd27-0c2658697914)
![image](https://github.com/user-attachments/assets/a7bc734f-b147-43a3-b732-0a3a428f5c00)

8. Restart Hop Gui
9. run (cannot distinguish between empty string and null)
![image](https://github.com/user-attachments/assets/ecef9533-76a3-4ff9-af1c-4dd401cd7708)

### Issue Priority

Priority: 3

### Issue Component

Component: Transforms

Contributor guide

Open the contributing guide

Research direction

Reproduce the issue in Apache Hop 2.9 on Java 11 using a new pipeline with a Data Grid step feeding a JSON Input step. Run it with HOP_EMPTY_STRING_DIFFERS_FROM_NULL unset and then set to Y, restarting Hop GUI between runs. Done means the JSON Input step output distinguishes an empty string from null.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
data-engineering
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.