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-3191) timestamp - timestamp causes null pointer exception
Date Wed, 07 Aug 2013 22:18:49 GMT

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

Jason Dere commented on HIVE-3191:
----------------------------------

Looking at the diff, I think timestamp - timestamp should not return a timestamp result, as
you can see in the test case the results formatted to string don't look correct ('2011-01-01
01:01:02.4567 - '1970-01-01 01:01:01.5678' = 2011-01-01 00:00:00.8889).  Date/timestamp arithmetic
should be really be returning an INTERVAL type as the result.

So let's do the quick fix to avoid NPE here, and hopefully support interval data type in future
work.  In the meantime users can cast/convert the timestamp to a numeric value and perform
arithmetic operations. 
                
> timestamp - timestamp causes null pointer exception
> ---------------------------------------------------
>
>                 Key: HIVE-3191
>                 URL: https://issues.apache.org/jira/browse/HIVE-3191
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.8.0
>            Reporter: N Campbell
>
> select tts.rnum, tts.cts - tts.cts from cert.tts tts
> Error: Query returned non-zero code: 12, cause: FAILED: Hive Internal Error: java.lang.NullPointerException(null)
> SQLState:  42000
> ErrorCode: 12
> create table if not exists CERT.TTS ( RNUM int , CTS timestamp) 
> stored as sequencefile;

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message