[IMPALA-9978] IllegalStateException for some HAVING subqueries

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Frontend
• Epic Color: ghx-label-9
• Assignee: Quanlong Huang
• Reporter: Tim Armstrong
• Created: 20/Jul/20 23:16
• Updated: 02/Apr/23 01:38

Description

I ran into some IllegalStateExceptions with the HAVING subquery support.

[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()