Yifan Zhang created KYLIN-2539:
----------------------------------

             Summary: Useless filter dimension will impact cuboid selection.
                 Key: KYLIN-2539
                 URL: https://issues.apache.org/jira/browse/KYLIN-2539
             Project: Kylin
          Issue Type: Bug
            Reporter: Yifan Zhang


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.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to