hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "S. Alex Smith (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-459) Allow limited 'OR' in join clauses
Date Wed, 29 Apr 2009 23:19:30 GMT
Allow limited 'OR' in join clauses

                 Key: HIVE-459
                 URL: https://issues.apache.org/jira/browse/HIVE-459
             Project: Hadoop Hive
          Issue Type: Improvement
          Components: Query Processor
            Reporter: S. Alex Smith
            Priority: Minor

A (somewhat) common use case for full outer joins is

FULL OUTER JOIN b ON (b.foo = a.foo)
FULL OUTER JOIN c ON (c.foo = a.foo OR c.foo = b.foo)

It would be nice if this (or equivalent functionality) could be supported by hive.  Note that
this is a specific use of OR that would allow rows from all three tables to be clustered on
the same key.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message