Yuanxiqiang created KYLIN-4601:
----------------------------------

             Summary: Kylin 3.0 results problem
                 Key: KYLIN-4601
                 URL: https://issues.apache.org/jira/browse/KYLIN-4601
             Project: Kylin
          Issue Type: Bug
          Components: Measure - Count Distinct
         Environment: Kylin 3.0.0
            Reporter: Yuanxiqiang


I use kylin 3.0 to build day, week and month cubes.
The daily data is about 80 million, the weekly data is about 560 million and 
the monthly data is about 2.5 billion.
When cube built, the daily results and weekly results are consistent through 
cube query and direct sql query.
But the results of monthly results are different, count (1) and count 
(distinct) are not correct.

In version 2.6.2 they are all correct.

What parameters do I need to configure? or a bug?

sql:
 monthcode | times | usernum 
-----------+-------+---------
 202005    |  4647 |    3141 

cube:
MONTHCODE       TIMES USERNUM
202005  4640    3



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to