Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-1643

Kylin's hll counter count "NULL" as a value

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: v1.5.2
    • Component/s: Others
    • Labels:
      None

      Description

      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

        Attachments

          Activity

            People

            • Assignee:
              shaofengshi Shao Feng Shi
              Reporter:
              shaofengshi Shao Feng Shi
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: