[ https://issues.apache.org/jira/browse/DRILL-2962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jinfeng Ni updated DRILL-2962: ------------------------------ Assignee: Aman Sinha (was: Jinfeng Ni) > 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)