2011-02-15 16:52:21,246 WARN org.apache.hadoop.mapred.Child: Error running child java.io.IOException: SQLException in nextKeyValue at com.cloudera.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:238) at org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:448) at org.apache.hadoop.mapreduce.MapContext.nextKeyValue(MapContext.java:67) at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:143) at com.cloudera.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:187) at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:639) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:315) at org.apache.hadoop.mapred.Child$4.run(Child.java:217) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:396) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1063) at org.apache.hadoop.mapred.Child.main(Child.java:211) Caused by: com.ibm.db2.jcc.a.bn: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=.;FOR WITH FETCH ORDER UNION EXCEPT QUERYNO OPTIMIZE, DRIVER=3.51.90 at com.ibm.db2.jcc.a.wc.a(wc.java:592) at com.ibm.db2.jcc.a.wc.a(wc.java:60) at com.ibm.db2.jcc.a.wc.a(wc.java:127) at com.ibm.db2.jcc.a.fl.c(fl.java:1907) at com.ibm.db2.jcc.a.fl.d(fl.java:1895) at com.ibm.db2.jcc.a.fl.a(fl.java:1422) at com.ibm.db2.jcc.a.fl.a(fl.java:1400) at com.ibm.db2.jcc.t4.db.g(db.java:133) at com.ibm.db2.jcc.t4.db.a(db.java:38) at com.ibm.db2.jcc.t4.t.a(t.java:32) at com.ibm.db2.jcc.t4.sb.h(sb.java:141) at com.ibm.db2.jcc.a.fl.O(fl.java:1393) at com.ibm.db2.jcc.a.gl.Ob(gl.java:2471) at com.ibm.db2.jcc.a.gl.e(gl.java:3116) at com.ibm.db2.jcc.a.gl.Cb(gl.java:536) at com.ibm.db2.jcc.a.gl.executeQuery(gl.java:510) at com.cloudera.sqoop.mapreduce.db.DBRecordReader.executeQuery(DBRecordReader.java:100) at com.cloudera.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:225) ... 11 more