[ https://issues.apache.org/jira/browse/HIVE-741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ning Zhang updated HIVE-741: ---------------------------- Description: With the following data in table input4_cb: Key Value ------ -------- NULL 325 18 NULL The following query: {code} select * from input4_cb a join input4_cb b on a.key = b.value; {code} returns the following result: NULL 325 18 NULL The correct result should be empty set. When 'null' is replaced by '' it works. was: This command fails with the following error: {code} hive/bin/hive -e "INSERT OVERWRITE LOCAL DIRECTORY 'abc' select null from zshao_tt" FAILED: Error in semantic analysis: java.lang.RuntimeException: Internal error: Cannot find ObjectInspector for VOID {code} When 'null' is replaced by '' it works. > NULL is not handled correctly in join > ------------------------------------- > > Key: HIVE-741 > URL: https://issues.apache.org/jira/browse/HIVE-741 > Project: Hadoop Hive > Issue Type: Bug > Reporter: Ning Zhang > Assignee: Ning Zhang > > With the following data in table input4_cb: > Key Value > ------ -------- > NULL 325 > 18 NULL > The following query: > {code} > select * from input4_cb a join input4_cb b on a.key = b.value; > {code} > returns the following result: > NULL 325 18 NULL > The correct result should be empty set. > When 'null' is replaced by '' it works. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.