[Bug]: "Json input" String to number conversion error when pushed on HOP server instead of Local
- 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
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
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