Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop >> mail # user >> Should not show NPE exception when occurs import failure


+
sam liu 2013-06-27, 06:57
+
Jarek Jarcec Cecho 2013-06-29, 21:46
Copy link to this message
-
Re: Should not show NPE exception when occurs import failure
Hi Jarek,

I have opened a JIRA: https://issues.apache.org/jira/browse/SQOOP-1117, and
attached a patch for it. Could you please help take a view at this patch?

Hoep it works. Thanks!
2013/6/30 Jarek Jarcec Cecho <[EMAIL PROTECTED]>

> Hi Sam,
> thank you very much for sharing this concern with us. Would you mind
> opening a new JIRA for this?
>
> https://issues.apache.org/jira/browse/SQOOP
>
> Jarcec
>
> On Thu, Jun 27, 2013 at 02:57:49PM +0800, sam liu wrote:
> > Hi,
> >
> > when failed to import a non-existing table, the returned failure
> > information includes java.lang.NullPointerException and other exceptions
> > which customer does not care about. These exception might confuse
> > customers, and we only need to return them 'ERROR manager.SqlManager:
> Error
> > executing statement: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL
> > Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2ADMIN.DB2TEST_TBL1001,
> > DRIVER=4.12.55' in this case. Can we make any improvement?
> >
> >
> > a) command:
> > sqoop import --connect jdbc:db2://hostname:50000/SAMPLE --table
> > DB2ADMIN.DB2TEST_TBL1001 --username sam --password pwd -m 1 --target-dir
> > /tmp/DB2TEST_TBL001_0620_f
> >
> > b) result:
> > 13/06/26 22:39:50 WARN tool.BaseSqoopTool: Setting your password on the
> > command-line is insecure. Consider using -P instead.
> > 13/06/26 22:39:50 INFO manager.SqlManager: Using default fetchSize of
> 1000
> > 13/06/26 22:39:50 INFO tool.CodeGenTool: Beginning code generation
> > 13/06/26 22:39:53 INFO manager.SqlManager: Executing SQL statement:
> SELECT
> > t.* FROM DB2ADMIN.DB2TEST_TBL1001 AS t WHERE 1=0
> > 13/06/26 22:39:53 ERROR manager.SqlManager: Error executing statement:
> > com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204,
> > SQLSTATE=42704, SQLERRMC=DB2ADMIN.DB2TEST_TBL1001, DRIVER=4.12.55
> > com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204,
> > SQLSTATE=42704, SQLERRMC=DB2ADMIN.DB2TEST_TBL1001, DRIVER=4.12.55
> >         at com.ibm.db2.jcc.am.hd.a(hd.java:676)
> >         at com.ibm.db2.jcc.am.hd.a(hd.java:60)
> >         at com.ibm.db2.jcc.am.hd.a(hd.java:127)
> >         at com.ibm.db2.jcc.am.mn.c(mn.java:2621)
> >         at com.ibm.db2.jcc.am.mn.d(mn.java:2609)
> >         at com.ibm.db2.jcc.am.mn.a(mn.java:2085)
> >         at com.ibm.db2.jcc.am.nn.a(nn.java:7054)
> >         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.mn.ib(mn.java:2055)
> >         at com.ibm.db2.jcc.am.nn.rc(nn.java:3219)
> >         at com.ibm.db2.jcc.am.nn.b(nn.java:4002)
> >         at com.ibm.db2.jcc.am.nn.ec(nn.java:728)
> >         at com.ibm.db2.jcc.am.nn.executeQuery(nn.java:698)
> >         at
> org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:539)
> >         at
> org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:548)
> >         at
> >
> org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:191)
> >         at
> > org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:175)
> >         at
> > org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:262)
> >         at
> > org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1235)
> >         at
> org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1060)
> >         at
> > org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
> >         at
> org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:390)
> >         at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476)
> >         at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
> >         at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
> >         at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
> >         at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
> >         at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
Sam Liu
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB