Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-13554 [Umbrella] SQL:2011 compliance
  3. HIVE-15986

Support "is [not] distinct from"

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.0.0
    • SQL

    Description

      Support standard "is [not] distinct from" syntax. For example this gives a standard way to do a comparison to null safe join: select * from t1 join t2 on t1.x is not distinct from t2.y. SQL standard reference Section 8.15

      Attachments

        1. HIVE-15986.1.patch
          13 kB
          Vineet Garg
        2. HIVE-15986.2.patch
          9 kB
          Vineet Garg
        3. HIVE-15986.3.patch
          12 kB
          Vineet Garg
        4. HIVE-15986.4.patch
          12 kB
          Vineet Garg
        5. HIVE-15986.5.patch
          10 kB
          Vineet Garg
        6. HIVE-15986.5.patch
          10 kB
          Vineet Garg
        7. HIVE-15986.7.patch
          79 kB
          Vineet Garg

        Issue Links

          links to

          Web Link ReviewBoard

          Activity

            People

              vgarg Vineet Garg
              cartershanklin Carter Shanklin
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: