[jira] [Resolved] (SPARK-3831) Filter rule Improvement and bool expression optimization.

["Michael Armbrust (JIRA)" <ji...@apache.org>]

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

Michael Armbrust resolved SPARK-3831.
-------------------------------------
       Resolution: Fixed
    Fix Version/s: 1.2.0

Issue resolved by pull request 2692
[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
>          Components: SQL
>            Reporter: Kousuke Saruta
>             Fix For: 1.2.0
>
>
> 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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org