[jira] [Closed] (FLINK-20861) Provide an option for serializing DECIMALs in JSON as plain number instead of scientific notation

["Jark Wu (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/FLINK-20861?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jark Wu closed FLINK-20861.
---------------------------
    Resolution: Fixed

Fixed in master: 5b9f4db30e5afcf23588f44da767aaa218df1207

> Provide an option for serializing DECIMALs in JSON as plain number instead of scientific notation
> -------------------------------------------------------------------------------------------------
>
>                 Key: FLINK-20861
>                 URL: https://issues.apache.org/jira/browse/FLINK-20861
>             Project: Flink
>          Issue Type: Improvement
>          Components: Formats (JSON, Avro, Parquet, ORC, SequenceFile), Table SQL / Ecosystem
>            Reporter: Q Kang
>            Assignee: Q Kang
>            Priority: Minor
>              Labels: pull-request-available
>             Fix For: 1.13.0
>
>
> When using DECIMAL types in Flink SQL along with JSON format, it is quite common to see that some large values are written out as scientific notation. For example:
> Definition: `orderId DECIMAL(20, 0)`
> Input: `\{"orderId":454621864049246170}`
> Output (without transformations): `\{"orderId":4.5462186404924617E+17}`
> However, values in plain numbers are easier to understand and more convenient for the case shown above. So we can provide a boolean option (say `json.use-plain-decimals`?) to make this behavior tunable.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)