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

Bucket pruning: Left Outer Join on bucketed table gives wrong result

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.3.2, 3.0.0
    • 3.2.0, 4.0.0-alpha-1
    • None
    • None

    Description

      Left outer join on bucketed table on certain cases gives wrong results.

      Depending on the order in which the table-scans are walked through, the FilterPruner might end up using the wrong table scan's table properties on the other table.

      Attachments

        1. HIVE-20039.01-branch-3.patch
          6.99 MB
          Deepak Jaiswal
        2. HIVE-20039.1.patch
          105 kB
          Deepak Jaiswal
        3. HIVE-20039.2.patch
          108 kB
          Deepak Jaiswal
        4. HIVE-20039.3.patch
          6.99 MB
          Deepak Jaiswal
        5. HIVE-20039.4.patch
          6.99 MB
          Deepak Jaiswal

        Issue Links

          Activity

            People

              djaiswal Deepak Jaiswal
              djaiswal Deepak Jaiswal
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: