[KYLIN-4457] Query cube result doesn't math with spark sql

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Bug
• Fix Version/s: v4.0.0-alpha
• Component/s: Query Engine, Storage - Parquet
• Sprint: Sprint 49
• Assignee: Wang Rupeng
• Reporter: xuekaiqi
• Created: 17/Apr/20 10:01
• Updated: 13/Sep/20 12:19
• Resolved: 23/Apr/20 07:16

Description

Source: local CSV
Result:

cube	spark
5010	5030

SQL:

select count(*)  FROM TEST_KYLIN_FACT LEFT JOIN TEST_ORDER ON TEST_KYLIN_FACT.ORDER_ID = TEST_ORDER.ORDER_ID where CAL_DT > '2011-01-01 00:00:00' and CAL_DT < '2013-01-01 00:00:00'