[ https://issues.apache.org/jira/browse/KYLIN-5763?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
pengfei.zhan updated KYLIN-5763: -------------------------------- Description: If there are many queryHistory records, 1) filtering them by query object is very slow; 2) searching them by key(the model name) cannot work. However, executing query in mysql, the result responses very fast. {code:java} select distinct model from kylin_query_history_realization where project_name = "abc"; select distinct engine_type from kylin_query_history where engine_type <> 'NATIVE' and project_name = "abc"; {code} was: The following sql can not match index just has dimension lstg_format_name. {code:sql} select max(lstg_format_name) max1, max( case when 1=1 then lstg_format_nameend ) max2 from test_kylin_fact{code} > Very slow to filter query history > --------------------------------- > > Key: KYLIN-5763 > URL: https://issues.apache.org/jira/browse/KYLIN-5763 > Project: Kylin > Issue Type: Bug > Components: Query Engine > Affects Versions: 5.0-beta > Reporter: pengfei.zhan > Assignee: pengfei.zhan > Priority: Major > Fix For: 5.0-beta > > > If there are many queryHistory records, > 1) filtering them by query object is very slow; > 2) searching them by key(the model name) cannot work. > > However, executing query in mysql, the result responses very fast. > {code:java} > select distinct model from kylin_query_history_realization > where project_name = "abc"; > select distinct engine_type from kylin_query_history where engine_type <> > 'NATIVE' and project_name = "abc"; > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)