[
https://issues.apache.org/jira/browse/PHOENIX-1168?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14139773#comment-14139773
]
James Taylor commented on PHOENIX-1168:
---------------------------------------
This is awesome, [~maryannxue]! Before more detailed feedback, I've got some
high level questions:
- can you give me the 10,000ft view of how you execute the inner query? Is it
done client-side with an early exit based on ANY/SOME/ALL? Or do you turn it
into a join and push the inner or outer in a hash cache?
- what is the relationship between the ANY operator and EXISTS? Would it make
sense to push a LIMIT to the inner query (or maybe you already do)?
- can a constant appear on the LHS when ANY/SOME/ALL is used? If so, is the
constant pushed into the execution of the inner query?
- is there any opportunity to flatten the inner query in an IN with the outer
query?
- when there's no modifier, is that when it's only valid for the IN query to
return a single row? Would it make sense to push a LIMIT 2 to the IN query to
prevent a bunch of data from being pulled over?
> Support non-correlated sub-queries in where clause having a comparison
> operator with no modifier or a comparison operator modified by ANY, SOME or
> ALL
> ------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: PHOENIX-1168
> URL: https://issues.apache.org/jira/browse/PHOENIX-1168
> Project: Phoenix
> Issue Type: Sub-task
> Affects Versions: 3.0.0, 4.0.0, 5.0.0
> Reporter: Maryann Xue
> Assignee: Maryann Xue
> Fix For: 3.0.0, 4.0.0, 5.0.0
>
> Attachments: 1168.patch
>
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
