Uploaded image for project: 'Pig'
  1. Pig
  2. PIG-5033

MultiQueryOptimizerTez creates bad plan with union, split and FRJoin

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.16.0
    • Fix Version/s: 0.17.0, 0.16.1
    • Component/s: tez
    • Labels:
      None
    • Hadoop Flags:
      Reviewed

      Description

      This script produces incorrect results:

      a = load 'file:///tmp/input1' as (x:int, y:int);
      b = load 'file:///tmp/input2' as (x:int, y:int);
      u = union a,b;
      c = load 'file:///tmp/input3' as (x:int, y:int);
      e = filter c by y > 3;
      f = filter c by y < 2;
      g = join u by x left, e by x using 'replicated';
      h = join g by u::x left, f by x using 'replicated';
      store h into 'file:///tmp/pigoutput';
      

      Without the union, or with opt.multiquery=false, or with non-replicated joins, it works as expected.

        Attachments

        1. PIG-5033-2.patch
          20 kB
          Rohini Palaniswamy
        2. PIG-5033.patch
          12 kB
          Travis Woodruff
        3. input3
          0.0 kB
          Travis Woodruff
        4. input2
          0.0 kB
          Travis Woodruff
        5. input1
          0.0 kB
          Travis Woodruff

          Activity

            People

            • Assignee:
              rohini Rohini Palaniswamy
              Reporter:
              tmwoodruff Travis Woodruff
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: