drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sungwook Yoon <sy...@maprtech.com>
Subject mssql jdbc error on drill 1.8
Date Tue, 15 Nov 2016 19:00:57 GMT
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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message