[jira] Updated: (HIVE-783) Implement disjunctive JOINs

["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.