hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jason Dere (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-2558) Timestamp comparisons don't work
Date Fri, 24 Jan 2014 19:20:38 GMT

    [ https://issues.apache.org/jira/browse/HIVE-2558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13881331#comment-13881331
] 

Jason Dere commented on HIVE-2558:
----------------------------------

This has changed as of HIVE-5204 - the comparison is done as string

> Timestamp comparisons don't work
> --------------------------------
>
>                 Key: HIVE-2558
>                 URL: https://issues.apache.org/jira/browse/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 FunctionRegistry.java (591) . Yet whether we really want to have a linear hierarchy of
primitive types in the end, is another question.



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)

Mime
View raw message