[
https://issues.apache.org/jira/browse/DRILL-5959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rajeshwar Rao updated DRILL-5959:
---------------------------------
Description:
Unable to combine the result sets of more than two separate query expressions
example :
select color, Paul , 'Paul' name
from mysql.devcdp25.pivtest
{color:#f6c342} union all{color}
select color, John , 'John' name
from mysql.devcdp25.pivtest
{color:#f6c342} union all{color}
select color, Tim , 'Tim' name
from mysql.devcdp25.pivtest
{color:#d04437}Query Failed: An Error Occurred{color}
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
was:
Unable to combine the result sets of more than two separate query expressions
example :
select color, Paul , 'Paul' name
from mysql.devcdp25.pivtest
{color:#f6c342} union all{color}
select color, John , 'John' name
from mysql.devcdp25.pivtest
{color:red}{color:#f6c342} union all{color}{color}
select color, Tim , 'Tim' name
from mysql.devcdp25.pivtest
{color:#d04437}getting the following error :{color}
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
> 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.10.0, 1.11.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
> {color:#f6c342} union all{color}
> select color, John , 'John' name
> from mysql.devcdp25.pivtest
> {color:#f6c342} union all{color}
> select color, Tim , 'Tim' name
> from mysql.devcdp25.pivtest
> {color:#d04437}Query Failed: An Error Occurred{color}
> 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)
