Sergey Shelukhin created HIVE-5658:
--------------------------------------
Summary: count(distinct) produces confusing results for null
Key: HIVE-5658
URL: https://issues.apache.org/jira/browse/HIVE-5658
Project: Hive
Issue Type: Bug
Reporter: Sergey Shelukhin
{code}
select csmallint, count(distinct(csmallint)) from alltypesorc group by
csmallint limit 3;
{code}
produces:
{noformat}
NULL 0
-16379 1
-16373 1
{noformat}
There are records in table with NULL values; however the count in this case
should be 1, not 0, it seems
--
This message was sent by Atlassian JIRA
(v6.1#6144)
