Hi Venky, OK, can you try the following then?
1) Since you can't checkout source code, please download the source tarball from one of sqoop mirror sites (http://www.apache.org/dyn/closer.cgi/sqoop/ ). For example: http://www.reverse.net/pub/apache/sqoop/1.4.1-incubating/sqoop-1.4.1-incubating-src.tar.gz 2) tar -xf sqoop-1.4.1-incubating-src.tar.gz 3) cd sqoop-1.4.1-incubating-src 4) wget https://issues.apache.org/jira/secure/attachment/12531120/SQOOP-480-2.patch 5) patch -p0 -i SQOOP-480.patch 6) ant jar-all 7) You will find "sqoop-test-1.4.2-incubating-SNAPSHOT.jar" in the "build" sub-directory. 8) Replace /usr/lib/sqoop/sqoop-1.4.1-cdh4.0.0.jar with sqoop-test-1.4.2-incubating-SNAPSHOT.jar. Thanks! Cheolsoo On Wed, Jul 4, 2012 at 11:02 PM, venkatesh warulu <[email protected]> wrote: > Hi Cheolsoo, > > Just I have installed Svn and tried to execute the steps mentioned in the > note , getting follwoing error > > svn co https://svn.apache.org/repos/asf/sqoop/trunk/ sqoop > svn: OPTIONS of 'https://svn.apache.org/repos/asf/sqoop/trunk': > could not connect to server (https://svn.apache.org/) > Also need to understand after the build , which file need to be replaced > > /usr/lib/sqoop/sqoop-* > -rw-r--r-- 1 root root 596185 Jun 4 17:45 > /usr/lib/sqoop/sqoop-1.4.1-cdh4.0.0.jar > -rw-r--r-- 1 root root 291898 Jun 4 17:45 > /usr/lib/sqoop/sqoop-test-1.4.1-cdh4.0.0.jar > > Regards > Venky > *From:* Cheolsoo Park <[email protected]> > *To:* venkatesh warulu <[email protected]> > *Cc:* "[email protected]" <[email protected]> > *Sent:* Thursday, July 5, 2012 1:46 PM > *Subject:* Re: OraOop > > Typo correction: > > Would you mind if I ask why you can't build Sqoop? > > > On Wed, Jul 4, 2012 at 10:43 PM, Cheolsoo Park <[email protected]>wrote: > > Hi Venky, > > Unfortunately, there is no compiled code that includes this fix at the > moment. We're going to release a new version of Sqoop soon, but you will > have to wait until then though. > > Would you mind asking why you can't build Sqoop? > > Thanks, > Cheolsoo > > On Wed, Jul 4, 2012 at 10:21 PM, venkatesh warulu <[email protected]>wrote: > > > Hi Cheolsoo > > Thank for all your valuable suppot ... > Ubfortunately I could not able to build , Is it any way possible to get > the compiled code , so that I can just deploy > > > Regards > Venky > > *From:* Cheolsoo Park <[email protected]> > *To:* venkatesh warulu <[email protected]> > *Cc:* "[email protected]" <[email protected]> > *Sent:* Thursday, July 5, 2012 1:09 PM > *Subject:* Re: OraOop > > Hi Venky, > > Sure. No problem. > > 1) Checkout the latest Sqoop source code that already includes SQOOP-480 > from the project repository and build. For details, please refer to the > following link: > > > https://cwiki.apache.org/confluence/display/SQOOP/Setting+up+Development+Environment > > 2) Replace the installed Sqoop jar with the one that you've just built. If > you installed Sqoop from rpm or deb, you can find the installed jar at > /usr/lib/sqoop/lib. > > Please let me know if you have any further questions. > > Thanks, > Cheolsoo > > On Wed, Jul 4, 2012 at 7:42 PM, venkatesh warulu <[email protected]>wrote: > > Hi , > > This is new area for me to explore ... Will you please provide me the > steps to apply the patch *SQOOP-480*. > > > > Regards > Venky > *From:* Cheolsoo Park <[email protected]> > *To:* [email protected] > *Cc:* [email protected] > *Sent:* Thursday, July 5, 2012 4:05 AM > *Subject:* Re: OraOop > > 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) > > > > > > > > > > > >
