[jira] [Created] (KYLIN-1643) Kylin's hll counter count "NULL" as a value

["Shaofeng SHI (JIRA)" <ji...@apache.org>]

Shaofeng SHI created KYLIN-1643:
-----------------------------------

             Summary: Kylin's hll counter count "NULL" as a value
                 Key: KYLIN-1643
                 URL: https://issues.apache.org/jira/browse/KYLIN-1643
             Project: Kylin
          Issue Type: Bug
          Components: General
            Reporter: Shaofeng SHI
            Assignee: Shaofeng SHI


Reported by Xie Linjiong, he found Kylin's HyperLogLog count NULL as 1, but Hive count it as 0; Below is a sample:


A. source table:
hive> select * from temp.temp_kylin_null_test_20160429;
OK
10003	NULL
10002	NULL
10001	male

B. hive's query result:
hive> select count(distinct gender)],count(*) from temp.temp_kylin_null_test_20160429 where user_id in (10002,10003);

OK
0	2

C. Kylin's query result:

1      2




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)