[jira] [Commented] (HIVE-12751) Fix NVL explain syntax

[Gopal V (JIRA)]

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

Gopal V commented on HIVE-12751:
--------------------------------

[~pxiong]: trivial case, so I patched it myself

{code}
             Select Operator
-              expressions: cfloat (type: float), if cfloat is null returns1 
(type: float)
+              expressions: cfloat (type: float), NVL(cfloat,1) (type: float)
               outputColumnNames: _col0, _col1
{code}

> Fix NVL explain syntax
> ----------------------
>
>                 Key: HIVE-12751
>                 URL: https://issues.apache.org/jira/browse/HIVE-12751
>             Project: Hive
>          Issue Type: Improvement
>          Components: UDF
>    Affects Versions: 2.0.0
>            Reporter: Gopal V
>            Assignee: Gopal V
>         Attachments: HIVE-12751.1.patch
>
>
> {code}
> predicate: (not if (key = '238') is null returnsfalse) (type: boolean)
> {code}
> At best is confusing to a user who used an {{NVL}} udf. The best 
> representation is {{NVL(a,b)}} as is.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)