[
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)
