RE: I have huge data in oracle and am loading into hive. After 1hr, oracle extraction failed with error “java.sql.SQLException: ORA-01013: user requested

I have huge data in oracle and am loading into hive. After 1hr, oracle extraction failed with error “java.sql.SQLException: ORA-01013: user requested cancel of current operation”. How to overcome this error?

JohnGS Advanced User Asked on July 15, 2019 in Diyotta Agent.
Add Comment
1 Answers

This error is due to query timed out. Diyotta having a default setting of QUERY_TIMEOUT to 3600 seconds(1hr). To change default setting, go to Admin and corresponding agent configurations and update with higher value.

RE: I have huge data in oracle and am loading into hive. After 1hr, oracle extraction failed with error “java.sql.SQLException: ORA-01013: user requested

Expert Answered on July 15, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.