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

unix_timestamp() documentation doesn't mention unit

    XMLWordPrintableJSON

    Details

    • Type: Documentation
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Impala 2.10.0
    • Fix Version/s: Impala 2.10.0
    • Component/s: Docs
    • Labels:
      None
    • Epic Color:
      ghx-label-8

      Description

      When reading through the docs I noticed that unix_timestamp() doesn't explicitly say what unit it returns (I believe it is seconds). I saw this create some confusion for a user: http://community.cloudera.com/t5/Interactive-Short-cycle-SQL/Get-timestamp-in-milliseconds-in-Impala/m-p/61214#M3755?eid=1&aid=1

      See https://impala.incubator.apache.org/docs/build/html/topics/impala_datetime_functions.html

      Purpose: Returns an integer value representing the current date and time as a delta from the Unix epoch, or converts from a specified date and time value represented as a TIMESTAMP or STRING.

        Attachments

          Activity

            People

            • Assignee:
              arodoni Alexandra Rodoni
              Reporter:
              tarmstrong Tim Armstrong
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: