[
https://issues.apache.org/jira/browse/HIVE-17239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sahil Takiar updated HIVE-17239:
--------------------------------
Issue Type: Sub-task (was: Bug)
Parent: HIVE-16923
> HoS doesn't trigger mapjoins against subquery with union all
> ------------------------------------------------------------
>
> Key: HIVE-17239
> URL: https://issues.apache.org/jira/browse/HIVE-17239
> Project: Hive
> Issue Type: Sub-task
> Components: Spark
> Reporter: Sahil Takiar
>
> HoS doesn't trigger map-joins for the following query:
> {code}
> EXPLAIN SELECT * FROM (SELECT part_col FROM partitioned_table1 UNION ALL
> SELECT
> part_col FROM partitioned_table2) q1 JOIN regular_table1 JOIN regular_table2
> WHERE q1.part_col = regular_table1.col1 AND q1.part_col = regular_table2.col1;
> {code}
> Hive-on-Tez does.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
