hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jesus Camacho Rodriguez (JIRA)" <>
Subject [jira] [Updated] (HIVE-12193) Add a consistent unix_timestamp function.
Date Thu, 26 Oct 2017 23:34:00 GMT


Jesus Camacho Rodriguez updated HIVE-12193:
    Labels: timestamp  (was: )

> Add a consistent unix_timestamp function.
> -----------------------------------------
>                 Key: HIVE-12193
>                 URL:
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Hive
>    Affects Versions: 1.1.1
>            Reporter: Ryan Blue
>              Labels: timestamp
> 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.

This message was sent by Atlassian JIRA

View raw message