[IMPALA-2266] IllegalStateException: Illegal reference to non-materialized tuple: tid=3

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Impala 2.3.0
• Fix Version/s: Impala 2.2.7, Impala 2.3.0

Environment

commit 8fcdff03363fa663fbf1d049659cc35f193aaa9d
Author: Tim Armstrong <[e-mail]>
Date: Thu Aug 27 13:27:29 2015 -0700

    IMPALA-2257: fix broken build caused by IMPALA-2251 fix

• Target Version: Impala 2.2.7, Impala 2.3.0
• Assignee: Alexander Behm
• Reporter: casey
• Created: 29/Aug/15 05:00
• Updated: 01/Sep/15 23:53
• Resolved: 30/Aug/15 00:14

Description

Please see the query below

[localhost:21000] > select * from (select count(distinct int_col) cd from functional.alltypes) v;
Query: select * from (select count(distinct int_col) cd from functional.alltypes) v
ERROR: IllegalStateException: Illegal reference to non-materialized tuple: tid=3

Stacktrace

I0828 21:58:01.509037 27319 jni-util.cc:177] java.lang.IllegalStateException: Illegal reference to non-materialized tuple: tid=3
  at com.google.common.base.Preconditions.checkState(Preconditions.java:145)              
  at com.cloudera.impala.analysis.SlotRef.toThrift(SlotRef.java:147)                      
  at com.cloudera.impala.analysis.Expr.treeToThriftHelper(Expr.java:488)                  
  at com.cloudera.impala.analysis.Expr.treeToThrift(Expr.java:470)                        
  at com.cloudera.impala.analysis.Expr.treesToThrift(Expr.java:519)                       
  at com.cloudera.impala.planner.PlanFragment.toThrift(PlanFragment.java:280)             
  at com.cloudera.impala.service.Frontend.createExecRequest(Frontend.java:935)            
  at com.cloudera.impala.service.JniFrontend.createExecRequest(JniFrontend.java:147) 

Changing the table to alltypestiny somehow avoids the problem

[localhost:21000] > select * from (select count(distinct int_col) cd from functional.alltypestiny) v;
Query: select * from (select count(distinct int_col) cd from functional.alltypestiny) v
+----+
| cd |
+----+
| 2  |
+----+