[jira] [Commented] (DRILL-7698) RDBMS Plugin Not Returning Results from Presto

["Rafael Jaimes (Jira)" <ji...@apache.org>]

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

Rafael Jaimes commented on DRILL-7698:
--------------------------------------

Revelation today...

I successfully queried PrestoSQL using Drill 1.17 stable. It appears somewhere along the lines that the JDBC generic adapter, as you suggested, developed a bug along the 1.18 branch.

I was using a development 1.18 branch for testing but didn't think to try the Presto query on a separate 1.17 instance. Sure enough, it works.

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