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