Sqoop Execute Command:
./sqoop import--connect "Jdbc:db2://10.105.4.55:50001/sccrm55"--username db2inst1--password db2opr2010--table WF_4G _billdetail_new_20140717--fetch-size 1000-m 1--target-dir/ext/ods/ods_rpt_day_det/20140717_1-- Fields-terminated-by ' & '--lines-terminated-by ' \ n '
Error message:
Crmd3n:/d2_data0/user/ocdc/bin/sqoop-1.4.2-cdh4.2.1/bin>minated-by ' & '--lines-terminated-by ' \ n ' <
14/07/19 12:03:42 WARN tool. Basesqooptool:setting your password on the command-line is insecure. Consider Using-p instead.
14/07/19 12:03:42 INFO tool. Codegentool:beginning code Generation
14/07/19 12:03:42 INFO Manager. Sqlmanager:executing SQL Statement:select t.* from wf_4g_billdetail_new_20140717 as T WHERE 1=0
14/07/19 12:03:42 INFO Manager. Sqlmanager:executing SQL Statement:select t.* from wf_4g_billdetail_new_20140717 as T WHERE 1=0
14/07/19 12:03:42 INFO Orm.CompilationManager:HADOOP_MAPRED_HOME is/d2_data0/user/ocdc/bin/hadoop-2.0.0-mr1-cdh4.2.1
Note:/tmp/sqoop-ocdc/compile/81cb6e05dd500bc0b46638f93c4f2500/wf_4g_billdetail_new_20140717.java uses or overrides outdated APIs.
Note: To learn more, recompile with-xlint:deprecation.
14/07/19 12:03:43 INFO Orm. compilationmanager:writing jar File:/tmp/sqoop-ocdc/compile/81cb6e05dd500bc0b46638f93c4f2500/wf_4g_billdetail_ New_20140717.jar
14/07/19 12:03:50 INFO MapReduce. Importjobbase:beginning Import of wf_4g_billdetail_new_20140717
14/07/19 12:03:50 WARN util. nativecodeloader:unable to load Native-hadoop library for your platform ... using Builtin-java classes where applicable
14/07/19 12:03:50 INFO Manager. Sqlmanager:executing SQL Statement:select t.* from wf_4g_billdetail_new_20140717 as T WHERE 1=0
14/07/19 12:03:51 WARN mapred. Jobclient:use Genericoptionsparser for parsing the arguments. Applications should implement Tool for the same.
14/07/19 12:03:53 INFO mapred. Jobclient:running job:job_201407151514_3011
14/07/19 12:03:54 INFO mapred. Jobclient:map 0% Reduce 0%
14/07/19 12:04:05 INFO mapred. Jobclient:task Id:attempt_201407151514_3011_m_000000_0, status:failed
JAVA.LANG.RUNTIMEEXCEPTION:JAVA.LANG.RUNTIMEEXCEPTION:COM.IBM.DB2.JCC.A.PM: [jcc][t4][2043][11550][4.0.100] Exception java.net.SocketException:Error opening socket to server/10.105.4.55 on port 50,001 with Message:network is un Reachable. errorcode=-4499, sqlstate=08001
At org.apache.sqoop.mapreduce.db.DBInputFormat.setConf (dbinputformat.java:167)
At org.apache.hadoop.util.ReflectionUtils.setConf (reflectionutils.java:70)
At Org.apache.hadoop.util.ReflectionUtils.newInstance (reflectionutils.java:130)
At Org.apache.hadoop.mapred.MapTask.runNewMapper (maptask.java:636)
At Org.apache.hadoop.mapred.MapTask.run (maptask.java:331)
At Org.apache.hadoop.mapred.child$4.run (child.java:268)
At java.security.AccessController.doPrivileged (Native Method)
At Javax.security.auth.Subject.doAs (subject.java:415)
At Org.apache.hadoop.security.UserGroupInformation.doAs (usergroupinformation.java:1408)
At Org.apache.hadoop.mapred.Child.main (child.java:262)
caused by:java.lang.runtimeexception:com.ibm.db2.jcc.a.pm: [JCC
14/07/19 12:04:13 INFO mapred. Jobclient:task Id:attempt_201407151514_3011_m_000000_1, status:failed
JAVA.LANG.RUNTIMEEXCEPTION:JAVA.LANG.RUNTIMEEXCEPTION:COM.IBM.DB2.JCC.A.PM: [jcc][t4][2043][11550][4.0.100] Exception java.net.SocketException:Error opening socket to server/10.105.4.55 on port 50,001 with Message:network is un Reachable. errorcode=-4499, sqlstate=08001
At org.apache.sqoop.mapreduce.db.DBInputFormat.setConf (dbinputformat.java:167)
At org.apache.hadoop.util.ReflectionUtils.setConf (reflectionutils.java:70)
At Org.apache.hadoop.util.ReflectionUtils.newInstance (reflectionutils.java:130)
At Org.apache.hadoop.mapred.MapTask.runNewMapper (maptask.java:636)
At Org.apache.hadoop.mapred.MapTask.run (maptask.java:331)
At Org.apache.hadoop.mapred.child$4.run (child.java:268)
At java.security.AccessController.doPrivileged (Native Method)
At Javax.security.auth.Subject.doAs (subject.java:415)
At Org.apache.hadoop.security.UserGroupInformation.doAs (usergroupinformation.java:1408)
At Org.apache.hadoop.mapred.Child.main (child.java:262)
caused by:java.lang.runtimeexception:com.ibm.db2.jcc.a.pm: [JCC
14/07/19 12:04:22 INFO mapred. Jobclient:task Id:attempt_201407151514_3011_m_000000_2, status:failed
JAVA.LANG.RUNTIMEEXCEPTION:JAVA.LANG.RUNTIMEEXCEPTION:COM.IBM.DB2.JCC.A.PM: [jcc][t4][2043][11550][4.0.100] Exception java.net.SocketException:Error opening socket to server/10.105.4.55 on port 50,001 with Message:network is un Reachable. errorcode=-4499, sqlstate=08001
At org.apache.sqoop.mapreduce.db.DBInputFormat.setConf (dbinputformat.java:167)
At org.apache.hadoop.util.ReflectionUtils.setConf (reflectionutils.java:70)
At Org.apache.hadoop.util.ReflectionUtils.newInstance (reflectionutils.java:130)
At Org.apache.hadoop.mapred.MapTask.runNewMapper (maptask.java:636)
At Org.apache.hadoop.mapred.MapTask.run (maptask.java:331)
At Org.apache.hadoop.mapred.child$4.run (child.java:268)
At java.security.AccessController.doPrivileged (Native Method)
At Javax.security.auth.Subject.doAs (subject.java:415)
At Org.apache.hadoop.security.UserGroupInformation.doAs (usergroupinformation.java:1408)
At Org.apache.hadoop.mapred.Child.main (child.java:262)
caused by:java.lang.runtimeexception:com.ibm.db2.jcc.a.pm: [JCC
14/07/19 12:04:33 INFO mapred. Jobclient:job complete:job_201407151514_3011
14/07/19 12:04:33 INFO mapred. Jobclient:counters:6
14/07/19 12:04:33 INFO mapred. Jobclient:job Counters
14/07/19 12:04:33 INFO mapred. jobclient:failed Map Tasks=1
14/07/19 12:04:33 INFO mapred. jobclient:launched Map tasks=4
14/07/19 12:04:33 INFO mapred. Jobclient:total time spent by all maps in occupied slots (ms) =34774
14/07/19 12:04:33 INFO mapred. Jobclient:total time spent by all reduces in occupied slots (ms) =0
14/07/19 12:04:33 INFO mapred. Jobclient:total time spent by all maps waiting after reserving slots (ms) =0
14/07/19 12:04:33 INFO mapred. Jobclient:total time spent by all reduces waiting after reserving slots (ms) =0
14/07/19 12:04:33 WARN MapReduce. Counters:group filesystemcounters is deprecated. Use Org.apache.hadoop.mapreduce.FileSystemCounter instead
14/07/19 12:04:33 INFO MapReduce. importjobbase:transferred 0 bytes in 42.7266 seconds (0 bytes/sec)
14/07/19 12:04:33 WARN MapReduce. Counters:group Org.apache.hadoop.mapred.task$counter is deprecated. Use Org.apache.hadoop.mapreduce.TaskCounter instead
14/07/19 12:04:33 INFO MapReduce. Importjobbase:retrieved 0 Records.
14/07/19 12:04:33 ERROR tool. Importtool:error during Import:import job failed!
Crmd3n:/d2_data0/user/ocdc/bin/sqoop-1.4.2-cdh4.2.1/bin>
has anyone ever met such a mistake? Novice on the road, please master advice!! 650) this.width=650; "src=" Http://img.baidu.com/hi/jx2/j_0069.gif "alt=" j_0069.gif "/>
Continue to study, the problem will be posted immediately.
Sqoop exporting data from DB2 error: errorcode=-4499, sqlstate=08001