[
https://issues.apache.org/jira/browse/HIVE-8911?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Chao updated HIVE-8911:
-----------------------
Status: Patch Available (was: Open)
I have to disable the following tests which rely on smb join w/ hints. I'll
re-enable them after HIVE-8640 is resolved.
{noformat}
auto_sortmerge_join_11.q
bucketmapjoin6.q
join_filters.q
join_nulls.q
smb_mapjoin9.q
smb_mapjoin_1.q
smb_mapjoin_2.q
smb_mapjoin_3.q
smb_mapjoin_4.q
smb_mapjoin_5.q
smb_mapjoin_6.q
smb_mapjoin_7.q
smb_mapjoin_8.q
smb_mapjoin_10.q
smb_mapjoin_13.q
smb_mapjoin_14.q
smb_mapjoin_15.q
smb_mapjoin_16.q
smb_mapjoin_17.q
sort_merge_join_desc_1.q
sort_merge_join_desc_2.q
sort_merge_join_desc_3.q
sort_merge_join_desc_4.q
sort_merge_join_desc_5.q
sort_merge_join_desc_6.q
sort_merge_join_desc_7.q
sort_merge_join_desc_8.q
vectorized_bucketmapjoin1.q
{noformat}
The issue is because of the extra ReduceSinkOperator generated before
MapJoinOperator, which causes SortedMergeBucketMapjoinProc to generate a
DummyStoreOperator before ReduceSinkOperator. I'll look into this issue in
HIVE-8640.
> Enable mapjoin hints [Spark Branch]
> -----------------------------------
>
> Key: HIVE-8911
> URL: https://issues.apache.org/jira/browse/HIVE-8911
> Project: Hive
> Issue Type: Sub-task
> Components: Spark
> Affects Versions: spark-branch
> Reporter: Szehon Ho
> Assignee: Chao
> Attachments: HIVE-8911.1-spark.patch
>
>
> Currently the big table selection in a mapjoin is based on stats.
> We should also enable the big-table selection based on hints. See class
> MapJoinProcessor. This is a logical-optimizer class, so we should be able to
> re-use this without too many changes to hook up with SparkMapJoinResolver.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)