[ https://issues.apache.org/jira/browse/HIVE-3108?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13295072#comment-13295072 ]
Edward Capriolo commented on HIVE-3108: --------------------------------------- I am guessing he things that HIVE-2955 is patch available and is the same issue as this one. If that is that case we should just close this as a duplicate. > 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.8.0, 0.9.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