hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Adam Kramer (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-783) Implement disjunctive JOINs
Date Sun, 23 Aug 2009 19:35:59 GMT
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.


Mime
View raw message