[jira] [Assigned] (SPARK-40228) Don't simplify multiLike if child is not attribute
[ https://issues.apache.org/jira/browse/SPARK-40228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yuming Wang reassigned SPARK-40228: --- Assignee: Yuming Wang > Don't simplify multiLike if child is not attribute > -- > > Key: SPARK-40228 > URL: https://issues.apache.org/jira/browse/SPARK-40228 > Project: Spark > Issue Type: Improvement > Components: SQL >Affects Versions: 3.4.0 >Reporter: Yuming Wang >Assignee: Yuming Wang >Priority: Major > > {code:scala} > sql("create table t1(name string) using parquet") > sql("select * from t1 where substr(name, 1, 5) like any('%a', 'b%', > '%c%')").explain(true) > {code} > {noformat} > == Physical Plan == > *(1) Filter ((EndsWith(substr(name#0, 1, 5), a) OR StartsWith(substr(name#0, > 1, 5), b)) OR Contains(substr(name#0, 1, 5), c)) > +- *(1) ColumnarToRow >+- FileScan parquet default.t1[name#0] Batched: true, DataFilters: > [((EndsWith(substr(name#0, 1, 5), a) OR StartsWith(substr(name#0, 1, 5), b)) > OR Contains(substr(n..., Format: Parquet, PartitionFilters: [], > PushedFilters: [], ReadSchema: struct > {noformat} -- 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-40228) Don't simplify multiLike if child is not attribute
[ https://issues.apache.org/jira/browse/SPARK-40228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Apache Spark reassigned SPARK-40228: Assignee: (was: Apache Spark) > Don't simplify multiLike if child is not attribute > -- > > Key: SPARK-40228 > URL: https://issues.apache.org/jira/browse/SPARK-40228 > Project: Spark > Issue Type: Improvement > Components: SQL >Affects Versions: 3.4.0 >Reporter: Yuming Wang >Priority: Major > > {code:scala} > sql("create table t1(name string) using parquet") > sql("select * from t1 where substr(name, 1, 5) like any('%a', 'b%', > '%c%')").explain(true) > {code} > {noformat} > == Physical Plan == > *(1) Filter ((EndsWith(substr(name#0, 1, 5), a) OR StartsWith(substr(name#0, > 1, 5), b)) OR Contains(substr(name#0, 1, 5), c)) > +- *(1) ColumnarToRow >+- FileScan parquet default.t1[name#0] Batched: true, DataFilters: > [((EndsWith(substr(name#0, 1, 5), a) OR StartsWith(substr(name#0, 1, 5), b)) > OR Contains(substr(n..., Format: Parquet, PartitionFilters: [], > PushedFilters: [], ReadSchema: struct > {noformat} -- 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-40228) Don't simplify multiLike if child is not attribute
[ https://issues.apache.org/jira/browse/SPARK-40228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Apache Spark reassigned SPARK-40228: Assignee: Apache Spark > Don't simplify multiLike if child is not attribute > -- > > Key: SPARK-40228 > URL: https://issues.apache.org/jira/browse/SPARK-40228 > Project: Spark > Issue Type: Improvement > Components: SQL >Affects Versions: 3.4.0 >Reporter: Yuming Wang >Assignee: Apache Spark >Priority: Major > > {code:scala} > sql("create table t1(name string) using parquet") > sql("select * from t1 where substr(name, 1, 5) like any('%a', 'b%', > '%c%')").explain(true) > {code} > {noformat} > == Physical Plan == > *(1) Filter ((EndsWith(substr(name#0, 1, 5), a) OR StartsWith(substr(name#0, > 1, 5), b)) OR Contains(substr(name#0, 1, 5), c)) > +- *(1) ColumnarToRow >+- FileScan parquet default.t1[name#0] Batched: true, DataFilters: > [((EndsWith(substr(name#0, 1, 5), a) OR StartsWith(substr(name#0, 1, 5), b)) > OR Contains(substr(n..., Format: Parquet, PartitionFilters: [], > PushedFilters: [], ReadSchema: struct > {noformat} -- 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