Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-25419 Parquet predicate pushdown improvement
  3. SPARK-32792

Improve in filter pushdown for ParquetFilters

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.1.0
    • 3.2.0
    • SQL
    • None

    Description

      Support push down `GreaterThanOrEqual` minimum value and `LessThanOrEqual` maximum value when its values exceeds `spark.sql.parquet.pushdown.inFilterThreshold`. For example:

      ```sql
      SELECT * FROM t WHERE id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 15)
      ```

      We will push down `id >= 1 and id <= 15`.

      Attachments

        Activity

          People

            yumwang Yuming Wang
            yumwang Yuming Wang
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: