drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rajeshwar Rao (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-5959) Unable to apply Union on multiple select query expressions
Date Mon, 13 Nov 2017 10:44:00 GMT

     [ 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:#205081}union all{color}
 select color, John , 'John' name
 from mysql.devcdp25.pivtest
{color:#205081}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} {color:#205081}union all{color}{color}
 select color, John , 'John' name
 from mysql.devcdp25.pivtest
{color:#f6c342} {color:#205081}union all{color}{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


> 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:#205081}union all{color}
>  select color, John , 'John' name
>  from mysql.devcdp25.pivtest
> {color:#205081}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)

Mime
View raw message