You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@flink.apache.org by "Jark Wu (Jira)" <ji...@apache.org> on 2020/03/23 12:36:00 UTC

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

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)