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?
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.