[jira] [Commented] (SPARK-14781) Support subquery in nested predicates

["Roy Cecil (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SPARK-14781?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15259909#comment-15259909 ] 

Roy Cecil commented on SPARK-14781:
-----------------------------------

This affects Q10, Q35 and Q45. If this is fixed we can then run 96 out of 99 queries out of the box with Minor Query Rewrites as allowed by TPC-DS . 

> Support subquery in nested predicates
> -------------------------------------
>
>                 Key: SPARK-14781
>                 URL: https://issues.apache.org/jira/browse/SPARK-14781
>             Project: Spark
>          Issue Type: New Feature
>          Components: SQL
>            Reporter: Davies Liu
>
> Right now, we does not support nested IN/EXISTS subquery, for example 
> EXISTS( x1) OR EXISTS( x2)
> In order to do that, we could use an internal-only join type SemiPlus, which will output every row from left, plus additional column as the result of join condition. Then we could replace the EXISTS() or IN() by the result column.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

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