Maryann Xue created PHOENIX-1392:
------------------------------------
Summary: Support sub-query in the SELECT list
Key: PHOENIX-1392
URL: https://issues.apache.org/jira/browse/PHOENIX-1392
Project: Phoenix
Issue Type: Task
Affects Versions: 3.0.0, 4.0.0, 5.0.0
Reporter: Maryann Xue
Assignee: Maryann Xue
Example:
SELECT Name, ListPrice,
(SELECT AVG(ListPrice) FROM Production.Product) AS Average,
ListPrice - (SELECT AVG(ListPrice) FROM Production.Product)
AS Difference
FROM Production.Product
WHERE ProductSubcategoryID = 1;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
