[ 
https://issues.apache.org/jira/browse/HIVE-1237?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ashutosh Chauhan updated HIVE-1237:
-----------------------------------

    Attachment: hive-1237_1.patch

I think for coalesce it makes sense to have atleast two arguments. It returns 
first non-null of its argument. If there is zero argument there is nothing to 
return and if there is one argument it has to return that whether its null or 
not. I updated the patch to throw exception if there are less then two 
arguments.
                
> select coalesce(null) from src dies
> -----------------------------------
>
>                 Key: HIVE-1237
>                 URL: https://issues.apache.org/jira/browse/HIVE-1237
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Namit Jain
>            Assignee: Ashutosh Chauhan
>         Attachments: hive-1237.patch, hive-1237_1.patch
>
>
> select coalesce(null) from src ;
> FAILED: Unknown exception: null

--
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

        

Reply via email to