[
https://issues.apache.org/jira/browse/KYLIN-5525?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yaguang Jia updated KYLIN-5525:
-------------------------------
Description:
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
当只有明细索引时，union all及其两个子查询都能很快响应，当增加了聚合索引后，子查询可以击中模型，但是union all语句走了下压
was:
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参考下面截图
> 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
> Priority: Critical
>
> 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
>
> 当只有明细索引时，union all及其两个子查询都能很快响应，当增加了聚合索引后，子查询可以击中模型，但是union all语句走了下压
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
