[KYLIN-2539] Useless filter dimension will impact cuboid selection.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: v2.0.0
• Assignee: Hongbin Ma
• Reporter: Yifan Zhang
• Created: 10/Apr/17 10:56
• Updated: 30/Apr/17 12:21
• Resolved: 10/Apr/17 14:01

Description

Query1: select count from test_kylin_fact where (cal_dt > DATE'2012-01-01') and (seller_id is null or 1 = 1)
Query2: select count from test_kylin_fact where (cal_dt > DATE'2012-01-01')

Q1 and Q2 return identical result but hit different cuboid: 43051 and 1310735, and result in different query performance.