[KYLIN-4601] Kylin 3.0 results problem

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Measure - Count Distinct
• Environment: Kylin 3.0.0
• Assignee: Unassigned
• Reporter: Yuanxiqiang
• Created: 24/Jun/20 10:39
• Updated: 24/Jun/20 10:39

Description

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