[jira] [Created] (DRILL-2962) Correlates subquery with scalar aggregate or scalar aggregate with expression throws and error

["Victoria Markman (JIRA)" <ji...@apache.org>]

Victoria Markman created DRILL-2962:
---------------------------------------

             Summary: Correlates subquery with scalar aggregate or scalar aggregate with expression throws  and error
                 Key: DRILL-2962
                 URL: https://issues.apache.org/jira/browse/DRILL-2962
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning & Optimization
    Affects Versions: 0.9.0
            Reporter: Victoria Markman
            Assignee: Aman Sinha
            Priority: Critical
             Fix For: 1.0.0


Filing this bug on Aman's request. It is not the same as DRILL-2949
DRILL-2949 has two outer tables.

{code}
0: jdbc:drill:schema=dfs> select * from t1 where a1 > (select avg(a2)*100 from t2 where c1 = c2);
Query failed: SYSTEM ERROR: Non-scalar sub-query used in an expression
See Apache Drill JIRA: DRILL-1937
[991f5544-d44f-4ba2-aa70-783a88a5b16a on atsqa4-133.qa.lab:31010]
Error: exception while executing query: Failure while executing query. (state=,code=0)

Correlated scalar aggregation without expression:

0: jdbc:drill:schema=dfs> select * from t1 where a1 > (select avg(a2) from t2 where c1 = c2);
Query failed: SYSTEM ERROR: This query cannot be planned possibly due to either a cartesian join or an inequality join
[f238c0c0-efea-4684-8ec3-899fbcc2a075 on atsqa4-133.qa.lab:31010]
Error: exception while executing query: Failure while executing query. (state=,code=0)
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)