[ https://issues.apache.org/jira/browse/HIVE-783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12896331#action_12896331 ]
Adam Kramer commented on HIVE-783: ---------------------------------- Also fails: a JOIN b ON (a.key < b.key), for a perhaps unrelated reason. > Implement disjunctive JOINs > ---------------------------- > > Key: HIVE-783 > URL: https://issues.apache.org/jira/browse/HIVE-783 > Project: Hadoop Hive > Issue Type: New Feature > Reporter: Adam Kramer > > Currently, Hive does not allow disjunctive joins. For example: > SELECT ... > FROM a > JOIN b ON (a.key1=b.key1 OR a.key1=b.key2) > ...currently fails. The current workaround is to join on each, UNION ALL > them, and then somehow figure out a way to remove any duplicates (wher > b.key1=b.key2 and there's a corresponding a.key1)...but this involves many > passes through the same data. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.