[jira] [Created] (HIVE-10488) cast DATE as TIMESTAMP returns incorrect values

["N Campbell (JIRA)" <ji...@apache.org>]

N Campbell created HIVE-10488:
---------------------------------

             Summary: cast DATE as TIMESTAMP returns incorrect values
                 Key: HIVE-10488
                 URL: https://issues.apache.org/jira/browse/HIVE-10488
             Project: Hive
          Issue Type: Bug
          Components: SQL
    Affects Versions: 0.13.1
            Reporter: N Campbell


same data in textfile works
same data loaded into an ORC table does not
connection property of tez/mr makes no difference.

select rnum, cdt, cast (cdt as timestamp) from tdt
0	<null>	<null>
1	1996-01-01	1969-12-31 19:00:09.496
2	2000-01-01	1969-12-31 19:00:10.957
3	2000-12-31	1969-12-31 19:00:11.322

vs

0	<null>	<null>
1	1996-01-01	1996-01-01 00:00:00.0
2	2000-01-01	2000-01-01 00:00:00.0
3	2000-12-31	2000-12-31 00:00:00.0

create table  if not exists TDT ( RNUM int , CDT date   )
 STORED AS orc  ;

insert overwrite table TDT select * from  text.TDT;

0|\N
1|1996-01-01
2|2000-01-01
3|2000-12-31




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)