Typo correction: sqoop-*test*-1.4.2-incubating-SNAPSHOT.jar => sqoop-1.4.2-incubating-SNAPSHOT.jar
The "test" jar is for unit test. On Wed, Jul 4, 2012 at 11:24 PM, Cheolsoo Park <[email protected]>wrote: > 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) >> >> >> >> >> >> >> >> >> >> >> >> >
