Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-16923 Hive-on-Spark DPP Improvements
  3. HIVE-17239

HoS doesn't trigger mapjoins against subquery with union all

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Spark
    • None

    Description

      HoS doesn't trigger map-joins for the following query:

      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;
      

      Hive-on-Tez does.

      Attachments

        Activity

          People

            janulatha Janaki Lahorani
            stakiar Sahil Takiar
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: