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

Support converting BIGINT to TIMESTAMP for TO_TIMESTAMP function

    XMLWordPrintableJSON

Details

    Description

      Many users reported that it is not possible for now to define an event-time field or watermark on a BIGINT column.

      Impala supports to convert BIGINT into TIMESTAMP value using TO_TIMESTAMP() function [1]. The BIGINT argument represents the number of seconds past the epoch.

      I think it makes sense to support this for Flink's TO_TIMESTAMP(). It is the converse of the UNIX_TIMESTAMP() function, which produces a BIGINT representing the number of seconds past the epoch.

      [1]: https://impala.apache.org/docs/build/html/topics/impala_datetime_functions.html#datetime_functions__to_timestamp

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: