[jira] [Created] (DRILL-5707) Non-scalar subquery fails the whole query if it's aggregate column has an alias

["Muhammad Gelbana (JIRA)" <ji...@apache.org>]

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)