[
https://issues.apache.org/jira/browse/SPARK-3831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14161847#comment-14161847
]
Apache Spark commented on SPARK-3831:
-------------------------------------
User 'sarutak' has created a pull request for this issue:
https://github.com/apache/spark/pull/2692
> Filter rule Improvement and bool expression optimization.
> ---------------------------------------------------------
>
> Key: SPARK-3831
> URL: https://issues.apache.org/jira/browse/SPARK-3831
> Project: Spark
> Issue Type: Improvement
> Reporter: Kousuke Saruta
>
> If we write the filter which is always FALSE like
> {code}
> SELECT * from person WHERE FALSE;
> {code}
> 200 tasks will run. I think, 1 task is enough.
> And current optimizer cannot optimize the case NOT is duplicated like
> {code}
> SELECT * from person WHERE NOT ( NOT (age > 30));
> {code}
> The filter rule above should be simplified
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
