[ https://issues.apache.org/jira/browse/CALCITE-5617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726010#comment-17726010 ]
Runkang He commented on CALCITE-5617: ------------------------------------- [~huge] could you give a SQL example to describe this issue? > 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)