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)