drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Victoria Markman (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (DRILL-2962) Correlated subquery with scalar aggregate or scalar aggregate with expression throws and error
Date Fri, 15 May 2015 21:53:01 GMT

     [ https://issues.apache.org/jira/browse/DRILL-2962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Victoria Markman closed DRILL-2962.
-----------------------------------

> 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)

Mime
View raw message