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] [Commented] (DRILL-2152) Scalar Subqueries error message should be friendly
Date Thu, 10 Sep 2015 23:07:45 GMT

    [ https://issues.apache.org/jira/browse/DRILL-2152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14739819#comment-14739819
] 

Victoria Markman commented on DRILL-2152:
-----------------------------------------

Yes, these queries are supported now and we do have tests for them (including queries that
throw errors)

Unsupported operation exception:
{code}
0: jdbc:drill:schema=dfs> select * from t1 where a1 < ( select a2 from t2 limit 1 );
Error: UNSUPPORTED_OPERATION ERROR: This query cannot be planned possibly due to either a
cartesian join or an inequality join
[Error Id: f819cc3b-4aef-477d-a251-7d71dae75449 on atsqa4-133.qa.lab:31010] (state=,code=0)
{code}

This query works now:
{code}
0: jdbc:drill:schema=dfs> select * from t1 where a1 < ( select max(a2) from t2);
+-----+--------+-------------+
| a1  |   b1   |     c1      |
+-----+--------+-------------+
| 1   | aaaaa  | 2015-01-01  |
| 2   | bbbbb  | 2015-01-02  |
| 3   | ccccc  | 2015-01-03  |
| 4   | null   | 2015-01-04  |
| 5   | eeeee  | 2015-01-05  |
| 6   | fffff  | 2015-01-06  |
| 7   | ggggg  | 2015-01-07  |
+-----+--------+-------------+
7 rows selected (1.997 seconds)
{code}

However, I just found one more case where we failed to return correct error.
First query should throw the same exception as the second one:
{code}
0: jdbc:drill:schema=dfs> select * from t1 where (a1, b1) = ( select a2, b2 from t2);
Error: PARSE ERROR: From line 1, column 37 to line 1, column 57: Cannot apply '$SCALAR_QUERY'
to arguments of type '$SCALAR_QUERY(<RECORDTYPE(ANY A2, ANY B2)>)'. Supported form(s):
'$SCALAR_QUERY(<RECORDTYPE(SINGLE FIELD)>)'
[Error Id: ec158031-dbbb-4a84-bd04-615f806dc9d2 on atsqa4-133.qa.lab:31010] (state=,code=0)

0: jdbc:drill:schema=dfs> select * from t1 where a1 = ( select a2 from t2);
Error: UNSUPPORTED_OPERATION ERROR: Non-scalar sub-query used in an expression
See Apache Drill JIRA: DRILL-1937
[Error Id: db70881f-0b26-47ed-8c69-ee63c25bb260 on atsqa4-133.qa.lab:31010] (state=,code=0)
{code}

Reopening this bug for fixing this case.


> Scalar Subqueries error message should be friendly
> --------------------------------------------------
>
>                 Key: DRILL-2152
>                 URL: https://issues.apache.org/jira/browse/DRILL-2152
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>            Reporter: Jacques Nadeau
>            Assignee: Sean Hsuan-Yi Chu
>             Fix For: 1.2.0
>
>




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

Mime
View raw message