[IMPALA-67] Constant SELECT clauses do not work in subqueries

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 0.5
• Fix Version/s: Impala 1.0
• Assignee: Alexander Behm
• Reporter: Henry Robinson
• Created: 15/Feb/13 16:24
• Updated: 16/Apr/13 00:32
• Resolved: 16/Apr/13 00:32

Description

[localhost:21000] > select * from (select 'a' `x`) x;
Query: select * from (select 'a' `x`) x
ERROR: java.lang.IllegalStateException
        at com.google.common.base.Preconditions.checkState(Preconditions.java:129)
        at com.cloudera.impala.analysis.InlineViewRef.getMaterializedTupleIds(InlineViewRef.java:96)
        at com.cloudera.impala.planner.Planner.createSelectPlan(Planner.java:481)
        at com.cloudera.impala.planner.Planner.createQueryPlan(Planner.java:457)
        at com.cloudera.impala.planner.Planner.createPlanFragments(Planner.java:92)
        at com.cloudera.impala.service.Frontend.createExecRequest(Frontend.java:255)
        at com.cloudera.impala.service.JniFrontend.createExecRequest(JniFrontend.java:89)

This would be very useful for, e.g., materialising a tiny dimension table on an ad-hoc basis.