You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Sergey Shelukhin (JIRA)" <ji...@apache.org> on 2013/10/26 03:36:30 UTC

[jira] [Created] (HIVE-5658) count(distinct) produces confusing results for null

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)