Rajeshwar Rao created DRILL-5959: ------------------------------------ Summary: Unable to apply Union on multiple select query expressions Key: DRILL-5959 URL: https://issues.apache.org/jira/browse/DRILL-5959 Project: Apache Drill Issue Type: Bug Components: Client - JDBC Affects Versions: 1.11.0, 1.10.0 Reporter: Rajeshwar Rao Priority: Minor Fix For: Future
Unable to combine the result sets of more than two separate query expressions example : select color, Paul , 'Paul' name from mysql.devcdp25.pivtest union all select color, John , 'John' name from mysql.devcdp25.pivtest union all select color, Tim , 'Tim' name from mysql.devcdp25.pivtest getting the following error : Query Failed: An Error Occurred org.apache.drill.common.exceptions.UserRemoteException: DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query. sql SELECT * FROM (SELECT `color`, `Paul`, 'Paul' AS `name` FROM `devcdp25`.`pivtest` UNION ALL SELECT `color`, `John`, 'John' AS `name` FROM `devcdp25`.`pivtest`) UNION ALL SELECT `color`, `Tim`, 'Tim' AS `name` FROM `devcdp25`.`pivtest` plugin mysql Fragment 0:0 -- This message was sent by Atlassian JIRA (v6.4.14#64029)