[
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, [[email protected]], 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)
