Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-3504

Add utc_timestamp() function for current timestamp in UTC

    Details

      Description

      Impala badly needs a way to generate a UTC timestamp.

      Current there does not appear to be such a way.

      unix_timestamp() does not actually return a timestamp, but a epoch time as an integer.

      Trying to convert this to a timestamp using cast() or from_unixtime() fail because they both convert to Local time.

      This could be implemented either as a timezone argument to now() or from_unixtime(), so we can ask for a timestamp in UTC.

      Yes, there is a to_utc_timestamp() function, but that requires you to specify the timezone of the timestamp you are converting from.

      I just want something like current_utctimestamp().

        Attachments

          Activity

            People

            • Assignee:
              bikramjeet.vig Bikramjeet Vig
              Reporter:
              squiggly kuduser
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: