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)