You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by GitBox <gi...@apache.org> on 2022/01/02 10:47:44 UTC
[GitHub] [drill] alvaradojl opened a new issue #2418: Invalid usage of the option NEXT in the FETCH statement when querying SQL Server and using LIMIT clause
alvaradojl opened a new issue #2418:
URL: https://github.com/apache/drill/issues/2418
**Describe the bug**
Querying a SQL Server with drill jdbc fails.
Logs:
```
Caused by: java.lang.Exception: Invalid usage of the option NEXT in the FETCH statement.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:440)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:385)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:166)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:297)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
at org.apache.drill.exec.store.jdbc.JdbcRecordReader.setup(JdbcRecordReader.java:192)
at org.apache.drill.exec.physical.impl.ScanBatch.getNextReaderIfHas(ScanBatch.java:331)
at org.apache.drill.exec.physical.impl.ScanBatch.internalNext(ScanBatch.java:227)
at org.apache.drill.exec.physical.impl.ScanBatch.next(ScanBatch.java:298)
at org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119)
at org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:111)
at org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:59)
at org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:85)
at org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:170)
at org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:103)
at org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext(ScreenCreator.java:81)
at org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:93)
at org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:323)
at org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:310)
at .......(:0)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1762)
at org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:310)
at org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38)
at .......(:0)
```
**Steps to reproduce the behavior:**
Installing sqljdbc42.jar
Succesfully configuring the storage plugin pointing to an Azure SQL Server
Write a simple query with a specific limit e.g.
SELECT * FROM sqlsrv.`dbo`.`any_table` LIMIT 3 --or any number
**Expected behavior**
A specific number of row set by the LIMIT clause
**Additional context**
The sql server is deployed in Azure, so the jdbc is querying latest version of SQL Server.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@drill.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [drill] jnturton closed issue #2418: Invalid usage of the option NEXT in the FETCH statement when querying SQL Server and using LIMIT clause
Posted by GitBox <gi...@apache.org>.
jnturton closed issue #2418:
URL: https://github.com/apache/drill/issues/2418
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@drill.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [drill] jnturton commented on issue #2418: Invalid usage of the option NEXT in the FETCH statement when querying SQL Server and using LIMIT clause
Posted by GitBox <gi...@apache.org>.
jnturton commented on issue #2418:
URL: https://github.com/apache/drill/issues/2418#issuecomment-1017499339
P.S. a fix has been merged into master.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@drill.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [drill] jnturton commented on issue #2418: Invalid usage of the option NEXT in the FETCH statement when querying SQL Server and using LIMIT clause
Posted by GitBox <gi...@apache.org>.
jnturton commented on issue #2418:
URL: https://github.com/apache/drill/issues/2418#issuecomment-1003703779
Thanks for submitting this. We've already promoted it to a Jira issue
https://issues.apache.org/jira/browse/DRILL-8090
so I'll close here.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@drill.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org