hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Surówka (Created) (JIRA) <>
Subject [jira] [Created] (HIVE-2558) Timestamp comparisons don't work
Date Tue, 08 Nov 2011 00:58:52 GMT
Timestamp comparisons don't work

                 Key: HIVE-2558
             Project: Hive
          Issue Type: Bug
            Reporter: Robert Surówka

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 (591) . Yet whether we really want to have a linear hierarchy of primitive
types in the end, is another question.

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:!default.jspa
For more information on JIRA, see:


View raw message