kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ZhouQianhao (JIRA)" <j...@apache.org>
Subject [jira] [Created] (KYLIN-747) bad query performance when IN clause contains a value doesn't exist in the dictionary
Date Fri, 01 May 2015 16:32:06 GMT
ZhouQianhao created KYLIN-747:
---------------------------------

             Summary: bad query performance when IN clause contains a value doesn't exist
in the dictionary
                 Key: KYLIN-747
                 URL: https://issues.apache.org/jira/browse/KYLIN-747
             Project: Kylin
          Issue Type: Bug
            Reporter: ZhouQianhao


For example, we had a query of 39 x values in where clause and there is one
x value not in cube,  which yielded the following result:

Duration: 60.947


Cube Names: [olap]

Total scan count: 2524898

Result row count: 39

(The log shows "Can't translate value xxx to dictionary ID, roundingFlag 0.
Using default value \xFF")



And we excluded the x value that is not in cube and re-run the query and got
the another result:

Duration: 2.477

Cube Names: [olap]

Total scan count: 96543

Result row count: 38



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message