Uploaded image for project: 'Flink'
  1. Flink
  2. FLINK-32471

IS_NOT_NULL can add to SUITABLE_FILTER_TO_PUSH

    XMLWordPrintableJSON

Details

    Description

      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.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. FLINK-31273 Left join with IS_NULL filter be wrongly pushed down and get wrong join results

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          links to

          Web Link GitHub Pull Request #23088

          Activity

            People

              Unassigned Unassigned
              grandfisher grandfisher
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: