Hive
  1. Hive
  2. HIVE-4689

For outerjoins, joinEmitInterval might make wrong result

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 0.11.0
    • Fix Version/s: 0.12.0
    • Component/s: Query Processor
    • Labels:
      None

      Description

      Alias filter tag is calculated for each group and used for outer joins. But if joinEmitInterval is smaller than the group size, pre-matured alias filter tag would be used and might introduce different(wrong) result.

      It can be observed in join_1to1.q test but I cannot imagine proper solution which does not override intention of joinEmitInterval. Should it be disabled for outer joins?

        Issue Links

          Activity

          Ashutosh Chauhan made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Ashutosh Chauhan made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Fix Version/s 0.12.0 [ 12324312 ]
          Resolution Fixed [ 1 ]
          Ashutosh Chauhan made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Affects Version/s 0.11.0 [ 12323587 ]
          Yin Huai made changes -
          Link This issue is related to HIVE-4781 [ HIVE-4781 ]
          Brock Noland made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Phabricator made changes -
          Attachment HIVE-4689.D11211.1.patch [ 12587202 ]
          Navis made changes -
          Field Original Value New Value
          Summary For outerjoins, joinEmitInterval might make different result For outerjoins, joinEmitInterval might make wrong result
          Navis created issue -

            People

            • Assignee:
              Navis
              Reporter:
              Navis
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development