Liang-Chi Hsieh created SPARK-20175: ---------------------------------------
Summary: Exists should not be evaluated in Join operator and can be converted to ScalarSubquery if no correlated reference Key: SPARK-20175 URL: https://issues.apache.org/jira/browse/SPARK-20175 Project: Spark Issue Type: Improvement Components: SQL Affects Versions: 2.1.0 Reporter: Liang-Chi Hsieh Similar to ListQuery, Exists should not be evaluated in Join operator too. Otherwise, a query like following will fail: sql("select * from l, r where l.a = r.c + 1 AND (exists (select * from r) OR l.a = r.c)") For the Exists subquery without correlated reference, this patch converts it to scalar subquery with a count Aggregate operator. -- This message was sent by Atlassian JIRA (v6.3.15#6346) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org