Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-5830

SubQuery: Not In subqueries should check if subquery contains nulls in matching column

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 0.13.0
    • Query Processor
    • None

    Description

      As pointed out by snarayanan in HIVE-784 for not in when there are nulls in the SubQuery's matching column the Outer Query should return no rows.

      Attachments

        1. HIVE-5830.3.patch
          82 kB
          Harish Butani
        2. HIVE-5830.2.patch
          81 kB
          Harish Butani

        Issue Links

          is part of

          New Feature - A new feature of the product, which has yet to be developed. HIVE-784 Support uncorrelated subqueries in the WHERE clause

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              rhbutani Harish Butani
              rhbutani Harish Butani
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: