[
https://issues.apache.org/jira/browse/PHOENIX-1168?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14141540#comment-14141540
]
James Taylor commented on PHOENIX-1168:
---------------------------------------
bq. But still, think LIMIT 2 would make some sense, for we can avoid starting
parallel iterators for the inner query, right?
Yes - instead of bring over 3000 rows from the server, we'd only bring over 2.
bq. ANY/SOME/ALL is handled just similar to IN clause now. No early exit, but
rather execute the entire inner query and build it into an literal array.
How big do you let the literal array get? Are you thinking to support scenarios
where the inner query would return more rows than would fit into memory?
> 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)
