[jira] [Assigned] (SPARK-38977) Fix schema pruning with correlated subqueries
[ https://issues.apache.org/jira/browse/SPARK-38977?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] L. C. Hsieh reassigned SPARK-38977: --- Assignee: Anton Okolnychyi > Fix schema pruning with correlated subqueries > - > > Key: SPARK-38977 > URL: https://issues.apache.org/jira/browse/SPARK-38977 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 3.2.0, 3.2.1, 3.3.0 >Reporter: Anton Okolnychyi >Assignee: Anton Okolnychyi >Priority: Major > > Schema pruning fails for some queries with correlated subqueries. > {noformat} > sql( > s"""SELECT name FROM contacts c > |WHERE > | EXISTS (SELECT 1 FROM ids i WHERE i.value = c.id) > | AND > | EXISTS (SELECT 1 FROM first_names n WHERE c.name.first = n.value) > |""".stripMargin) > {noformat} > {noformat} > [info] org.apache.spark.SparkException: Failed to merge fields 'value' and > 'value'. Failed to merge incompatible data types int and string > [info] at > org.apache.spark.sql.errors.QueryExecutionErrors$.failedMergingFieldsError(QueryExecutionErrors.scala:936) > {noformat} -- This message was sent by Atlassian Jira (v8.20.7#820007) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Assigned] (SPARK-38977) Fix schema pruning with correlated subqueries
[ https://issues.apache.org/jira/browse/SPARK-38977?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Apache Spark reassigned SPARK-38977: Assignee: Apache Spark > Fix schema pruning with correlated subqueries > - > > Key: SPARK-38977 > URL: https://issues.apache.org/jira/browse/SPARK-38977 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 3.2.0, 3.2.1, 3.3.0 >Reporter: Anton Okolnychyi >Assignee: Apache Spark >Priority: Major > > Schema pruning fails for some queries with correlated subqueries. > {noformat} > sql( > s"""SELECT name FROM contacts c > |WHERE > | EXISTS (SELECT 1 FROM ids i WHERE i.value = c.id) > | AND > | EXISTS (SELECT 1 FROM first_names n WHERE c.name.first = n.value) > |""".stripMargin) > {noformat} > {noformat} > [info] org.apache.spark.SparkException: Failed to merge fields 'value' and > 'value'. Failed to merge incompatible data types int and string > [info] at > org.apache.spark.sql.errors.QueryExecutionErrors$.failedMergingFieldsError(QueryExecutionErrors.scala:936) > {noformat} -- This message was sent by Atlassian Jira (v8.20.7#820007) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Assigned] (SPARK-38977) Fix schema pruning with correlated subqueries
[ https://issues.apache.org/jira/browse/SPARK-38977?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Apache Spark reassigned SPARK-38977: Assignee: (was: Apache Spark) > Fix schema pruning with correlated subqueries > - > > Key: SPARK-38977 > URL: https://issues.apache.org/jira/browse/SPARK-38977 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 3.2.0, 3.2.1, 3.3.0 >Reporter: Anton Okolnychyi >Priority: Major > > Schema pruning fails for some queries with correlated subqueries. > {noformat} > sql( > s"""SELECT name FROM contacts c > |WHERE > | EXISTS (SELECT 1 FROM ids i WHERE i.value = c.id) > | AND > | EXISTS (SELECT 1 FROM first_names n WHERE c.name.first = n.value) > |""".stripMargin) > {noformat} > {noformat} > [info] org.apache.spark.SparkException: Failed to merge fields 'value' and > 'value'. Failed to merge incompatible data types int and string > [info] at > org.apache.spark.sql.errors.QueryExecutionErrors$.failedMergingFieldsError(QueryExecutionErrors.scala:936) > {noformat} -- This message was sent by Atlassian Jira (v8.20.7#820007) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org