[
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)
