[
https://issues.apache.org/jira/browse/HIVE-16614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16425288#comment-16425288
]
Piotr Findeisen commented on HIVE-16614:
----------------------------------------
bq. Finally, I will create a follow-up to fix 'TIMESTAMP' type semantics so
they are not dependent on the system timezone anymore. While 'TIMESTAMP' type
will be compliant with SQL semantics, I will also take care that we are
backwards compatible and old 'TIMESTAMP' typed values continue being accessible
in the same way. (More in the issue to come)
[~jcamachorodriguez], i tried to find the issue. Did you abandon the idea, or
i'm just searching the wrong way?
> 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
(v7.6.3#76005)
