Can you turn on verbose errors and rerun your query? Also, did you add the
Postgres jdbc driver jar to the classpath? Drill doesn't currently
prepackage particular driver jars.
On Sep 22, 2015 3:53 AM, "Michael Franzkowiak" <[email protected]> wrote:
> I wanted to give the JDBC Storage Plugin a spin and tried to connect to a
> Postgres DB.
>
> I set up the storage plugin using the following config:
>
> {
> "type": "jdbc",
> "driver": "org.postgresql.Driver",
> "url": "jdbc:postgresql://127.0.0.1/mydb",
> "username": "dev",
> "password": null,
> "enabled": true
> }
>
> Unfortunately SHOW TABLES does not return anything.
>
> Also I wasn't able to execute a query on the Postgres DB. For any query I
> ran (e.g. SELECT some_column FROM mytable) it would just return:
>
> Error: DATA_READ ERROR: The JDBC storage plugin failed while trying setup
> the SQL query.
> sql SELECT *
> FROM "mydb"."mytable"
> plugin postgres
> Fragment 0:0
>
> Anything I'm doing wrong? Not a drill expert ( yet :) ).
>
