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

null should be handled consistently in Join

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.4.0
    • 0.6.0
    • None
    • None
    • Reviewed

    Description

      Currenlty Pig mostly follows SQL semantics for handling null. However there are certain cases where pig may need to handle nulls correctly. One example is the join - joins on single keys results in null keys not matching to produce an output. However if the join is on >1 keys, in the key tuple, if one of the values is null, it still matches with another key tuple which has a null for that value. We need to decide the right semantics here.

      Attachments

        1. PIG-927-1.patch
          4 kB
          Daniel Dai
        2. PIG-927-2.patch
          4 kB
          Daniel Dai

        Activity

          People

            daijy Daniel Dai
            pkamath Pradeep Kamath
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: