[
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
