hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hive QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-16614) Support "set local time zone" statement
Date Thu, 24 Aug 2017 06:42:00 GMT

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

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.patch

{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 executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[localtimezone] (batchId=51)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[timestamptz] (batchId=61)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[timestamptz_1] (batchId=56)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[timestamptz_2] (batchId=76)
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[spark_vectorized_dynamic_partition_pruning]
(batchId=169)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14] (batchId=235)
org.apache.hive.hcatalog.api.TestHCatClient.testPartitionRegistrationWithCustomSchema (batchId=180)
org.apache.hive.hcatalog.api.TestHCatClient.testPartitionSpecRegistrationWithCustomSchema
(batchId=180)
org.apache.hive.hcatalog.api.TestHCatClient.testTableSchemaPropagation (batchId=180)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/6509/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/6509/console
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 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.4.14#64029)

Mime
View raw message