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)
