# Error: DATA\_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query

**URL:** <https://community.dremio.com/t/error-data-read-error-the-jdbc-storage-plugin-failed-while-trying-setup-the-sql-query/5042>\
**Category:** Uncategorized\
**Created:** [February 12, 2020, 6:18pm UTC](https://community.dremio.com/t/error-data-read-error-the-jdbc-storage-plugin-failed-while-trying-setup-the-sql-query/5042 "2020-02-12T18:18:46Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![idoor88](https://avatars.discourse-cdn.com/v4/letter/i/34f0e0/32.png) [@idoor88](https://community.dremio.com/u/idoor88)\
**Post date:** [February 12, 2020, 6:18pm UTC](https://community.dremio.com/t/error-data-read-error-the-jdbc-storage-plugin-failed-while-trying-setup-the-sql-query/5042/1 "2020-02-12T18:18:47Z")

</div>

Hi

1. I installed the 4.1.4 community version of dremio, and from its web UI, created Demo workspace, then used the samples csv file Samples.“[samples.dremio.com](http://samples.dremio.com)”.“SF weather 2018-2019.csv” and saved as weather into the Demo workspace, so when clicked on Demo workspace, on the right side panel the weather name showed up, the copied path is Demo.weather.
2. I installed the apache-drill-1.17.0 and dropped the jdbc file: dremio-jdbc-driver-4.1.4-202001240912140359-a90eb503.jar into the jars/3rdparty folder and jdbc-driver folder.
3. Started apache drill with ./drill-embedded command, then went to drill web UI, created storage plugin: dremiodemo:  
{  
“type”: “jdbc”,  
“driver”: “com.dremio.jdbc.Driver”,  
“url”: “jdbc:dremio:direct=localhost:41010;schema=Demo”,  
“username”: “admin”,  
“password”: “”,  
“caseInsensitiveTableNames”: true,  
“enabled”: true  
}  
since apache drill is also using 31010, I changed the dremio jdbc port to 41010 in the conf file.
4. from drill started session, type show databases;  
dremiodemo.demo is listed as one of the schema names,  
then:  
type select \* from dremiodemo.demo.weather;  
I got error: Error: DATA\_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query.

sql SELECT \*

FROM “DREMIO”.“Demo”.“weather”

plugin dremiodemo

Fragment 0:0

in the Dremio server.log file, it showed erro:  
Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Table ‘DREMIO.Demo.weather’ not found  
Any clues? thanks for help.

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [February 14, 2020, 7:49am UTC](https://community.dremio.com/t/error-data-read-error-the-jdbc-storage-plugin-failed-while-trying-setup-the-sql-query/5042/2 "2020-02-14T07:49:36Z")

</div>

@idoor88

We do not support drill as a JDBC client. Does the same work from another JDBC client like DBeaver. If that works then problem is sue to Drill

Thanks  
@balaji.ramaswamy

---

<div class="post-metadata">

**Author:** ![idoor88](https://avatars.discourse-cdn.com/v4/letter/i/34f0e0/32.png) [@idoor88](https://community.dremio.com/u/idoor88)\
**Post date:** [February 18, 2020, 3:32pm UTC](https://community.dremio.com/t/error-data-read-error-the-jdbc-storage-plugin-failed-while-trying-setup-the-sql-query/5042/3 "2020-02-18T15:32:02Z")

</div>

I do not think that is correct statement: not support drill as a JDBC client, since I used the 4.0.4 version of dremio with apache drill 1.14, it worked before, so the new version should support as well

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [February 19, 2020, 5:44am UTC](https://community.dremio.com/t/error-data-read-error-the-jdbc-storage-plugin-failed-while-trying-setup-the-sql-query/5042/4 "2020-02-19T05:44:44Z")

</div>

@idoor88

It may definitely work but we have not tested the product with Drill. We do not do any kind of testing with Drill nor actually list as supported JDBC tools in our docs

[Dremio Client Connectivity](https://docs.dremio.com/client-applications/clients.html)

Thanks  
Bali

Thanks  
@balaji.ramaswamy

---

<div class="post-metadata">

**Author:** ![idoor88](https://avatars.discourse-cdn.com/v4/letter/i/34f0e0/32.png) [@idoor88](https://community.dremio.com/u/idoor88)\
**Post date:** [February 20, 2020, 5:35pm UTC](https://community.dremio.com/t/error-data-read-error-the-jdbc-storage-plugin-failed-while-trying-setup-the-sql-query/5042/5 "2020-02-20T17:35:46Z")

</div>

Thanks for your help!  
I tested from DBeaver, it works, also my question is my query is:  
select \* from dremiodemo.demo.weather;  
and the error message is:  
SqlValidatorException: Table ‘DREMIO.Demo.weather’ not found,

Why Dremio looks for table “DREMIO.Demo.weather”?  
I tried to configure the jdbc driver plugin:  
“url”: “jdbc:dremio:direct=localhost:41010" without schema=Demo  
but the error is the same. Dremio always added the “DREMIO” keyword into the query.