Hive
  1. Hive
  2. HIVE-784

Support uncorrelated subqueries in the WHERE clause

    Details

    • Type: New Feature New Feature
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.13.0
    • Component/s: Query Processor
    • Labels:
      None
    • Release Note:
      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.

      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

          No work has yet been logged on this issue.

            People

            • Assignee:
              Harish Butani
              Reporter:
              Ning Zhang
            • Votes:
              5 Vote for this issue
              Watchers:
              27 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development