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