[HIVE-15456] Umbrella JIRA for all subquery redesign related tasks and issues

• Type: Task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Logical Optimizer
• Labels: sub-query
• Assignee: Vineet Garg
• Reporter: Vineet Garg
• Created: 16/Dec/16 22:16
• Updated: 17/Oct/17 01:51

Description

With HIVE-15192 we are using Calcite's functionality to decorrelate and plan subqueries. This JIRA is to track all planned improvements, tasks and known bugs.

Issue Links

• relates to: HIVE-17726 Using exists may lead to incorrect results

Sub-Tasks

• Return path failures: Patch Available
• Fix semi-join conversion rule for subquery: Closed
• Use Calcite to de-correlate and plan subqueries: Closed
• Support multiple and nested subqueries: Closed
• Support scalar subqueries: Closed
• Allow multiple queries with disjunction: Closed
• Allow IN/NOT IN correlated subquery with aggregates: Closed
• Allow EXISTS/NOT EXISTS correlated subquery with aggregates: Closed
• Allow correlated scalar subqueries with aggregates which has non-equi join predicates: Closed
• Allow correlated subqueries with windowing clause: Open
• Inefficient plan for correlated subqueries: Closed
• Improve plans for correlated subquery with join and predicate: Closed
• Support subqueries in project/select: Resolved
• Support subqueries in complex expression in SELECT clause: Closed
• Improve plans for scalar subquery with aggregates: Closed
• Improve plan for subquery with EXISTS: Resolved
• Improve plans for subqueries with non-equi co-related predicates: Closed
• Enable subquery related Qtests for Hive on Spark: Closed