GitHub user mgaido91 opened a pull request:
https://github.com/apache/spark/pull/23057
[SPARK-26078][SQL] Dedup self-join attributes on IN subqueries
## What changes were proposed in this pull request?
When there is a self-join as result of a IN subquery, the join condition
may be invalid, resulting in trivially true predicates and return wrong results.
The PR deduplicates the subquery output in order to avoid the issue.
## How was this patch tested?
added UT
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/mgaido91/spark SPARK-26078
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/spark/pull/23057.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #23057
----
commit 2af656a6b8ddae00555b04ecdbc7873adc6fc0b6
Author: Marco Gaido <marcogaido91@...>
Date: 2018-11-16T12:27:35Z
[SPARK-26078][SQL] Dedup self-join attributes on subqueries
----
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
