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)
