[
https://issues.apache.org/jira/browse/SPARK-3831?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yin Huai updated SPARK-3831:
----------------------------
Component/s: SQL
> Filter rule Improvement and bool expression optimization.
> ---------------------------------------------------------
>
> Key: SPARK-3831
> URL: https://issues.apache.org/jira/browse/SPARK-3831
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> 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
