[
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
