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)