Hi all, I'm having a whale of a time getting the JDBC storage support working with Drill 1.2 :) Could someone please give me a pointer at what I'm doing wrong, or even just confirm to me that the feature isnt baked yet and has issues?
I've done the following (I'm on Windows for my sins): 1. Installed Drill in embedded mode 2. Added the postgres jdbc driver to the jars / thirdparty folder as referenced at http://stackoverflow.com/questions/33311547/unable-to-configure-postgresql-jdbc-driver-using-apache-drill-1-2 3. ./sqlline.bat 4. !connect jdbc:drill:zk=local (admin/admin) 5. Accessed the web console and added a new storage 'customers' with the definition: { "type": "jdbc", "driver": "org.postgresql.Driver", "url": "jdbc:postgresql://localhost:5432/customers", "username": "customers", "password": "customers", "enabled": true } 6. Success! (took a while to get this far, finding the 'right' driver wasnt easy) 7. Try 'SELECT * FROM customers.profile;' in the console -> Error: VALIDATION ERROR: java.lang.NullPointerException [Error Id: 62cb35b1-db49-4740-ac38-4d748a080f3a on 172.31.9.168:31010] (state=,code=0) And then I'm completely stuck. Where do I go from here? Cheers, Kieran
