[jira] [Created] (HIVE-3929) wiki documentation for partition filtering and out joins doesn't match behavior

["Dean Wampler (JIRA)" <ji...@apache.org>]

Dean Wampler created HIVE-3929:
----------------------------------

             Summary: wiki documentation for partition filtering and out joins doesn't match behavior
                 Key: HIVE-3929
                 URL: https://issues.apache.org/jira/browse/HIVE-3929
             Project: Hive
          Issue Type: Bug
          Components: Documentation
    Affects Versions: 0.9.0, 0.8.1, 0.7.0, 0.10.0
         Environment: Linux
            Reporter: Dean Wampler


The wiki discussion of OUTER JOINs correctly describes the behavior of WHERE clauses with regards to partition filters. Namely, that they don't work as expected, because the WHERE clause is evaluated after the join has been performed.

However, the description then says that you can move these partition filters into the ON clause to achieve partition filtering. In fact, these filters have no effect. 

The only working solution I know of is to use nested SELECTS that apply the partition filters, then join on the results.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira