[
https://issues.apache.org/jira/browse/IMPALA-1415?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Armstrong resolved IMPALA-1415.
-----------------------------------
Resolution: Later
> Improve analysis error in subqueries with correlated predicates
> ---------------------------------------------------------------
>
> Key: IMPALA-1415
> URL: https://issues.apache.org/jira/browse/IMPALA-1415
> Project: IMPALA
> Issue Type: Bug
> Components: Frontend
> Affects Versions: Impala 2.0
> Reporter: Jiachangxin
> Priority: Minor
> Labels: impala, planner, ramp-up, usability
>
> {code}
> create table A (a string,b int);
> create table B (c string,d int);
> [bigdata2:21000] > select * from A where exists (select 1 from B where
> strleft(a,length(c))=c);
> Query: select * from A where exists (select 1 from B where
> strleft(a,length(c))=c)
> ERROR: AnalysisException: Unsupported predicate with subquery: EXISTS (SELECT
> 1 FROM jiachx.B WHERE strleft(a, length(c)) = c) <=== The error
> [bigdata2:21000] > select * from A where exists (select 1 from B where
> strleft(a,10)=c);
> Query: select * from A where exists (select 1 from B where strleft(a,10)=c)
> Fetched 0 row(s) in 0.52s
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
