Maryann Xue created PHOENIX-945:
-----------------------------------
Summary: Support correlated subqueries
Key: PHOENIX-945
URL: https://issues.apache.org/jira/browse/PHOENIX-945
Project: Phoenix
Issue Type: Task
Affects Versions: 3.0.0, 4.0.0, 5.0.0
Reporter: Maryann Xue
Assignee: Maryann Xue
Fix For: 3.0.0, 4.0.0, 5.0.0
Example:
SELECT employee_number, name
FROM employees AS Bob
WHERE salary > (
SELECT AVG(salary)
FROM employees
WHERE department = Bob.department);
Basically we can optimize these queries into join queries, like:
SELECT employees.employee_number, employees.name
FROM employees INNER JOIN
(SELECT department, AVG(salary) AS department_average
FROM employees
GROUP BY department) AS temp ON employees.department = temp.department
WHERE employees.salary > temp.department_average;
--
This message was sent by Atlassian JIRA
(v6.2#6252)
