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