[jira] [Assigned] (SPARK-39651) Prune filter condition compare rand function with foldable expression

2022-06-30 Thread Apache Spark (Jira)


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

Apache Spark reassigned SPARK-39651:


Assignee: (was: Apache Spark)

> Prune filter condition compare rand function with foldable expression
> -
>
> Key: SPARK-39651
> URL: https://issues.apache.org/jira/browse/SPARK-39651
> Project: Spark
>  Issue Type: Improvement
>  Components: SQL
>Affects Versions: 3.4.0
>Reporter: jiaan.geng
>Priority: Major
>
> The SQL
> SELECT * FROM tab WHERE rand(1) < 2
> evaluate rand(1) < 2 for rows one by one.
> In fact, we can prune the filter condition.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

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



[jira] [Assigned] (SPARK-39651) Prune filter condition compare rand function with foldable expression

2022-06-30 Thread Apache Spark (Jira)


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

Apache Spark reassigned SPARK-39651:


Assignee: Apache Spark

> Prune filter condition compare rand function with foldable expression
> -
>
> Key: SPARK-39651
> URL: https://issues.apache.org/jira/browse/SPARK-39651
> Project: Spark
>  Issue Type: Improvement
>  Components: SQL
>Affects Versions: 3.4.0
>Reporter: jiaan.geng
>Assignee: Apache Spark
>Priority: Major
>
> The SQL
> SELECT * FROM tab WHERE rand(1) < 2
> evaluate rand(1) < 2 for rows one by one.
> In fact, we can prune the filter condition.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

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