You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by "Yifan Zhang (JIRA)" <ji...@apache.org> on 2017/04/10 10:56:41 UTC
[jira] [Created] (KYLIN-2539) Useless filter dimension will impact
cuboid selection.
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)