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

MultiQueryOptimizerTez creates bad plan with union, split and FRJoin

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.16.0
    • 0.17.0, 0.16.1
    • tez
    • None
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: