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
