[jira] [Resolved] (SPARK-25702) Push down filters with `Not` operator in Parquet

["Gengliang Wang (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SPARK-25702?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gengliang Wang resolved SPARK-25702.
------------------------------------
    Resolution: Fixed

The condition is not reachable due to optimization rule BooleanSimplification.

> Push down filters with `Not` operator in Parquet
> ------------------------------------------------
>
>                 Key: SPARK-25702
>                 URL: https://issues.apache.org/jira/browse/SPARK-25702
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 2.4.0
>            Reporter: Gengliang Wang
>            Priority: Major
>
> Currently, in ParquetFilters, predicates inside `Not` operator are considered as unable to perform partial push down.
> However, the following cases is still possible for push down:
> 1. `Not(Or(left, right))` can be conversed as `And(Not(left), Not(right))`
> 2. `Not(Not(pred))` can be conversed as `pred`
> Both cases should be quite trivial, since the `Not` operator should be pushed down by optimization rule `BooleanSimplification` already.
> But I think it should be good to handle such cases in Parquet data source module as well.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org