[
https://issues.apache.org/jira/browse/DRILL-7698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17091674#comment-17091674
]
Rafael Jaimes commented on DRILL-7698:
--------------------------------------
I can confirm these results with a deployed Presto instance. The queries are
showing up in the Presto logs and, from what I can tell, they are executing
without error.
Drill results in the following error using the Drill web interface to execute a
query (presto3 is the name of my storage plugin):
```
UserRemoteException : VALIDATION ERROR: From line 1, column 15 to
line 1, column 21: Object 'presto3' not found
org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR: From
line 1, column 15 to line 1, column 21: Object 'presto3' not found
[Error Id: f900b07e-c5bd-4b14-9606-54c85ac8f8a7 ]
```
> 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
> Priority: Major
> 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)
