You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@kylin.apache.org by "hongbin ma (JIRA)" <ji...@apache.org> on 2017/04/10 14:01:41 UTC

[jira] [Resolved] (KYLIN-2539) Useless filter dimension will impact cuboid selection.

     [ https://issues.apache.org/jira/browse/KYLIN-2539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

hongbin ma resolved KYLIN-2539.
-------------------------------
       Resolution: Fixed
         Assignee: hongbin ma
    Fix Version/s: v2.0.0

> 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
>            Assignee: hongbin ma
>             Fix For: v2.0.0
>
>
> 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)