Jesus Camacho Rodriguez commented on HIVE-16614:

[~findepi], issue is HIVE-12192. We can continue the discussion over there.

> Support "set local time zone" statement
> ---------------------------------------
>                 Key: HIVE-16614
>                 URL: https://issues.apache.org/jira/browse/HIVE-16614
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Carter Shanklin
>            Assignee: Jesus Camacho Rodriguez
>            Priority: Major
>              Labels: TODOC3.0
>             Fix For: 3.0.0
>         Attachments: HIVE-16614.01.patch, HIVE-16614.02.patch, 
> HIVE-16614.03.patch, HIVE-16614.04.patch, HIVE-16614.05.patch, 
> HIVE-16614.patch
> HIVE-14412 introduces a timezone-aware timestamp.
> SQL has a concept of default time zone displacements, which are transparently 
> applied when converting between timezone-unaware types and timezone-aware 
> types and, in Hive's case, are also used to shift a timezone aware type to a 
> different time zone, depending on configuration.
> SQL also provides that the default time zone displacement be settable at a 
> session level, so that clients can access a database simultaneously from 
> different time zones and see time values in their own time zone.
> Currently the time zone displacement is fixed and is set based on the system 
> time zone where the Hive client runs (HiveServer2 or Hive CLI). It will be 
> more convenient for users if they have the ability to set their time zone of 
> choice.
> SQL defines "set time zone" with 2 ways of specifying the time zone, first 
> using an interval and second using the special keyword LOCAL.
> Examples:
>       • set time zone '-8:00';
>       • set time zone LOCAL;
> LOCAL means to set the current default time zone displacement to the 
> session's original default time zone displacement.
> Reference: SQL:2011 section 19.4

This message was sent by Atlassian JIRA

Reply via email to