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

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: