You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "hufukang (Jira)" <ji...@apache.org> on 2023/05/25 05:17:00 UTC

[jira] [Reopened] (CALCITE-5617) count() + left join execution efficiency optimize

     [ https://issues.apache.org/jira/browse/CALCITE-5617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

hufukang reopened CALCITE-5617:
-------------------------------

> 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)