[
https://issues.apache.org/jira/browse/FLINK-32471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738939#comment-17738939
]
Yunhong Zheng commented on FLINK-32471:
---------------------------------------
Hi, [~grandfisher] . I agree with you, 'IS_NOT_NULL' is possible to push to
left which is semantically equivalent in SQL. You can try to add this type of
SqlKind to the SUITABLE_FILTER_TO_PUSH set. Btw, is this a requirement founded
while using Flink batch in daily work? Thanks.
> 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)
