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