drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nagarajan Chinnasamy (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5063) Apache Drill Fails To Query MySQL View With Group By In Inner Select
Date Tue, 22 Nov 2016 12:58:58 GMT
Nagarajan Chinnasamy created DRILL-5063:
-------------------------------------------

             Summary: Apache Drill Fails To Query MySQL View With Group By In Inner Select
                 Key: DRILL-5063
                 URL: https://issues.apache.org/jira/browse/DRILL-5063
             Project: Apache Drill
          Issue Type: Bug
          Components: Client - JDBC, Storage - JDBC
    Affects Versions: 1.8.0, 1.7.0
            Reporter: Nagarajan Chinnasamy
            Priority: Critical


I am using

MySQL Version: 5.7.8 Drill Version: 1.7 and 1.8 MySQL JDBC Connector: mysql-connector-java-5.1.39-bin.jar

I have created a view on MySQL using the following query:

{code}
create or replace view `mydb`.`customerview` as
select
   `cust`.`Id` as `Customer`,
    `tnt`.`Id` as `Tenant`
from
   `mydb`.`Customer` cust
left join (
    select
        `t`.Id as Id
    from
        `mydb`.`Tenant` t
    group by t.Id) tnt
on
    `cust`.`Tenant`=`tnt`.`Id`
{code}
Please note that above query was purposely written so to reproduce the problem when using
group by.

In Drill I have created a storage plugin named mydb with following configuration:
{code}
{
  "type": "jdbc",
  "driver": "com.mysql.jdbc.Driver",
  "url": "jdbc:mysql://localhost:3306",
  "username": "xxxx",
  "password": "xxxx",
  "enabled": true
}
{code}
When I issue the following query from sqlline.bat on windows:
{code}
select * from mydb.`mydb`.`customerview`;
{code}
I get the following error:
{noformat}
Error: DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query.

sql SELECT * FROM mydb.customerview plugin mydb Fragment 0:0
{noformat}
Also, please note that if I remove group by in the inner select query, the error goes away!!



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message