[
https://issues.apache.org/jira/browse/KYLIN-2539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15962833#comment-15962833
]
hongbin ma commented on KYLIN-2539:
-----------------------------------
I added a org.apache.kylin.metadata.filter.FilterOptimizeTransformer to detect
patterns like (x = ? or 1 = 1) and replace such patterns with
ConstantTupleFilter.TRUE
> 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)
