Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
1.20.0, 1.19.1
Description
SELECT JSON_VALUE('{"bigNumber":123456789.987654321}', '$.bigNumber')
produces
"1.2345678998765433E8"
which can not be mapped back. It gets rounded.
The reason is we use double for floats in SqlJsonUtils. We should rather configure jackson to use BigDecimals. In order to do that we need to properly shade jayway though.
I suggest we:
1. Add com.jayway.jsonpath:son-path to flink-shaded
2. We use the shaded library and pass a configured mapper which maps floats to BigDecimal
Attachments
Issue Links
- links to
1.
|
Publish shaded jsonpath | Closed | Dawid Wysakowicz | |
2.
|
Upgrade flink-shaded to 19.0 | Closed | Dawid Wysakowicz |