Hi Jacques, Do you know if the 1.3 release addresses the JDBC issues that appeared to be related to MSSQL's three part naming?
Thanks, Eric On Fri, Nov 6, 2015 at 2:48 PM, Jacques Nadeau <[email protected]> wrote: > He Kieran, > > There were some issues with the 1.2 JDBC storage plugin. It had issues with > certain data types including TEXT/BLOB. We're in the process of releasing > version 1.3 of Drill which should solve many of these issues. Can you try > the current release candidate of Drill 1.3 to see if that solves the issues > you are seeing? > > You can download the release candidate here: > > http://people.apache.org/~jacques/apache-drill-1.3.0.rc0/ > > thanks, > Jacques > > -- > Jacques Nadeau > CTO and Co-Founder, Dremio > > On Fri, Nov 6, 2015 at 10:09 AM, Kieran Benton <[email protected]> > wrote: > > > 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 > > >
