Hive
  1. Hive
  2. HIVE-741

NULL is not handled correctly in join

    Details

      Description

      With the following data in table input4_cb:

      Key Value
      ------ --------
      NULL 325
      18 NULL

      The following query:

      select * from input4_cb a join input4_cb b on a.key = b.value;
      

      returns the following result:

      NULL 325 18 NULL

      The correct result should be empty set.

      When 'null' is replaced by '' it works.

      1. smbjoin_nulls.q.txt
        0.6 kB
        Amareshwari Sriramadasu
      2. patch-741-6.txt
        42 kB
        Amareshwari Sriramadasu
      3. patch-741-5.txt
        40 kB
        Amareshwari Sriramadasu
      4. patch-741-4.txt
        40 kB
        Amareshwari Sriramadasu
      5. patch-741-3.txt
        39 kB
        Amareshwari Sriramadasu
      6. patch-741-2.txt
        32 kB
        Amareshwari Sriramadasu
      7. patch-741-1.txt
        27 kB
        Amareshwari Sriramadasu
      8. patch-741.txt
        7 kB
        Amareshwari Sriramadasu
      9. join_nulls.q.out
        27 kB
        Ning Zhang

        Issue Links

          Activity

            People

            • Assignee:
              Amareshwari Sriramadasu
              Reporter:
              Ning Zhang
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development