[ https://issues.apache.org/jira/browse/DRILL-746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rahul Challapalli closed DRILL-746. ----------------------------------- Verified the fix and everything looks good > Union all operator not working with tables in hive > -------------------------------------------------- > > Key: DRILL-746 > URL: https://issues.apache.org/jira/browse/DRILL-746 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization > Reporter: Rahul Challapalli > Assignee: Aman Sinha > Priority: Blocker > Fix For: 0.4.0 > > Attachments: students.txt, unionall.ddl > > > 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([]).[] -- This message was sent by Atlassian JIRA (v6.3.4#6332)