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?)
