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

Support uncorrelated subqueries in the WHERE clause

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 0.13.0
    • Query Processor
    • None
    • Not ready for release

    Description

      Hive currently only support views in the FROM-clause, some Facebook use cases suggest that Hive should support subqueries such as those connected by IN/EXISTS in the WHERE-clause.

      Attachments

        1. SubQuerySpec.pdf
          337 kB
          Harish Butani
        2. D13443.2.patch
          192 kB
          Phabricator
        3. D13443.1.patch
          185 kB
          Phabricator
        4. tpchQueriesUsingSubQueryClauses.sql
          6 kB
          Harish Butani
        5. HIVE-784.2.patch
          187 kB
          Harish Butani
        6. HIVE-784.1.patch.txt
          26 kB
          Matthew Weaver

        Issue Links

          blocks

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

          • Major - Major loss of function.
          • Open
          incorporates

          Bug - A problem which impairs or prevents the functions of the product. HIVE-5830 SubQuery: Not In subqueries should check if subquery contains nulls in matching column

          • Major - Major loss of function.
          • Resolved

          New Feature - A new feature of the product, which has yet to be developed. HIVE-5613 Subquery support: disallow nesting of SubQueries

          • Major - Major loss of function.
          • Resolved

          New Feature - A new feature of the product, which has yet to be developed. HIVE-5614 Subquery support: allow subquery expressions in having clause

          • Major - Major loss of function.
          • Resolved

          New Feature - A new feature of the product, which has yet to be developed. HIVE-5615 Subquery support: more tests

          • Major - Major loss of function.
          • Resolved
          is duplicated by

          New Feature - A new feature of the product, which has yet to be developed. HIVE-4697 Subqueries with IN and NOT IN

          • Major - Major loss of function.
          • Resolved
          is related to

          New Feature - A new feature of the product, which has yet to be developed. HIVE-870 Implement LEFT SEMI JOIN

          • Major - Major loss of function.
          • Closed
          relates to

          Sub-task - The sub-task of the issue HIVE-3577 Subquery Unnesting

          • Critical - Crashes, loss of data, severe memory leak.
          • Open

          Activity

            People

              rhbutani Harish Butani
              nzhang Ning Zhang
              Votes:
              5 Vote for this issue
              Watchers:
              27 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: