Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-8888

Mapjoin with LateralViewJoin generates wrong plan in Tez

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.13.0, 0.14.0, 0.13.1, 0.15.0
    • Fix Version/s: 1.0.0
    • Component/s: None
    • Labels:
      None

      Description

      Queries like these

      with sub1 as
      (select aid, avalue from expod1 lateral view explode(av) avs as avalue ),
      sub2 as
      (select bid, bvalue from expod2 lateral view explode(bv) bvs as bvalue)
      select sub1.aid, sub1.avalue, sub2.bvalue
      from sub1,sub2
      where sub1.aid=sub2.bid;
      

      generates twice the number of rows in Tez when compared to MR.

        Attachments

        1. HIVE-8888-branch.5.patch
          1 kB
          Prasanth Jayachandran
        2. HIVE-8888.5.patch
          9 kB
          Gunther Hagleitner
        3. HIVE-8888.4.patch
          20 kB
          Gunther Hagleitner
        4. HIVE-8888.3.patch
          19 kB
          Prasanth Jayachandran
        5. HIVE-8888.2.patch
          20 kB
          Prasanth Jayachandran
        6. HIVE-8888.1.patch
          20 kB
          Prasanth Jayachandran

          Issue Links

            Activity

              People

              • Assignee:
                prasanth_j Prasanth Jayachandran
                Reporter:
                prasanth_j Prasanth Jayachandran
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: