[ https://issues.apache.org/jira/browse/SPARK-39672?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Wenchen Fan resolved SPARK-39672. --------------------------------- Fix Version/s: 3.3.1 3.2.2 3.1.4 3.4.0 Resolution: Fixed Issue resolved by pull request 37074 [https://github.com/apache/spark/pull/37074] > NotExists subquery failed with conflicting attributes > ----------------------------------------------------- > > Key: SPARK-39672 > URL: https://issues.apache.org/jira/browse/SPARK-39672 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 3.1.3 > Reporter: Manu Zhang > Assignee: Manu Zhang > Priority: Major > Fix For: 3.3.1, 3.2.2, 3.1.4, 3.4.0 > > > {code:sql} > select * from > ( > select v1.a, v1.b, v2.c > from v1 > inner join v2 > on v1.a=v2.a) t3 > where not exists ( > select 1 > from v2 > where t3.a=v2.a and t3.b=v2.b and t3.c=v2.c > ){code} > This query throws AnalysisException > {code:java} > org.apache.spark.sql.AnalysisException: Found conflicting attributes a#266 in > the condition joining outer plan: > Join Inner, (a#250 = a#266) > :- Project [_1#243 AS a#250, _2#244 AS b#251] > : +- LocalRelation [_1#243, _2#244, _3#245] > +- Project [_1#259 AS a#266, _3#261 AS c#268] > +- LocalRelation [_1#259, _2#260, _3#261]and subplan: > Project [1 AS 1#273, _1#259 AS a#266, _2#260 AS b#267, _3#261 AS c#268#277] > +- LocalRelation [_1#259, _2#260, _3#261] {code} -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org