Sahil Takiar created HIVE-17239:
-----------------------------------
Summary: 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: Bug
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)
