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

["Charles Givre (Jira)" <ji...@apache.org>]

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)