You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Shaofeng SHI (JIRA)" <ji...@apache.org> on 2016/05/03 11:06:13 UTC

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

     [ https://issues.apache.org/jira/browse/KYLIN-1643?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Shaofeng SHI updated KYLIN-1643:
--------------------------------
    Fix Version/s: v1.5.2

> 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
>             Fix For: v1.5.2
>
>
> 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)