[
https://issues.apache.org/jira/browse/PHOENIX-1179?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14289445#comment-14289445
]
Maryann Xue commented on PHOENIX-1179:
--------------------------------------
Yes, I do recommend you upgrade your Phoenix version. 3.2.2 / 4.2.2 includes
the SKIP_SCAN_HASH_JOIN optimization, which might be able to improve your first
query performance significantly. And 3.3 / 4.3 will be coming soon, and your
second query may have to depend on that. Just remember to use hint
"USE_SORT_MERGE_JOIN" if both LHS and RHS are too big to fit into memory.
> Support many-to-many joins
> --------------------------
>
> Key: PHOENIX-1179
> URL: https://issues.apache.org/jira/browse/PHOENIX-1179
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: James Taylor
> Assignee: Maryann Xue
> Fix For: 4.3, 3.3
>
> Attachments: 1179.patch
>
>
> Enhance our join capabilities to support many-to-many joins where the size of
> both sides of the join are too big to fit into memory (and thus cannot use
> our hash join mechanism). One technique would be to order both sides of the
> join by their join key and merge sort the results on the client.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
