You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Rajat (JIRA)" <ji...@apache.org> on 2017/06/26 10:56:00 UTC
[jira] [Comment Edited] (HIVE-12745) Hive Timestamp value change
after joining two tables
[ https://issues.apache.org/jira/browse/HIVE-12745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16062910#comment-16062910 ]
Rajat edited comment on HIVE-12745 at 6/26/17 10:55 AM:
--------------------------------------------------------
We have also faced the same issue.
We have a simple select statement having a join of two tables.
The timestamp columns are getting shifted back by 1 hour for one table.
Although, individually firing select query for each table is working fine as expected.
We are not able to find the root cause and still looking for it.
Can it be due to clock out of sync issue of one of the mapper/reducer node?
was (Author: srajat):
We have also faced the same issue.
We have a simple select statement fetching data using join of 2 tables.
The timestamp columns are getting shifted back by 1 hour for one table.
Although, individually firing select query for each table is working fine as expected.
We are not able to find the root cause and still looking for it.
Can it be due to clock out of sync issue of one of the mapper/reducer node?
> Hive Timestamp value change after joining two tables
> ----------------------------------------------------
>
> Key: HIVE-12745
> URL: https://issues.apache.org/jira/browse/HIVE-12745
> Project: Hive
> Issue Type: Bug
> Components: hpl/sql
> Affects Versions: 1.2.1
> Reporter: wyp
> Assignee: Dmitry Tolpeko
>
> I have two Hive tables:test and test1:
> {code}
> CREATE TABLE `test`( `t` timestamp)
> CREATE TABLE `test1`( `t` timestamp)
> {code}
> they all holds a t value with Timestamp datatype,the contents of the two table as follow:
> {code}
> hive> select * from test1;
> OK
> 1970-01-01 00:00:00
> 1970-03-02 00:00:00
> Time taken: 0.091 seconds, Fetched: 2 row(s)
> hive> select * from test;
> OK
> 1970-01-01 00:00:00
> 1970-01-02 00:00:00
> Time taken: 0.085 seconds, Fetched: 2 row(s)
> {code}
> However when joining this two table, the returned timestamp value changed:
> {code}
> hive> select test.t, test1.t from test, test1;
> OK
> 1969-12-31 23:00:00 1970-01-01 00:00:00
> 1970-01-01 23:00:00 1970-01-01 00:00:00
> 1969-12-31 23:00:00 1970-03-02 00:00:00
> 1970-01-01 23:00:00 1970-03-02 00:00:00
> Time taken: 54.347 seconds, Fetched: 4 row(s)
> {code}
> and I found the result is changed every time
> {code}
> hive> select test.t, test1.t from test, test1;
> OK
> 1970-01-01 00:00:00 1970-01-01 00:00:00
> 1970-01-02 00:00:00 1970-01-01 00:00:00
> 1970-01-01 00:00:00 1970-03-02 00:00:00
> 1970-01-02 00:00:00 1970-03-02 00:00:00
> Time taken: 26.308 seconds, Fetched: 4 row(s)
> {code}
> Any suggestion? Thanks
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)