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

Reply via email to