viirya commented on code in PR #36216:
URL: https://github.com/apache/spark/pull/36216#discussion_r851836941
##########
sql/core/src/test/scala/org/apache/spark/sql/execution/datasources/SchemaPruningSuite.scala:
##########
@@ -621,6 +627,21 @@ abstract class SchemaPruningSuite
}
}
+ testSchemaPruning("SPARK-38918: nested schema pruning with correlated
subqueries") {
+ withContacts {
+ withEmployees {
+ val query = sql(
+ """
+ |select count(*)
+ |from contacts c
+ |where not exists (select null from employees e where e.name.first
= c.name.first
+ | and e.employer.name = c.employer.company.name)
+ |""".stripMargin)
+ checkAnswer(query, Row(3))
Review Comment:
Should we check pruning schema too?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
