[jira] [Resolved] (KYLIN-5763) Very slow to filter query history

["pengfei.zhan (Jira)" <ji...@apache.org>]

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

pengfei.zhan resolved KYLIN-5763.
---------------------------------
    Resolution: Fixed

> 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:sql}
> 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)