[DRILL-746] Union all operator not working with tables in hive

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Duplicate
• Fix Version/s: 0.4.0
• Component/s: Query Planning & Optimization
• Assignee: Aman Sinha
• Reporter: Rahul Kumar Challapalli
• Created: 15/May/14 00:11
• Updated: 15/Apr/15 18:40
• Resolved: 09/Jun/14 06:48

Description

Attached the DDL and a small data set that I used. The below query fails to be parsed

select * from hive.hivestudents1 union all select * from hive.hivestudents2;

Error: exception while executing query (state=,code=0)
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "2602c8e6-2654-40bd-b000-3f015e7d699f"
endpoint {
address: "qa-node191.qa.lab"
user_port: 31010
control_port: 31011
data_port: 31012
}
error_type: 0
message: "Failure while parsing sql. < CannotPlanException:[ Node [rel#125:Subset#8.PHYSICAL.SINGLETON([]).[]] could not be implemented; planner state:

Root: rel#125:Subset#8.PHYSICAL.SINGLETON([]).[]

Issue Links

• duplicates: DRILL-600 CannotPlanException for a query with UNION ALL
• is duplicated by: DRILL-600 CannotPlanException for a query with UNION ALL