[jira] [Created] (KYLIN-5525) When the excluded column is enabled and the query hits multiple identical models at the same time, the query may push down

["Yaguang Jia (Jira)" <ji...@apache.org>]

Yaguang Jia created KYLIN-5525:
----------------------------------

             Summary: When the excluded column is enabled and the query hits multiple identical models at the same time, the query may push down
                 Key: KYLIN-5525
                 URL: https://issues.apache.org/jira/browse/KYLIN-5525
             Project: Kylin
          Issue Type: Bug
            Reporter: Yaguang Jia


When there is only a table index, union all and its two subqueries can respond quickly. When the aggregate index is added, the subquery can hit the model, but the union all statement is depressed and can be reproduced in the customer environment. Query id refer to the screenshot below.

 

当只有明细索引时，union all及其两个子查询都能很快响应，当增加了聚合索引后，子查询可以击中模型，但是union all语句走了下压，可在客户环境复现，查询id参考下面截图



--
This message was sent by Atlassian Jira
(v8.20.10#820010)