[ https://issues.apache.org/jira/browse/SPARK-39651?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
jiaan.geng updated SPARK-39651: ------------------------------- Description: The SQL {code:java} SELECT * FROM tab WHERE rand(1) < 2 {code} evaluate rand(1) < 2 for rows one by one. In fact, we can prune the filter condition. was: 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. > 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 > {code:java} > SELECT * FROM tab WHERE rand(1) < 2 > {code} > 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