hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dean Wampler (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-3929) wiki documentation for partition filtering and outer joins doesn't match behavior
Date Wed, 23 Jan 2013 15:06:12 GMT

     [ https://issues.apache.org/jira/browse/HIVE-3929?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Dean Wampler updated HIVE-3929:
-------------------------------

    Summary: wiki documentation for partition filtering and outer joins doesn't match behavior
 (was: wiki documentation for partition filtering and out joins doesn't match behavior)
    
> wiki documentation for partition filtering and outer 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.7.0, 0.8.1, 0.9.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

Mime
View raw message