[ 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