[ https://issues.apache.org/jira/browse/HIVE-3108?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-3108: --------------------------------- Status: Open (was: Patch Available) @Arun: Doesn't look like there's a patch here. Not sure why you changed the status to Patch Available. > 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 > Labels: Hive > > 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