[HIVE-10488] cast DATE as TIMESTAMP returns incorrect values

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Cannot Reproduce
• Affects Version/s: 0.13.1
• Component/s: SQL
• Assignee: Chaoyu Tang
• Reporter: N Campbell
• Created: 26/Apr/15 14:54
• Updated: 01/May/15 00:51
• Resolved: 01/May/15 00:51

Description

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