gaoxingxs opened a new issue, #2993:
URL: https://github.com/apache/drill/issues/2993
apache-drill version: 1.22.0
oracle version: 11g
The query will return an error when the SQL statement contains `limit`.
```log
org.apache.drill.common.exceptions.UserRemoteException: DATA_READ ERROR: The
JDBC storage plugin failed while trying setup the SQL query.
Sql: SELECT *
FROM "APEX_030200"."WWV_FLOWS"
FETCH NEXT 10 ROWS ONLY
Fragment: 0:0
```
storage plugin:
```json
{
"type": "jdbc",
"driver": "oracle.jdbc.OracleDriver",
"url": "jdbc:oracle:thin:@//xxx.xxx.xxx.xxx:1521/orcl",
"username": "xxx",
"password": "xxx",
"authMode": "SHARED_USER",
"writerBatchSize": 10000,
"enabled": true
}
```
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
