[HIVE-2558] Timestamp comparisons don't work

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.12.0
• Assignee: Unassigned
• Reporter: Robert Surówka
• Created: 08/Nov/11 00:57
• Updated: 24/Jan/14 19:20
• Resolved: 24/Jan/14 19:20

Description

I may be missing something, but:

After performing:

create table rrt (r timestamp);
insert into table rrt select '1970-01-01 00:00:01' from src limit 1;

Following queries give undesirable results:

select * from rrt where r in ('1970-01-01 00:00:01');
select * from rrt where r in (0);
select * from rrt where r = 0;
select * from rrt where r = '1970-01-01 00:00:01';

At least for the first two, the reason may be the lack of timestamp in numericTypes Map from FunctionRegistry.java (591) . Yet whether we really want to have a linear hierarchy of primitive types in the end, is another question.