Alex Rovner created HIVE-3046: --------------------------------- Summary: Hive should use metastore to calculate max() on a partition Key: HIVE-3046 URL: https://issues.apache.org/jira/browse/HIVE-3046 Project: Hive Issue Type: Improvement Affects Versions: 0.7.1 Reporter: Alex Rovner
Assume you have a table with two partitioned columns: refdate and client_id The following query runs a table scan instead of using partition metadata: SELECT MAX(date) FROM mytable WHERE client_id=1 AND refdate >= 20120101 -- 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