hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sahil Takiar (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-17239) HoS doesn't trigger mapjoins against subquery with union all
Date Thu, 03 Aug 2017 05:53:00 GMT
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)

Mime
View raw message