You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Tim Armstrong (Jira)" <ji...@apache.org> on 2020/07/20 23:17:00 UTC
[jira] [Created] (IMPALA-9978) IllegalStateException for some
HAVING subqueries
Tim Armstrong created IMPALA-9978:
-------------------------------------
Summary: IllegalStateException for some HAVING subqueries
Key: IMPALA-9978
URL: https://issues.apache.org/jira/browse/IMPALA-9978
Project: IMPALA
Issue Type: Bug
Components: Frontend
Reporter: Tim Armstrong
Assignee: Shant Hovsepian
I ran into some IllegalStateExceptions with the HAVING subquery support.
{noformat}
[localhost.EXAMPLE.COM:21000] default> select * from functional.alltypes t1 having int_col in (select int_col from functional.alltypestiny t2);
Query: select * from functional.alltypes t1 having int_col in (select int_col from functional.alltypestiny t2)
Query submitted at: 2020-07-20 16:13:24 (Coordinator: http://tarmstrong-box2:25000)
ERROR: IllegalStateException: null
....
I0720 16:13:57.010988 10267 impala-server.cc:1054] Found local timezone "America/Los_Angeles".
I0720 16:13:57.017076 10267 impala-server.cc:1108] d242b0293d625d8b:a94b57e400000000] Registered query query_id=d242b0293d625d8b:a94b57e400000000 session_id=5c4a2dd9d6a7f4b2:c2a692d85a80c4bf
I0720 16:13:57.017697 10267 Frontend.java:1508] d242b0293d625d8b:a94b57e400000000] Analyzing query: explain select * from functional.alltypes t1 having int_col in (select min(int_col) from functional.alltypestiny t2) db: default
I0720 16:13:57.025200 10267 jni-util.cc:288] d242b0293d625d8b:a94b57e400000000] java.lang.IllegalStateException
at com.google.common.base.Preconditions.checkState(Preconditions.java:492)
at org.apache.impala.analysis.InlineViewRef.analyze(InlineViewRef.java:221)
at org.apache.impala.analysis.StmtRewriter$SubqueryRewriter.rewriteHavingClauseSubqueries(StmtRewriter.java:1459)
at org.apache.impala.analysis.StmtRewriter$SubqueryRewriter.rewriteSelectStmtHook(StmtRewriter.java:1064)
at org.apache.impala.analysis.StmtRewriter.rewriteSelectStatement(StmtRewriter.java:104)
at org.apache.impala.analysis.StmtRewriter.rewriteQueryStatement(StmtRewriter.java:85)
at org.apache.impala.analysis.StmtRewriter.rewrite(StmtRewriter.java:73)
at org.apache.impala.analysis.AnalysisContext.analyze(AnalysisContext.java:482)
at org.apache.impala.analysis.AnalysisContext.analyzeAndAuthorize(AnalysisContext.java:426)
at org.apache.impala.service.Frontend.doCreateExecRequest(Frontend.java:1548)
at org.apache.impala.service.Frontend.getTExecRequest(Frontend.java:1515)
at org.apache.impala.service.Frontend.createExecRequest(Frontend.java:1485)
at org.apache.impala.service.JniFrontend.createExecRequest(JniFrontend.java:162)
I0720 16:13:57.025252 10267 status.cc:129] d242b0293d625d8b:a94b57e400000000] IllegalStateException: null
@ 0x1ca56ff impala::Status::Status()
{noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)