[ 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)