[ https://issues.apache.org/jira/browse/KYLIN-5763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17832341#comment-17832341 ]
pengfei.zhan commented on KYLIN-5763: ------------------------------------- h1. Design The response body payload is transformed from a list of strings to an object, where * `search_count` is the total number of matches for front-end display, * `total_model_count` is the total number of unfiltered models without limit for front-end display, * `engines` is the list of engines, and `models` is the list of models. `engines` is the list of engines and `models` is the list of models. Example: * before modification: `\{"code": "000", "data":["HIVE", "model1", "model2"], "msg":""}` * after modification: `\{"code": "000", "data":{"search_count":10, "total_model_count":20, "engines":[], "models":["MODEL1", "MODEL2"]}, "msg":""}` > 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)