Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-15456 Umbrella JIRA for all subquery redesign related tasks and issues
  3. HIVE-16432

Improve plan for subquery with EXISTS

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • None
    • None
    • Logical Optimizer
    • None

    Description

      If an EXISTS/NOT EXISTS subquery contains an aggregate (with no group by or windowing) it is guaranteed to produce at least one row. Since such subquery in WHERE clause tests for existence of row it could be replaced by true during compile time.

      Attachments

        Issue Links

          Is contained by

          Sub-task - The sub-task of the issue HIVE-15757 Allow EXISTS/NOT EXISTS correlated subquery with aggregates

          • Major - Major loss of function.
          • Closed

          Activity

            People

              kkasa Krisztian Kasa
              vgarg Vineet Garg
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: