[
https://issues.apache.org/jira/browse/PHOENIX-1179?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14258248#comment-14258248
]
alex kamil edited comment on PHOENIX-1179 at 12/24/14 1:40 PM:
---------------------------------------------------------------
[~jamestaylor] actually this hint seems to work
SELECT /\*+ USE_SORT_MERGE_JOIN\*/
was (Author: alexdl):
[~jamestaylor] actually this hint seems to work
SELECT /*+ USE_SORT_MERGE_JOIN*/
> 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)
