Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-12191 Hive timestamp problems
  3. HIVE-12193

Add a consistent unix_timestamp function.

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.1.1
    • Fix Version/s: None
    • Component/s: Hive
    • Labels:

      Description

      The unix_timestamp function returns values with respect to the SQL session time zone (which is the default JVM time zone). This varies depending on server time zone. This is required by the documentation for the function and would be difficult to change.

      For users that want consistent results across zones, Hive should include a utc_timestamp method that is zone independent and gives a result assuming the timestamp without time zone passed in is in UTC.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              rdblue Ryan Blue
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: