Github user dongjoon-hyun commented on the issue:

    https://github.com/apache/spark/pull/20265
  
    Hi, @cloud-fan and @gatorsmile .
    Your questions are valid for all PPD cases. According to the comments, I 
added the following expressions (positive and negative) for both ORC/Parquet.
    ```
    +    // Positive cases: Select one or no rows
    +    Seq("id = 0", "id == 0", "id <= 0", "id < 1", "id IS NULL").foreach { 
expr =>
    +      filterPushDownBenchmark(1024 * 1024 * 1, 20, expr)
    +    }
    +
    +    // Negative cases: Select all rows which means the predicate is always 
true.
    +    Seq("id > -1", "id != -1", "id IS NOT NULL").foreach { expr =>
    +      filterPushDownBenchmark(1024 * 1024 * 1, 20, expr)
    +    }
    ```


---

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to