[
https://issues.apache.org/jira/browse/CALCITE-5617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
hufukang updated CALCITE-5617:
------------------------------
Description:
{code:java}
//代码占位符
{code}
SQL uses the count() aggregate function and uses left join to associate other
tables, the execution efficiency is very slow, and try to optimize the
aggregation function operator pushdown, hoping to put forward relevant
optimization suggestions.
*Test Demo:*
{code:java}
{code}
*//代码占位符*
**
was:
{code:java}
//代码占位符
{code}
SQL uses the count() aggregate function and uses left join to associate other
tables, the execution efficiency is very slow, and try to optimize the
aggregation function operator pushdown, hoping to put forward relevant
optimization suggestions.
> count() + left join execution efficiency optimize
> -------------------------------------------------
>
> Key: CALCITE-5617
> URL: https://issues.apache.org/jira/browse/CALCITE-5617
> Project: Calcite
> Issue Type: Task
> Reporter: hufukang
> Priority: Major
>
> {code:java}
> //代码占位符
> {code}
> SQL uses the count() aggregate function and uses left join to associate other
> tables, the execution efficiency is very slow, and try to optimize the
> aggregation function operator pushdown, hoping to put forward relevant
> optimization suggestions.
>
> *Test Demo:*
>
> {code:java}
> {code}
> *//代码占位符*
> **
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
