Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Fri, 10 Feb 2017 09:59:41 +0000 (UTC)
From: "Jesus Camacho Rodriguez (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.13041703.1486647118000.47228.1486720781736@Atlassian.JIRA>
In-Reply-To: <JIRA.13041703.1486647118000@Atlassian.JIRA>
References: <JIRA.13041703.1486647118000@Atlassian.JIRA> <JIRA.13041703.1486647118813@jira-lw-us.apache.org>
Subject: [jira] [Issue Comment Deleted] (HIVE-15863) Calendar inside DATE,
 TIME and TIMESTAMP literals for Calcite should have UTC timezone
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Fri, 10 Feb 2017 09:59:49 -0000


     [ https://issues.apache.org/jira/browse/HIVE-15863?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jesus Camacho Rodriguez updated HIVE-15863:
-------------------------------------------
    Comment: was deleted

(was: 

Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12851929/HIVE-15863.patch

{color:red}ERROR:{color} -1 due to no test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 11 failed/errored test(s), 10242 tests executed
*Failed tests:*
{noformat}
TestDerbyConnector - did not produce a TEST-*.xml file (likely timed out) (batchId=235)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[date_1] (batchId=73)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[date_udf] (batchId=29)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[interval_alt] (batchId=3)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[json_serde1] (batchId=32)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[partition_date] (batchId=13)
org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver[encryption_join_with_different_encryption_keys] (batchId=159)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14] (batchId=223)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[date_udf] (batchId=109)
org.apache.hive.jdbc.TestJdbcDriver2.testPrepareStatement (batchId=215)
org.apache.hive.jdbc.TestMultiSessionsHS2WithLocalClusterSpark.testSparkQuery (batchId=217)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/3470/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/3470/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-3470/

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: 11 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12851929 - PreCommit-HIVE-Build)

> Calendar inside DATE, TIME and TIMESTAMP literals for Calcite should have UTC timezone
> --------------------------------------------------------------------------------------
>
>                 Key: HIVE-15863
>                 URL: https://issues.apache.org/jira/browse/HIVE-15863
>             Project: Hive
>          Issue Type: Bug
>          Components: CBO
>    Affects Versions: 2.2.0
>            Reporter: Jesus Camacho Rodriguez
>            Assignee: Jesus Camacho Rodriguez
>         Attachments: HIVE-15863.patch
>
>
> Related to CALCITE-1623.
> At query preparation time, Calcite uses a Calendar to hold the value of DATE, TIME, TIMESTAMP literals. It assumes that Calendar has a UTC (GMT) time zone, and bad things might happen if it does not. Currently, we pass the Calendar object with user timezone from Hive. We need to pass it with UTC timezone and make the inverse conversion when we go back from Calcite to Hive.


--
This message was sent by Atlassian JIRA
(v6.3.15#6346)