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)
