According to google the error message means you have invalid characters in your sql....
When sql statements contain special characters, for example, line breaks, carriage returns, line feeds, receive the following error by using the Universal Driver: DB2 SQL error: SQLCODE: -7, SQLSTATE: 42601, SQLERRMC: This is a simple sample of such a SQL statement: static final String sqlQuery = "SELECT empno, firstnme, lastname, salary \n" + " FROM employee WHERE workdept='A00'"; On Wed, May 23, 2012 at 7:53 AM, sam liu <[email protected]> wrote: > Hi, > > I have an issue of importing a table from DB2 Luw 97 database using Sqoop. > Below is the logs. Could any one help me? Thanks in advance very much! > > > [root@localhost bin]# ./sqoop import --connect jdbc:db2://9.1111.146.111: > 50000/SAMPLE --table DB2ADMIN.DB2TEST_TBL003 --username sam --password > db2adminpassword -m 1 > Warning: /usr/lib/hbase does not exist! HBase imports will fail. > Please set $HBASE_HOME to the root of your HBase installation. > 12/05/22 23:35:56 WARN tool.BaseSqoopTool: Setting your password on the > command-line is insecure. Consider using -P instead. > 12/05/22 23:35:56 INFO manager.SqlManager: Using default fetchSize of 1000 > 12/05/22 23:35:56 INFO tool.CodeGenTool: Beginning code generation > 12/05/22 23:35:59 INFO manager.SqlManager: Executing SQL statement: SELECT > t.* FROM DB2ADMIN.DB2TEST_TBL003 AS t WHERE 1=0 > 12/05/22 23:35:59 INFO manager.SqlManager: Executing SQL statement: SELECT > t.* FROM DB2ADMIN.DB2TEST_TBL003 AS t WHERE 1=0 > 12/05/22 23:35:59 INFO orm.CompilationManager: HADOOP_HOME is > /opt/hadoop-0.20.2/bin/.. > 12/05/22 23:35:59 INFO orm.CompilationManager: Found hadoop core jar at: > /opt/hadoop-0.20.2/bin/../hadoop-0.20.2-core.jar > Note: > /tmp/sqoop-root/compile/56c3a2cc91c28bad8d66ca7b80e997d0/DB2ADMIN_DB2TEST_TBL003.java > uses or overrides a deprecated API. > Note: Recompile with -Xlint:deprecation for details. > 12/05/22 23:35:59 INFO orm.CompilationManager: Writing jar file: > /tmp/sqoop-root/compile/56c3a2cc91c28bad8d66ca7b80e997d0/DB2ADMIN.DB2TEST_TBL003.jar > 12/05/22 23:35:59 INFO mapreduce.ImportJobBase: Beginning import of > DB2ADMIN.DB2TEST_TBL003 > 12/05/22 23:36:55 INFO manager.SqlManager: Executing SQL statement: SELECT > t.* FROM DB2ADMIN.DB2TEST_TBL003 AS t WHERE 1=0 > 12/05/22 23:37:00 INFO mapred.JobClient: Running job: job_201205222335_0001 > 12/05/22 23:37:01 INFO mapred.JobClient: map 0% reduce 0% > 12/05/22 23:37:16 INFO mapred.JobClient: Task Id : > attempt_201205222335_0001_m_000000_0, Status : FAILED > java.io.IOException: SQLException in nextKeyValue > at > org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:265) > at > org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:423) > at > org.apache.hadoop.mapreduce.MapContext.nextKeyValue(MapContext.java:67) > at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:143) > at > org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:183) > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:621) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:305) > at org.apache.hadoop.mapred.Child.main(Child.java:170) > Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: > SQLCODE=-104, SQLSTATE=42601, SQLERRMC=.;T_TBL003 AS DB2ADMIN;,, > DRIVER=3.62.56 > at com.ibm.db2.jcc.am.fd.a(fd.java:676) > at com.ibm.db2.jcc.am.fd.a(fd.java:60) > at com.ibm.db2.jcc.am.fd.a(fd.java:127) > at com.ibm.db2.jcc.am.jn.c(jn.java:2614) > at com.ibm.db2.jcc.am.jn.d(jn.java:2602) > at com.ibm.db2.jcc.am.jn.a(jn.java:2094) > at com.ibm.db2.jcc.am.kn.a(kn.java:6720) > at com.ibm.db2.jcc.t4.cb.g(cb.java:141) > at com.ibm.db2.jcc.t4.cb.a(cb.java:41) > at com.ibm.db2.jcc.t4.q.a(q.java:32) > at com.ibm.db2.jcc.t4.rb.i(rb.java:135) > at com.ibm.db2.jcc.am.jn.gb(jn.java:2064) > at com.ibm.db2.jcc.am.kn.pc(kn.java:3214) > at com.ibm.db2.jcc.am.kn.b(kn.java:3999) > at com.ibm.db2.jcc.am.kn.cc(kn.java:709) > at com.ibm.db2.jcc.am.kn.executeQuery(kn.java:683) > at > org.apache.sqoop.mapreduce.db.DBRecordReader.executeQuery(DBRecordReader.java:111) > at > org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:236) > ... 7 more > > 12/05/22 23:37:22 INFO mapred.JobClient: Task Id : > attempt_201205222335_0001_m_000000_1, Status : FAILED > java.io.IOException: SQLException in nextKeyValue > at > org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:265) > at > org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:423) > at > org.apache.hadoop.mapreduce.MapContext.nextKeyValue(MapContext.java:67) > at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:143) > at > org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:183) > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:621) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:305) > at org.apache.hadoop.mapred.Child.main(Child.java:170) > Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: > SQLCODE=-104, SQLSTATE=42601, SQLERRMC=.;T_TBL003 AS DB2ADMIN;,, > DRIVER=3.62.56 > at com.ibm.db2.jcc.am.fd.a(fd.java:676) > at com.ibm.db2.jcc.am.fd.a(fd.java:60) > at com.ibm.db2.jcc.am.fd.a(fd.java:127) > at com.ibm.db2.jcc.am.jn.c(jn.java:2614) > at com.ibm.db2.jcc.am.jn.d(jn.java:2602) > at com.ibm.db2.jcc.am.jn.a(jn.java:2094) > at com.ibm.db2.jcc.am.kn.a(kn.java:6720) > at com.ibm.db2.jcc.t4.cb.g(cb.java:141) > at com.ibm.db2.jcc.t4.cb.a(cb.java:41) > at com.ibm.db2.jcc.t4.q.a(q.java:32) > at com.ibm.db2.jcc.t4.rb.i(rb.java:135) > at com.ibm.db2.jcc.am.jn.gb(jn.java:2064) > at com.ibm.db2.jcc.am.kn.pc(kn.java:3214) > at com.ibm.db2.jcc.am.kn.b(kn.java:3999) > at com.ibm.db2.jcc.am.kn.cc(kn.java:709) > at com.ibm.db2.jcc.am.kn.executeQuery(kn.java:683) > at > org.apache.sqoop.mapreduce.db.DBRecordReader.executeQuery(DBRecordReader.java:111) > at > org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:236) > ... 7 more > > 12/05/22 23:37:29 INFO mapred.JobClient: Task Id : > attempt_201205222335_0001_m_000000_2, Status : FAILED > java.io.IOException: SQLException in nextKeyValue > at > org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:265) > at > org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:423) > at > org.apache.hadoop.mapreduce.MapContext.nextKeyValue(MapContext.java:67) > at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:143) > at > org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:183) > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:621) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:305) > at org.apache.hadoop.mapred.Child.main(Child.java:170) > Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: > SQLCODE=-104, SQLSTATE=42601, SQLERRMC=.;T_TBL003 AS DB2ADMIN;,, > DRIVER=3.62.56 > at com.ibm.db2.jcc.am.fd.a(fd.java:676) > at com.ibm.db2.jcc.am.fd.a(fd.java:60) > at com.ibm.db2.jcc.am.fd.a(fd.java:127) > at com.ibm.db2.jcc.am.jn.c(jn.java:2614) > at com.ibm.db2.jcc.am.jn.d(jn.java:2602) > at com.ibm.db2.jcc.am.jn.a(jn.java:2094) > at com.ibm.db2.jcc.am.kn.a(kn.java:6720) > at com.ibm.db2.jcc.t4.cb.g(cb.java:141) > at com.ibm.db2.jcc.t4.cb.a(cb.java:41) > at com.ibm.db2.jcc.t4.q.a(q.java:32) > at com.ibm.db2.jcc.t4.rb.i(rb.java:135) > at com.ibm.db2.jcc.am.jn.gb(jn.java:2064) > at com.ibm.db2.jcc.am.kn.pc(kn.java:3214) > at com.ibm.db2.jcc.am.kn.b(kn.java:3999) > at com.ibm.db2.jcc.am.kn.cc(kn.java:709) > at com.ibm.db2.jcc.am.kn.executeQuery(kn.java:683) > at > org.apache.sqoop.mapreduce.db.DBRecordReader.executeQuery(DBRecordReader.java:111) > at > org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:236) > ... 7 more > > 12/05/22 23:37:38 INFO mapred.JobClient: Job complete: > job_201205222335_0001 > 12/05/22 23:37:38 INFO mapred.JobClient: Counters: 2 > 12/05/22 23:37:38 INFO mapred.JobClient: Job Counters > 12/05/22 23:37:38 INFO mapred.JobClient: Launched map tasks=4 > 12/05/22 23:37:38 INFO mapred.JobClient: Failed map tasks=1 > 12/05/22 23:37:38 INFO mapreduce.ImportJobBase: Transferred 0 bytes in > 43.7817 seconds (0 bytes/sec) > 12/05/22 23:37:39 INFO mapreduce.ImportJobBase: Retrieved 0 records. > 12/05/22 23:37:39 ERROR tool.ImportTool: Error during import: Import job > failed! > [root@localhost bin]# > > > > > Regards, > > Sam Liu >
