You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Ashutosh Chauhan (Resolved) (JIRA)" <ji...@apache.org> on 2011/10/31 18:39:33 UTC

[jira] [Resolved] (HIVE-2119) Optimizer on partition field

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

Ashutosh Chauhan resolved HIVE-2119.
------------------------------------

       Resolution: Fixed
    Fix Version/s: 0.9.0

Fixed as part of HIVE-1003
                
> Optimizer on partition field
> ----------------------------
>
>                 Key: HIVE-2119
>                 URL: https://issues.apache.org/jira/browse/HIVE-2119
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Ron Bodkin
>             Fix For: 0.9.0
>
>
> The optimizer doesn't use partition metadata, e.g.,
> select max(dt) from big_partitioned_table;
> Instead of just returning the biggest date in the table, it runs a full table scan. This kind of expression can also be useful in more interesting cases like:
> select count(*) from big_partitioned_table a join (select max(dt) m from big_partitioned_table) b on a.dt=b.m;

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira