[GitHub] [spark] wangyum commented on pull request #38676: [SPARK-41162][SQL] Do not push down anti-join predicates that become ambiguous

[GitBox <gi...@apache.org>]

wangyum commented on PR #38676:
URL: https://github.com/apache/spark/pull/38676#issuecomment-1319657140

   @EnricoMi @cloud-fan Could we fix the `DeduplicateRelations`?  It did not generate different expression IDs for all conflicting attributes:
   ```
   === Applying Rule org.apache.spark.sql.catalyst.analysis.DeduplicateRelations ===
    Join LeftSemi                         Join LeftSemi
    :- Project [(id#4 + 1) AS id#6]       :- Project [(id#4 + 1) AS id#6]
    :  +- Deduplicate [id#4]              :  +- Deduplicate [id#4]
    :     +- Project [value#1 AS id#4]    :     +- Project [value#1 AS id#4]
    :        +- LocalRelation [value#1]   :        +- LocalRelation [value#1]
    +- Deduplicate [id#4]                 +- Deduplicate [id#4]
   !   +- Project [value#1 AS id#4]          +- Project [value#8 AS id#4]
   !      +- LocalRelation [value#1]            +- LocalRelation [value#8]
   ```


-- 
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: reviews-unsubscribe@spark.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org