apache-drill version: 1.22.0
oracle version: 11g
The query will return an error when the SQL statement contains limit.
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:
{
"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
}