Mailing-List: contact dev-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Thu, 23 Feb 2017 01:34:44 +0000 (UTC)
From: "Martina Ponca (JIRA)" <jira@apache.org>
To: dev@drill.apache.org
Message-ID: <JIRA.13045470.1487813678000.38187.1487813684208@Atlassian.JIRA>
In-Reply-To: <JIRA.13045470.1487813678000@Atlassian.JIRA>
References: <JIRA.13045470.1487813678000@Atlassian.JIRA> <JIRA.13045470.1487813678663@jira-lw-us.apache.org>
Subject: [jira] [Created] (DRILL-5295) Unable to query
 INFORMATION_SCHEMA.`TABLES` if MySql storage plugin enabled
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Thu, 23 Feb 2017 01:34:52 -0000

Martina Ponca created DRILL-5295:
------------------------------------

             Summary: Unable to query INFORMATION_SCHEMA.`TABLES` if MySql storage plugin enabled
                 Key: DRILL-5295
                 URL: https://issues.apache.org/jira/browse/DRILL-5295
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 1.9.0
         Environment: Drill 1.9. Error can be reproduced running Drill locally on Windows and on Linux within zookeeper. I can reproduce it with 2 mysql servers.
            Reporter: Martina Ponca


Impact: Unable to connect from Qlik Sense to Drill because of MySql Storage Plugin enabled.

Steps to repro:
1. Create a new storage plugin to MySql Community Edition 5.5.43. Enable it.
2. Run query: "select * from INFORMATION_SCHEMA.`TABLES`"
3. Error: 
{code}
Error: SYSTEM ERROR: NullPointerException: Error. Type information for table bistoremysql.information_schema.CHARACTER_SETS provided is null.
Fragment 0:0
[Error Id: 2717cfe1-413d-4330-ab3f-720ae92ebc50 on mycomputer.domain.lan:31010]

  (java.lang.NullPointerException) Error. Type information for table bistoremysql.information_schema.CHARACTER_SETS provided is null.
    com.google.common.base.Preconditions.checkNotNull():250
    org.apache.drill.exec.store.ischema.InfoSchemaRecordGenerator$Tables.visitTableWithType():314
    org.apache.drill.exec.store.ischema.InfoSchemaRecordGenerator$Tables.visitTables():308
    org.apache.drill.exec.store.ischema.InfoSchemaRecordGenerator.scanSchema():215
    org.apache.drill.exec.store.ischema.InfoSchemaRecordGenerator.scanSchema():208
    org.apache.drill.exec.store.ischema.InfoSchemaRecordGenerator.scanSchema():208
    org.apache.drill.exec.store.ischema.InfoSchemaRecordGenerator.scanSchema():195
    org.apache.drill.exec.store.ischema.InfoSchemaTableType.getRecordReader():58
    org.apache.drill.exec.store.ischema.InfoSchemaBatchCreator.getBatch():36
    org.apache.drill.exec.store.ischema.InfoSchemaBatchCreator.getBatch():30
    org.apache.drill.exec.physical.impl.ImplCreator.getRecordBatch():148
    org.apache.drill.exec.physical.impl.ImplCreator.getChildren():171
    org.apache.drill.exec.physical.impl.ImplCreator.getRecordBatch():128
    org.apache.drill.exec.physical.impl.ImplCreator.getChildren():171
    org.apache.drill.exec.physical.impl.ImplCreator.getRootExec():101
    org.apache.drill.exec.physical.impl.ImplCreator.getExec():79
    org.apache.drill.exec.work.fragment.FragmentExecutor.run():206
    org.apache.drill.common.SelfCleaningRunnable.run():38
    java.util.concurrent.ThreadPoolExecutor.runWorker():1145
    java.util.concurrent.ThreadPoolExecutor$Worker.run():615
    java.lang.Thread.run():745 (state=,code=0)
{code}

The full query Qlik Sense runs:
{code:sql}
select TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE from INFORMATION_SCHEMA.`TABLES` WHERE TABLE_CATALOG LIKE 'DRILL' ESCAPE '\' AND TABLE_SCHEMA <> 'sys' AND TABLE_SCHEMA <> 'INFORMATION_SCHEMA'ORDER BY TABLE_TYPE, TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME
{code}

If I disable the mysql storage plugin, I can run the query and connect from Qlik (not a workaround). 

This issue cannot be reproduced using Drill 1.5. 


--
This message was sent by Atlassian JIRA
(v6.3.15#6346)