Review Board 1.7.22


HIVE-4611 - SMB joins fail based on bigtable selection policy.

Review Request #12827 - Created July 22, 2013 and updated

Vikram Dixit Kumaraswamy
0.11
HIVE-4611
Reviewers
hive
ashutoshc, brocknoland, haglein
hive-git
SMB joins fail based on bigtable selection policy. 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.
All tests pass on hadoop 1.
Review request changed
Updated (Aug. 14, 2013, 7:21 p.m.)
Addressed Ashutosh's comments.