[jira] [Resolved] (IMPALA-1478) Improve error message when subquery is used in the ON clause

["bharath v (JIRA)" <ji...@apache.org>]

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

bharath v resolved IMPALA-1478.
-------------------------------
       Resolution: Fixed
    Fix Version/s: Impala 2.10.0

https://github.com/apache/incubator-impala/commit/b9880cefbe97be2f5c7ed706a9b570c8b3234e34

> Improve error message when subquery is used in the ON clause
> ------------------------------------------------------------
>
>                 Key: IMPALA-1478
>                 URL: https://issues.apache.org/jira/browse/IMPALA-1478
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Frontend
>    Affects Versions: Impala 2.0, Impala 2.2, Impala 2.3.0, Impala 2.5.0
>            Reporter: Dimitris Tsirogiannis
>            Assignee: Pranay Singh
>            Priority: Minor
>              Labels: newbie, planner, supportability, usability
>             Fix For: Impala 2.10.0
>
>
> Improve the error message when a subquery is used in an ON clause.
> Example: 
> {code}
> [localhost:21000] > select * from alltypes a inner join alltypes b on a.id = b.id and a.int_col < (select min(id) from alltypes c);
> Query: select * from alltypes a inner join alltypes b on a.id = b.id and a.int_col < (select min(id) from alltypes c)
> ERROR: AnalysisException: null
> CAUSED BY: IllegalStateException: null
> {code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)