You may want to look at this blog: https://blogs.msdn.microsoft.com/data_otaku/2016/05/31/connect-drill-to-an-azure-sql-database/
-James > On Nov 15, 2016, at 11:00, Sungwook Yoon <[email protected]> wrote: > > Hi, > > I have encountered MS SQL Jdbc plugin issue. > Storage setup is done. > > I can use the database. > I can list the tables. > > But when I tried to select something, it coughs up following error. > > What needs to be done? > > Thanks, > > Sungwook > > Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object > name 'EpicShd.clarity_fc'. > at com.microsoft.sqlserver.jdbc.SQLServerException. > makeFromDatabaseError(SQLServerException.java:217) ~[sqljdbc41.jar:na] > at > com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655) > ~[sqljdbc41.jar:na] > at com.microsoft.sqlserver.jdbc.SQLServerStatement. > doExecuteStatement(SQLServerStatement.java:885) ~[sqljdbc41.jar:na] > at com.microsoft.sqlserver.jdbc.SQLServerStatement$ > StmtExecCmd.doExecute(SQLServerStatement.java:778) ~[sqljdbc41.jar:na] > at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505) > ~[sqljdbc41.jar:na] > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2444) > ~[sqljdbc41.jar:na] > at > com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191) > ~[sqljdbc41.jar:na] > at > com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:166) > ~[sqljdbc41.jar:na] > at > com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:677) > ~[sqljdbc41.jar:na] > at > org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) > ~[commons-dbcp-1.4.jar:1.4] > at > org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) > ~[commons-dbcp-1.4.jar:1.4] > at > org.apache.drill.exec.store.jdbc.JdbcRecordReader.setup(JdbcRecordReader.java:177) > [drill-jdbc-storage-1.8.0.jar:1.8.0] > ... 26 common frames omitted
