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.