Optimizer on partition field
----------------------------
Key: HIVE-2119
URL: https://issues.apache.org/jira/browse/HIVE-2119
Project: Hive
Issue Type: Improvement
Reporter: Ron Bodkin
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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
