hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-3191) timestamp - timestamp causes null pointer exception
Date Mon, 25 Jun 2012 08:41:43 GMT

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

Navis commented on HIVE-3191:
-----------------------------

https://reviews.facebook.net/D3807

I have similar use cases in some legacy SQLs something like this..

select '2012-01-01 00:00:00' + ('2011-01-01 04:00:00.4567' - '2011-01-01 02:15:00.5678') ~~

The fetch made recently and under testing but I cannot get exact meaning of +/- between timestamp
values. Any suggestion or references would be greatly appreciated.
                
> 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: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message