[ https://issues.apache.org/jira/browse/PHOENIX-1557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14259677#comment-14259677 ]
Maryann Xue commented on PHOENIX-1557: -------------------------------------- Now we have SORT_MERGE_JOIN hint to force sort-merge-join, and otherwise we do hash-join whenever possible. Next step is to use stats to guide join algorithms for single or multiple joins in the query. > Add hint to force sort merge join > --------------------------------- > > Key: PHOENIX-1557 > URL: https://issues.apache.org/jira/browse/PHOENIX-1557 > Project: Phoenix > Issue Type: Sub-task > Reporter: James Taylor > Assignee: Maryann Xue > Fix For: 4.3, 3.3 > > > We should add two more hints: HASH_JOIN and SORTED_MERGE_JOIN which will > override the default decision for which join algorithm will be used. -- This message was sent by Atlassian JIRA (v6.3.4#6332)