[
https://issues.apache.org/jira/browse/PHOENIX-1179?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maryann Xue updated PHOENIX-1179:
---------------------------------
Attachment: 1179.patch
1. Add USE_SORT_MERGE_JOIN hint
2. Otherwise queries that cannot be done with Hash-joins alone will take the
sort-merge-join path instead. For example, a right-left join like:
"SELECT ... FROM A RIGHT JOIN B ON ... LEFT JOIN C ON ... " the query plan will
generate like: (A hash-join B) sort-merge-join C.
> 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: 3.0.0, 4.0.0, 5.0.0
>
> 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)
