[jira] [Created] (FLINK-16725) Support to parse various timestamp data format in JSON

Classic

List

1 message

Jark Wu created FLINK-16725:
-------------------------------

Summary: Support to parse various timestamp data format in JSON
Key: FLINK-16725
URL: https://issues.apache.org/jira/browse/FLINK-16725
Project: Flink
Issue Type: New Feature
Components: Formats (JSON, Avro, Parquet, ORC, SequenceFile), Table SQL / Ecosystem
Reporter: Jark Wu

There are many users reported timestamp values can't be parsed even if the data type is specified as TIMESTAMP, see [1][2][3]. Currently, JSON format only allowed the timestamp data is in RFC-3339, i.e. "2019-07-09 02:02:00.040Z".

For usability, we should support various data format, including "2019-07-09 02:02:00.040".

[1]: http://apache-flink-user-mailing-list-archive.2336050.n4.nabble.com/TIME-TIMESTAMP-parse-in-Flink-TABLE-SQL-API-td33061.html
[2]: http://apache-flink.147419.n8.nabble.com/json-timestamp-json-flink-sql-td1914.html
[3]: http://apache-flink.147419.n8.nabble.com/FLINK-SQL-td2074.html

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