You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Adam Kramer (JIRA)" <ji...@apache.org> on 2009/08/23 21:35:59 UTC
[jira] Created: (HIVE-783) Implement disjunctive JOINs
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.
[jira] Commented: (HIVE-783) Implement disjunctive JOINs
Posted by "Adam Kramer (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Updated: (HIVE-783) Implement disjunctive JOINs
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-783:
--------------------------------
Component/s: Query Processor
> Implement disjunctive JOINs
> ----------------------------
>
> Key: HIVE-783
> URL: https://issues.apache.org/jira/browse/HIVE-783
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> 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.