drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Sun <j...@maprtech.com>
Subject Re: mssql jdbc error on drill 1.8
Date Tue, 15 Nov 2016 19:05:58 GMT
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 <syoon@maprtech.com> 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


Mime
View raw message