apache / apache/hop

[Bug]: "Json input" String to number conversion error when pushed on HOP server instead of Local

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

Description

### Apache Hop version?

2.15

### Java version?

21

### Operating system

Linux

### What happened?

I Use "Json Input" transform to extract Strings and non string values from input.

Some json fields are numeric (with or without decimals) and look like:
var1: "125.00"
in this context, is the decimal separator -> value is 125

Image

When I launch on Local pipeline run Configuration, everything is OK and numeric values are correctly transformed
When I launch on Remote pipeline Configuration (eq HOP server which is on the same machine), I got String conversion errors,
"couldn't convert String to number: non-numeric character found at postion 4 for value [125.00]

I suppose there is a "decimal and thousands separator configuration" to set for HOP-server somewhere to set, so that local config and hop-server config would be the same, but I don't know where ...

### Issue Priority

Priority: 3

### Issue Component

Component: Hop Server

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the Json Input conversion with the supplied value [125.00] in both the Local pipeline run configuration and the remote Hop Server configuration. Compare their decimal and thousands separator settings; done means the remote run converts the numeric string without an error and matches the local result.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
data-engineering
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 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.