[
https://issues.apache.org/jira/browse/HIVE-16615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bing Li reassigned HIVE-16615:
------------------------------
Assignee: Bing Li
> Support Time Zone Specifiers (i.e. "at time zone X")
> ----------------------------------------------------
>
> Key: HIVE-16615
> URL: https://issues.apache.org/jira/browse/HIVE-16615
> Project: Hive
> Issue Type: Improvement
> Reporter: Carter Shanklin
> Assignee: Bing Li
>
> HIVE-14412 introduces a timezone-aware timestamp.
> SQL has a concept of "time zone specifier" which applies to any datetime
> value expression (which covers time/timestamp with and without timezones).
> Hive lacks a time type so we can put that aside for a while.
> Examples:
> a. select time_stamp_with_time_zone at time zone '-8:00';
> b. select time_stamp_without_time_zone at time zone LOCAL;
> These statements would adjust the expression from its original timezone into
> a known target timezone.
> Using the time zone specifier results in a data type that has a time zone.
> If the original expression lacked a time zone, the result has a time zone. If
> the original expression had a time zone, the result still has a time zone,
> possibly a different one.
> LOCAL means to use the session's original default time zone displacement.
> The standard says that dates are not supported with time zone specifiers. It
> seems common to ignore this rule and allow this, by converting the date to a
> timestamp and then applying the usual rule.
> The standard only requires an interval or the LOCAL keyword. Some databases
> allow time zone identifiers like PST.
> Reference: SQL:2011 section 6.31
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
