[IMPALA-66] Support for UNION with constant SELECT clauses

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 0.5
• Fix Version/s: Impala 0.7
• Assignee: Alexander Behm
• Reporter: Henry Robinson
• Created: 15/Feb/13 16:22
• Updated: 03/Apr/13 20:47
• Resolved: 03/Apr/13 20:47

Description

[localhost:21000] > select 'a' `x` union all select 'b' `x`;
Query: select 'a' `x` union all select 'b' `x`
ERROR: com.cloudera.impala.common.NotImplementedException: Distributed UNION with constant SELECT clauses not implemented.
        at com.cloudera.impala.planner.Planner.createMergeNodeFragment(Planner.java:287)
        at com.cloudera.impala.planner.Planner.createPlanFragments(Planner.java:179)
        at com.cloudera.impala.planner.Planner.createPlanFragments(Planner.java:109)
        at com.cloudera.impala.service.Frontend.createExecRequest(Frontend.java:255)
        at com.cloudera.impala.service.JniFrontend.createExecRequest(JniFrontend.java:89)

It would be nice to fix this, particularly without SELECT * FROM (VALUES ('a')('b')) T support, for conjuring multiple rows out of thin air.