[jira] [Assigned] (SPARK-20175) Exists should not be evaluated in Join operator and can be converted to ScalarSubquery if no correlated reference
[ https://issues.apache.org/jira/browse/SPARK-20175?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wenchen Fan reassigned SPARK-20175: --- Assignee: Liang-Chi Hsieh > 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 >Assignee: Liang-Chi Hsieh > Fix For: 2.2.0 > > > 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
[jira] [Assigned] (SPARK-20175) Exists should not be evaluated in Join operator and can be converted to ScalarSubquery if no correlated reference
[ https://issues.apache.org/jira/browse/SPARK-20175?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Apache Spark reassigned SPARK-20175: Assignee: Apache Spark > 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 >Assignee: Apache Spark > > 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
[jira] [Assigned] (SPARK-20175) Exists should not be evaluated in Join operator and can be converted to ScalarSubquery if no correlated reference
[ https://issues.apache.org/jira/browse/SPARK-20175?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Apache Spark reassigned SPARK-20175: Assignee: (was: Apache Spark) > 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