Charles Givre created DRILL-7698:
------------------------------------
Summary: RDBMS Plugin Not Returning Results from Presto
Key: DRILL-7698
URL: https://issues.apache.org/jira/browse/DRILL-7698
Project: Apache Drill
Issue Type: Bug
Components: Storage - JDBC
Affects Versions: 1.18.0
Reporter: Charles Givre
Attachments: Screen Shot 2020-04-12 at 2.43.33 PM.png, Screen Shot
2020-04-12 at 2.56.10 PM.png, Screen Shot 2020-04-12 at 3.00.00 PM.png, Screen
Shot 2020-04-12 at 3.01.37 PM.png
Using the RDBMS storage plugin, Drill is unable to connect to Presto. More
specifically, Drill seems to be connecting and sending queries to Presto, but
then nothing happens with the query results.
I verified the configuration using DBBeaver and was able to successfully query
Presto. See screenshot below for config.
!Screen Shot 2020-04-12 at 2.43.33 PM.png!
Presto ships with a few sample databases as shown below, and these should be
visible in Drill but are not.
!Screen Shot 2020-04-12 at 2.56.10 PM.png!
>From the logs below, Presto is clearly receiving the queries from Drill, and
>the queries are returning results, but Drill seems to be dropping the results.
> While this may seem like a silly exercise, querying Presto from Drill, the
>fact that it didn't work makes me think we may have a bug in the JDBC Storage
>Plugin.
!Screen Shot 2020-04-12 at 3.01.37 PM.png!
!Screen Shot 2020-04-12 at 3.00.00 PM.png!
h2. Steps to Reproduce
1. Download and start Docker container with Presto.
2. Download Presto JDBC driver (https://prestodb.io/download.html) and copy to
Drill classpath.
3. Create RDBMS storage plugin instance using default config below:
{code:java}
{
"type": "jdbc",
"driver": "io.prestosql.jdbc.PrestoDriver",
"url": "jdbc:presto://localhost:8080/tpch/sf1",
"username": "user",
"password": null,
"caseInsensitiveTableNames": true,
"sourceParameters": {},
"enabled": true
}
{code}
4. Execute a SHOW DATABASES query and you will see that no presto related
results are returned. Various queries to the INFORMATION SCHEMA reveal the
same thing.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
