[
https://issues.apache.org/jira/browse/PHOENIX-1557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14259674#comment-14259674
]
Maryann Xue commented on PHOENIX-1557:
--------------------------------------
We already have a SORT_MERGE_JOIN hint to force using sort-merge join. And we
use hash-join whenever possible and the sort-merge-join hint is not present, so
I guess HASH_JOIN hint is not necessary.
However, we might need something to hint join algorithms for different joins in
a 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)
