[KYLIN-5763] Very slow to filter query history

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.0-beta
• Fix Version/s: 5.0-beta
• Component/s: Query Engine
• Assignee: pengfei.zhan
• Reporter: pengfei.zhan
• Due: 29/Mar/24
• Created: 27/Mar/24 03:53
• Updated: 01/Apr/24 06:20
• Resolved: 01/Apr/24 06:20

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.

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";