[
https://issues.apache.org/jira/browse/DRILL-2962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14546227#comment-14546227
]
Victoria Markman commented on DRILL-2962:
-----------------------------------------
Verified fixed in: 1.0.0
#Fri May 15 03:07:08 EDT 2015
git.commit.id.abbrev=d8b1975
Tests are in Functional/Passing/subqueries/scalar_aggregate/s[19|20].sql
> Correlated 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 t1.c1 = t2.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 t1.c1 = t2.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)
