[
https://issues.apache.org/jira/browse/HIVE-4611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13739220#comment-13739220
]
Ashutosh Chauhan commented on HIVE-4611:
----------------------------------------
Patch looks good. I see in some places for the collection of big table
candidates, where we were using Set, you have changed it to lists, any
particular reason for that? It seems Set would be a better choice for those.
> SMB joins fail based on bigtable selection policy.
> --------------------------------------------------
>
> Key: HIVE-4611
> URL: https://issues.apache.org/jira/browse/HIVE-4611
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Affects Versions: 0.11.0
> Reporter: Vikram Dixit K
> Assignee: Vikram Dixit K
> Fix For: 0.11.1
>
> Attachments: HIVE-4611.2.patch, HIVE-4611.3.patch, HIVE-4611.4.patch,
> HIVE-4611.5.patch.txt, HIVE-4611.patch
>
>
> The default setting for
> hive.auto.convert.sortmerge.join.bigtable.selection.policy will choose the
> big table as the one with largest average partition size. However, this can
> result in a query failing because this policy conflicts with the big table
> candidates chosen for outer joins. This policy should just be a tie breaker
> and not have the ultimate say in the choice of tables.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
