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

Posted to issues@flink.apache.org by "grandfisher (Jira)" <ji...@apache.org> on 2023/07/10 07:24:00 UTC

[jira] [Commented] (FLINK-32471) IS_NOT_NULL can add to SUITABLE_FILTER_TO_PUSH

    [ https://issues.apache.org/jira/browse/FLINK-32471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17741482#comment-17741482 ] 

grandfisher commented on FLINK-32471:
-------------------------------------

Thanks, [~337361684@qq.com], We do have a batch scene. I will try to add this type of SqlKind to the SUITABLE_FILTER_TO_PUSH set as soon as I solve the compilation problem of flink-scala2.12 with local flink code

> IS_NOT_NULL can add to SUITABLE_FILTER_TO_PUSH
> ----------------------------------------------
>
>                 Key: FLINK-32471
>                 URL: https://issues.apache.org/jira/browse/FLINK-32471
>             Project: Flink
>          Issue Type: Improvement
>          Components: Table SQL / Planner
>            Reporter: grandfisher
>            Priority: Major
>
> According to FLINK-31273:
> The reason for the error is that other filters conflict with IS_NULL, but in fact it won't conflict with IS_NOT_NULL, because operators in SUITABLE_FILTER_TO_PUSH  such as 'SqlKind.GREATER_THAN'  has an implicit filter 'IS_NOT_NULL' according to SQL Semantics.
>  
> So we think it is feasible to add  IS_NOT_NULL to the SUITABLE_FILTER_TO_PUSH list.



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