You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Quanlong Huang (Jira)" <ji...@apache.org> on 2023/04/02 01:39:00 UTC
[jira] [Commented] (IMPALA-9978) IllegalStateException for some HAVING subqueries
[ https://issues.apache.org/jira/browse/IMPALA-9978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17707604#comment-17707604 ]
Quanlong Huang commented on IMPALA-9978:
----------------------------------------
Taking over this since I can still reproduce the issue.
> 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
> Priority: Major
>
> 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.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org