Muhammad Gelbana created DRILL-5707:
---------------------------------------
Summary: Non-scalar subquery fails the whole query if it's
aggregate column has an alias
Key: DRILL-5707
URL: https://issues.apache.org/jira/browse/DRILL-5707
Project: Apache Drill
Issue Type: Bug
Components: Query Planning & Optimization, SQL Parser
Affects Versions: 1.11.0, 1.9.0
Reporter: Muhammad Gelbana
The following query can be handled by Drill
{code:sql}
SELECT b.marital_status, (SELECT SUM(position_id) FROM cp.`employee.json` a
WHERE a.marital_status = b.marital_status ) AS max_a FROM cp.`employee.json` b
{code}
But if I add an alias to the aggregate fuction
{code:sql}
SELECT b.marital_status, (SELECT SUM(position_id) MY_ALIAS FROM
cp.`employee.json` a WHERE a.marital_status = b.marital_status ) AS max_a FROM
cp.`employee.json` b
{code}
Drill starts complaining that it can't handle non-scalar subqueries
{noformat}
org.apache.drill.common.exceptions.UserRemoteException: UNSUPPORTED_OPERATION
ERROR: Non-scalar sub-query used in an expression See Apache Drill JIRA:
DRILL-1937
{noformat}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
