drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sven0726 (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-5295) Unable to query INFORMATION_SCHEMA.`TABLES` if MySql storage plugin enabled
Date Mon, 17 Apr 2017 09:32:41 GMT

    [ https://issues.apache.org/jira/browse/DRILL-5295?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15970907#comment-15970907
] 

sven0726 commented on DRILL-5295:
---------------------------------

I also have this problem, so what is a good solution to stride over

> 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)

Mime
View raw message