[
https://issues.apache.org/jira/browse/HIVE-16614?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Carter Shanklin updated HIVE-16614:
-----------------------------------
Description:
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
was:
HIVE-14412 introduces a timestamp-aware timezone.
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
> 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
>
> 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
(v6.3.15#6346)
