Hi, Yeah I'm having similar issues, although with Exasol not MSSQL, I get the feeling that the driver doesn't understand what a schema is in my case, which could be plausible considering mysql doesn't have the concept of schema.
I'll have a poke around the source code later. Tom On Wed, Oct 28, 2015 at 10:52 AM, Holy Alexander < [email protected]> wrote: > I would love to use the new Drill 1.2 Feature and combine drill and > relational backend queries. > > Specifically, I would like to use this with Microsoft SQL Server 2014 as a > backend. > (I am running Drill in embedded mode on Windows, but this should not > affect the following?) > > Following the documentation I copied sqljdbc42.jar (the most recent > official Microsoft SQL JDBC Driver) to the ...\jars\3rdparty directory. > > I configured a storage plugin named "sqldwh", defined as: > { > "type": "jdbc", > "driver": "com.microsoft.sqlserver.jdbc.SQLServerDriver", > "url": "jdbc:sqlserver://SQLSERVERNAME", > "username": "USERNAME", > "password": "PASSWORD", > "enabled": true > } > > (SQLSERVERNAME, USERNAME, PASSWORD, DATABASENAME, TABLENAME obviously > replaced with real configuration) > > Drill reports "success". > > Running a query like > select * from sqldwh.DATABASENAME.dbo.TABLENAME > > reports Table not found. Obviously the USERNAME/PASSWORD is properly > authorized to read this table. > > The Error reported is: > Query Failed: An Error Occurred > org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR: > From line 2, column 6 to line 2, column 11: Table > 'sqldwh.DATABASENAME.dbo.TABLENAME' not found [Error Id: > fc51f6e0-b0b7-448d-94c2-3a3666750416 on PC1234:31010] > > I'm lost at this point. > > First and foremost: Is this supposed to work at all? (with anything else > than MySql?) > > >
