Skip to content

An error occurred when querying the database by pagination from Oracle 11g database #2993

Description

@gaoxingxs

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
}

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions