As a work around if you compile OraOop against Sqoop 1.4 it should work. I could compile it for you if you like - which version of Hadoop are you using as there is a few different Sqoop versions compiled against the different Hadoop versions?
From: Cheolsoo Park [mailto:[email protected]] Sent: Thursday, 5 July 2012 6:21 AM To: [email protected] Cc: [email protected] Subject: Re: OraOop 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]<mailto:[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]<mailto:[email protected]>> wrote: Dear Venky, For faster resolution of Sqoop support issues, please subscribe to the Sqoop User mailing list by emailing: [email protected]<mailto:[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)
