Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Thu, 24 Aug 2017 06:42:00 +0000 (UTC)
From: "Hive QA (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.13070412.1494336741000.109263.1503556920210@Atlassian.JIRA>
In-Reply-To: <JIRA.13070412.1494336741000@Atlassian.JIRA>
References: <JIRA.13070412.1494336741000@Atlassian.JIRA> <JIRA.13070412.1494336741105@jira-lw-us.apache.org>
Subject: [jira] [Commented] (HIVE-16614) Support "set local time zone"
 statement
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
archived-at: Thu, 24 Aug 2017 06:42:05 -0000


    [ https://issues.apache.org/jira/browse/HIVE-16614?page=3Dcom.atlassian=
.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D1613=
9639#comment-16139639 ]=20

Hive QA commented on HIVE-16614:
--------------------------------


Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12883419/HIVE-16614.04.pat=
ch

{color:green}SUCCESS:{color} +1 due to 4 test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 9 failed/errored test(s), 11001 tests ex=
ecuted
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[localtimezone] (batc=
hId=3D51)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[timestamptz] (batchI=
d=3D61)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[timestamptz_1] (batc=
hId=3D56)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[timestamptz_2] (batc=
hId=3D76)
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[spark=
_vectorized_dynamic_partition_pruning] (batchId=3D169)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14] (batchI=
d=3D235)
org.apache.hive.hcatalog.api.TestHCatClient.testPartitionRegistrationWithCu=
stomSchema (batchId=3D180)
org.apache.hive.hcatalog.api.TestHCatClient.testPartitionSpecRegistrationWi=
thCustomSchema (batchId=3D180)
org.apache.hive.hcatalog.api.TestHCatClient.testTableSchemaPropagation (bat=
chId=3D180)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/6509/testR=
eport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/6509/con=
sole
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-6509/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 9 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12883419 - PreCommit-HIVE-Build

> 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
>         Attachments: HIVE-16614.01.patch, HIVE-16614.02.patch, HIVE-16614=
.03.patch, HIVE-16614.04.patch, HIVE-16614.patch
>
>
> HIVE-14412 introduces a timezone-aware timestamp.
> SQL has a concept of default time zone displacements, which are transpare=
ntly applied when converting between timezone-unaware types and timezone-aw=
are 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 sys=
tem 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 zo=
ne of choice.
> SQL defines "set time zone" with 2 ways of specifying the time zone, firs=
t using an interval and second using the special keyword LOCAL.
> Examples:
> =09=E2=80=A2 set time zone '-8:00';
> =09=E2=80=A2 set time zone LOCAL;
> LOCAL means to set the current default time zone displacement to the sess=
ion's original default time zone displacement.
> Reference: SQL:2011 section 19.4


--
This message was sent by Atlassian JIRA
(v6.4.14#64029)