Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sqoop import in closed cluster


Sqoop import in closed cluster


We have a closed cluster and we are trying run sqoop import from edge node. We have opened a firewall to oracle server from edge node but it is failing with following error, so do we need to open firewall on all worker nodes also ?

LPL_ACTIVITY_MSTR_HIST where ASOFDATE > to_timestamp(SUBSTR('2017-11-15 00:00:00.0 ',1,19),'YYYY-MM-DD HH24:MI:SS') and ( 1=1 ) AND ( 1=1 ) 2017-11-22 02:19:50,112 ERROR [main] org.apache.sqoop.mapreduce.db.DBRecordReader: Top level exception: java.sql.SQLRecoverableException: IO Error: Connection reset at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe( at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe( at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout( at oracle.jdbc.driver.OraclePreparedStatement.executeInternal( at oracle.jdbc.driver.OraclePreparedStatement.executeQuery( at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery( at org.apache.sqoop.mapreduce.db.DBRecordReader.executeQuery( at org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue( at org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue( at org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue( at$Context.nextKeyValue( at at at org.apache.hadoop.mapred.MapTask.runNewMapper( at at org.apache.hadoop.mapred.YarnChild$ at Method) at at at org.apache.hadoop.mapred.YarnChild.main( Caused by: Connection reset

Don't have an account?
Coming from Hortonworks? Activate your account here