[IMPALA-12319] NullPointerException in UnnestExpr.isBoundByTupleIds()

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 4.1.0, Impala 4.2.0, Impala 4.1.1, Impala 4.1.2
• Fix Version/s: Impala 4.3.0
• Component/s: Frontend
• Target Version: Impala 4.1.3
• Epic Color: ghx-label-7
• Assignee: Quanlong Huang
• Reporter: Quanlong Huang
• Created: 27/Jul/23 06:55
• Updated: 31/Jul/23 06:28
• Resolved: 31/Jul/23 06:28

Description

Create a table with the array type:

create table array_test(
  col1 string,
  col2 string,
  names array<string>)
stored as parquet;

The following query failed by NullPointerException:

select
  col1,
  row_number() over(partition by col1 order by name) as rn
from (
  select
    col1,
    col2,
    unnest(names) as name
  from array_test
) m1;

Stacktrace of the exception:

I0727 14:16:09.869918 30463 Frontend.java:2344] db4ea476341c34b5:717cbd2400000000] Analysis and authorization finished.
I0727 14:16:09.922134 30463 jni-util.cc:288] db4ea476341c34b5:717cbd2400000000] java.lang.NullPointerException
        at org.apache.impala.analysis.UnnestExpr.isBoundByTupleIds(UnnestExpr.java:246)
        at org.apache.impala.analysis.Expr.isBound(Expr.java:1408)
        at org.apache.impala.analysis.SortInfo.checkConsistency(SortInfo.java:177)
        at org.apache.impala.analysis.SortInfo.createSortTupleInfo(SortInfo.java:244)
        at org.apache.impala.planner.AnalyticPlanner.createSortInfo(AnalyticPlanner.java:358)
        at org.apache.impala.planner.AnalyticPlanner.createSortInfo(AnalyticPlanner.java:320)
        at org.apache.impala.planner.AnalyticPlanner.createSortGroupPlan(AnalyticPlanner.java:426)
        at org.apache.impala.planner.AnalyticPlanner.createSingleNodePlan(AnalyticPlanner.java:143)
        at org.apache.impala.planner.SingleNodePlanner.createQueryPlan(SingleNodePlanner.java:296)
        at org.apache.impala.planner.SingleNodePlanner.createSingleNodePlan(SingleNodePlanner.java:171)
        at org.apache.impala.planner.Planner.createPlanFragments(Planner.java:127)
        at org.apache.impala.planner.Planner.createPlans(Planner.java:280)
        at org.apache.impala.service.Frontend.createExecRequest(Frontend.java:1801)
        at org.apache.impala.service.Frontend.getPlannedExecRequest(Frontend.java:2677)
        at org.apache.impala.service.Frontend.doCreateExecRequest(Frontend.java:2472)
        at org.apache.impala.service.Frontend.getTExecRequest(Frontend.java:2089)
        at org.apache.impala.service.Frontend.createExecRequest(Frontend.java:1860)
        at org.apache.impala.service.JniFrontend.createExecRequest(JniFrontend.java:165)