You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Sungwook Yoon <sy...@maprtech.com> on 2016/11/15 19:00:57 UTC
mssql jdbc error on drill 1.8
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
Re: mssql jdbc error on drill 1.8
Posted by James Sun <js...@maprtech.com>.
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 <sy...@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