[jira] [Created] (DRILL-5959) Unable to apply Union on multiple select query expressions

["Rajeshwar Rao (JIRA)" <ji...@apache.org>]

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)