[
https://issues.apache.org/jira/browse/KYLIN-747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
liyang updated KYLIN-747:
-------------------------
Assignee: ZhouQianhao
> 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
> Assignee: 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)
