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

Posted to issues@flink.apache.org by "Shengkai Fang (Jira)" <ji...@apache.org> on 2023/11/29 09:28:00 UTC

[jira] [Assigned] (FLINK-33691) Support agg push down for 'count(*)/count(1)/count(column not null)'

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

Shengkai Fang reassigned FLINK-33691:
-------------------------------------

    Assignee: Yunhong Zheng

> Support agg push down for 'count(*)/count(1)/count(column not null)'
> --------------------------------------------------------------------
>
>                 Key: FLINK-33691
>                 URL: https://issues.apache.org/jira/browse/FLINK-33691
>             Project: Flink
>          Issue Type: Improvement
>          Components: Table SQL / Planner
>    Affects Versions: 1.19.0
>            Reporter: Yunhong Zheng
>            Assignee: Yunhong Zheng
>            Priority: Major
>             Fix For: 1.19.0
>
>
> Now,  PushLocalAggIntoScanRule cannot push down 'count( * )/count(1)/count(column not null)', but it can push down count(column nullable). The reason is that count( * ) and count( 1 ) will be optimized to a scan with calc as '0 AS $f0' to reduce read cost, which will not match the push down rule



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