[
https://issues.apache.org/jira/browse/HIVE-11596?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14705906#comment-14705906
]
Chao Sun commented on HIVE-11596:
---------------------------------
+1
> nvl(x, y) throws NPE if type x and type y doesn't match, rather than throwing
> the meaningful error
> --------------------------------------------------------------------------------------------------
>
> Key: HIVE-11596
> URL: https://issues.apache.org/jira/browse/HIVE-11596
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Affects Versions: 2.0.0
> Reporter: Aihua Xu
> Assignee: Aihua Xu
> Priority: Minor
> Fix For: 2.0.0
>
> Attachments: HIVE-11596.patch
>
>
> {noformat}
> create table test(key string);
> select nvl(key, true) from test;
> {noformat}
> The query above will throw NPE rather than the meaningful error "The first
> and seconds arguments of function NLV should have the same type".
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
