Q Kang created FLINK-20861: ------------------------------ Summary: 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) Reporter: Q Kang
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)