Uploaded image for project: 'Flink'
  1. Flink
  2. FLINK-16725

Support to parse various timestamp data format in JSON

    XMLWordPrintableJSON

Details

    Description

      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

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. FLINK-17752 Align the timestamp format with Flink SQL types in JSON format

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              Unassigned Unassigned
              jark Jark Wu
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: