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. input1
          0.0 kB
          Travis Woodruff
        2. input2
          0.0 kB
          Travis Woodruff
        3. input3
          0.0 kB
          Travis Woodruff
        4. PIG-5033.patch
          12 kB
          Travis Woodruff
        5. PIG-5033-2.patch
          20 kB
          Rohini Palaniswamy

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: