[
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
