kshitij limaye created DRILL-6720:
-------------------------------------
Summary: Unable to read more than 1000 records from DB2 table
Key: DRILL-6720
URL: https://issues.apache.org/jira/browse/DRILL-6720
Project: Apache Drill
Issue Type: Bug
Components: Storage - JDBC
Affects Versions: 1.9.0
Reporter: kshitij limaye
Fix For: 1.9.0
Attachments: drill_DB2_query_error_log.txt, drill_db2_query_status.PNG
We have created a storage plugin in drill for DB2 database, PFB the details:
{
"type": "jdbc",
"driver": "com.ibm.db2.jcc.DB2Driver",
"url": "jdbc:db2://server:port/databasename",
"username": "user",
"password": "password",
"enabled": true
}
We are using a type 4 JDBC driver.
When we try to read the data in any of the tables, the query fails with
following error from drill:
org.apache.drill.common.exceptions.UserRemoteException: DATA_READ ERROR:
Failure while attempting to read from database. sql SELECT * FROM schema.table
plugin DB2_PLUGIN Fragment 0:0 [Error Id: 1404544f-bb5e-439b-b1a8-679388bb344d
on server:port]
The error logs from drill have been attached.
One interesting observation - when we put a LIMIT clause of <=1000 to the
query, the query works and returns the data. Anything more than 1000 in LIMIT
clause throws back the same error as above.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
