Anton Okolnychyi created SPARK-38977: ----------------------------------------
Summary: 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.1, 3.2.0, 3.3.0 Reporter: Anton Okolnychyi 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