You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Thejas M Nair (JIRA)" <ji...@apache.org> on 2014/03/07 12:13:44 UTC

[jira] [Commented] (HIVE-6581) vectorization_decimal_date.q is dependent on local host timezone

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

Thejas M Nair commented on HIVE-6581:
-------------------------------------

AFAIK, the build/test scripts are supposed to set the timezone to US/Pacific for consistent results.
I see that pom.xml sets            <TZ>US/Pacific</TZ>.

> vectorization_decimal_date.q is dependent on local host timezone
> ----------------------------------------------------------------
>
>                 Key: HIVE-6581
>                 URL: https://issues.apache.org/jira/browse/HIVE-6581
>             Project: Hive
>          Issue Type: Test
>            Reporter: Remus Rusanu
>            Assignee: Teddy Choi
>
> Running vectorization_decimal_date.q fails in eastern hemisphere due to result diffs. In my GMT+2 zone, the first column returns "1970-01-07". This comes from the  CAST (CAST (cint AS TIMESTAMP) AS DATE) AS cdate expression in the CTAS, this returns different dates on depending on local timezone (in row-mode, this is not a vectorization issue).



--
This message was sent by Atlassian JIRA
(v6.2#6252)