You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Navis (JIRA)" <ji...@apache.org> on 2012/06/25 10:41:43 UTC
[jira] [Commented] (HIVE-3191) timestamp - timestamp causes null
pointer exception
[ 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