[
https://issues.apache.org/jira/browse/HIVE-21721?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838095#comment-16838095
]
philipse commented on HIVE-21721:
---------------------------------
Thanks Gopal for your concern, but i also encounter other type mismatch
cases,which also return the NullPointerException, it seems it will occurs for
nvl function if the types are not the same or cannot do implicitly cast.
!image-2019-05-12-23-47-49-401.png!
> nvl function fail with NullPointerException if the two paramtype are different
> ------------------------------------------------------------------------------
>
> Key: HIVE-21721
> URL: https://issues.apache.org/jira/browse/HIVE-21721
> Project: Hive
> Issue Type: Bug
> Components: Parser
> Affects Versions: 1.1.0
> Reporter: philipse
> Assignee: philipse
> Priority: Blocker
> Labels: pull-request-available
> Attachments: image-2019-05-11-10-41-05-168.png,
> image-2019-05-12-23-47-49-401.png
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Hi all
> when i user nvl and case when fucntion, it behaviors like the following.which
> is weird to me, and makes me headache everytime. i need to check where the
> nullpointexception throws out when it hadppens,So can the reasons more
> friendly to users,
> !image-2019-05-11-10-41-05-168.png!
> {code:java}
> select nvl(cast('2019-05-10 11:11:11,111' as timestamp),'2019-05-10
> 11:11:11,111');
> Error: Error while compiling statement: FAILED: NullPointerException null
> (state=42000,code=40000)
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
