To be clear, SQOOP-480 applies to OraOop as well as MS connector. (I encountered both myself.) I have a comment in the JIRA saying this also occurs in OraOop although it might not be very visible.
Hope that nobody misunderstands. Thanks, Cheolsoo On Wed, Jul 4, 2012 at 1:05 PM, Cheolsoo Park <[email protected]> wrote: > Hi Venky, > > Exception in thread "main" >> java.lang.NoSuchMethodError: >> com.cloudera.sqoop.manager.ImportJobContext.setConnManager(Lcom/cloudera/sqoop/manager/ConnManager;)V > > > This is fixed in the upstream trunk. Please see SQOOP-480: > https://issues.apache.org/jira/browse/SQOOP-480. Unfortunately, there is > no official Sqoop release that include this fix, so you will have to apply > the patch and rebuild Sqoop. > > Thanks, > Cheolsoo > > > > On Wed, Jul 4, 2012 at 12:13 PM, Kathleen Ting <[email protected]>wrote: > >> Dear Venky, >> >> For faster resolution of Sqoop support issues, please subscribe to the >> Sqoop User mailing list by emailing: [email protected] >> >> Regarding your issue below, it could be that your version of Hadoop is >> not compatible with OraOop - what is your Hadoop version? >> >> Regards, Kathleen >> >> sqoop import --connect >> jdbc:oracle:thin:@lyisdb01.dev.sgp.avagotech.net:1523:OPTCH --username >> system --password clone --table VENK -verbose >> 12/07/04 05:39:14 WARN tool.BaseSqoopTool: Setting your password on >> the command-line is insecure. Consider using -P instead. >> 12/07/04 05:39:14 DEBUG oraoop.OraOopUtilities: Enabled OraOop debug >> logging. >> 12/07/04 05:39:14 DEBUG oraoop.OraOopManagerFactory: Quest® Data >> Connector for Oracle and Hadoop can be called by Sqoop! >> 12/07/04 05:39:14 INFO manager.SqlManager: Using default fetchSize of 1000 >> 12/07/04 05:39:15 DEBUG oraoop.OraOopUtilities: The Oracle table >> context has been derived from: >> oracleConnectionUserName = system >> tableStr = VENK >> as: >> owner : SYSTEM >> table : VENK >> 12/07/04 05:39:15 INFO oraoop.OraOopManagerFactory: >> *************************************************************** >> *** Using Quest® Data Connector for Oracle and Hadoop 1.5.0 *** >> *** Copyright 2012 Quest Software, Inc. *** >> *** ALL RIGHTS RESERVED. *** >> *************************************************************** >> 12/07/04 05:39:15 INFO oraoop.OraOopManagerFactory: Oracle Database >> version: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - >> 64bit Production >> 12/07/04 05:39:15 INFO oraoop.OraOopManagerFactory: This Oracle >> database is not a RAC. >> 12/07/04 05:39:15 WARN conf.Configuration: mapred.map.max.attempts is >> deprecated. Instead, use mapreduce.map.maxattempts >> 12/07/04 05:39:15 INFO tool.CodeGenTool: Beginning code generation >> 12/07/04 05:39:15 DEBUG oraoop.OraOopOracleQueries: getTableColumns() : >> sql = >> SELECT column_name, data_type FROM dba_tab_columns WHERE owner = ? >> and table_name = ? and (DATA_TYPE IN >> >> ('BINARY_DOUBLE','BINARY_FLOAT','BLOB','CHAR','CLOB','DATE','FLOAT','LONG','NCHAR','NCLOB','NUMBER','NVARCHAR2','RAW','ROWID','URITYPE','VARCHAR2') >> OR DATA_TYPE LIKE 'INTERVAL YEAR(%) TO MONTH' OR DATA_TYPE LIKE >> 'INTERVAL DAY(%) TO SECOND(%)' OR DATA_TYPE LIKE 'TIMESTAMP(%)' OR >> DATA_TYPE LIKE 'TIMESTAMP(%) WITH TIME ZONE' OR DATA_TYPE LIKE >> 'TIMESTAMP(%) WITH LOCAL TIME ZONE') ORDER BY column_id >> 12/07/04 05:39:15 INFO manager.SqlManager: Executing SQL statement: >> SELECT "A","B" FROM VENK WHERE 0=1 >> 12/07/04 05:39:15 INFO manager.SqlManager: Executing SQL statement: >> SELECT A,B FROM VENK WHERE 1=0 >> 12/07/04 05:39:15 INFO orm.CompilationManager: HADOOP_HOME is >> /usr/lib/hadoop >> Note: /tmp/sqoop-root/compile/8817da7c72ed005d42065edefc806224/VENK.java >> uses or overrides a deprecated API. >> Note: Recompile with -Xlint:deprecation for details. >> 12/07/04 05:39:18 INFO orm.CompilationManager: Writing jar file: >> /tmp/sqoop-root/compile/8817da7c72ed005d42065edefc806224/VENK.jar >> 12/07/04 05:39:18 DEBUG oraoop.OraOopConnManager: The output directory >> for the sqoop table import is : VENK >> Exception in thread "main" java.lang.NoSuchMethodError: >> >> com.cloudera.sqoop.manager.ImportJobContext.setConnManager(Lcom/cloudera/sqoop/manager/ConnManager;)V >> at >> com.quest.oraoop.OraOopConnManager.importTable(OraOopConnManager.java:248) >> at >> org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:403) >> 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:70) >> 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) >> at org.apache.sqoop.Sqoop.main(Sqoop.java:238) >> at com.cloudera.sqoop.Sqoop.main(Sqoop.java:57) >> > >
