[ https://issues.apache.org/jira/browse/HIVE-3046?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Capriolo resolved HIVE-3046. ----------------------------------- Resolution: Not A Problem Release Note: I think this query can not be done by putting a condition on a non partition column you are forcing hive to query non-metadata. Hive has to do this because if there is no userid=1 then hive returns 0 rows. Else it returns one row. > 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