Dean Wampler created HIVE-3108: ---------------------------------- Summary: SELECT count(DISTINCT col) ... returns 0 if "col" is a partition column Key: HIVE-3108 URL: https://issues.apache.org/jira/browse/HIVE-3108 Project: Hive Issue Type: Bug Components: Query Processor Affects Versions: 0.9.0, 0.8.0 Environment: Mac OSX running Apache distribution of hadoop and hive natively. Reporter: Dean Wampler
Suppose "stocks" is a managed OR external table, partitioned by "exchange" and "symbol". "count(DISTINCT x)" returns 0 for either "exchange", "symbol", or both: hive> SELECT count(DISTINCT exchange), count(DISTINCT symbol) from stocks; 0 0 -- 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