Hi, I have a test cluster that runs RHEL6. I installed Cloudera Manager 4 (which includes CDH4). I had installed SQOOP.
# sqoop version Sqoop 1.4.1-cdh4.0.0 git commit id 44ef1bef07d93e3fcf79bdc1150de6c278ad7845 Compiled by jenkins on Mon Jun 4 17:43:14 PDT 2012 After all the installation configuration and stuff I ran into the problem on not been able to sqoop import. I figured out that there is a bug for MS SQL Connector for SQL Server 2008 R2 (https://issues.apache.org/jira/browse/SQOOP-480). So I checkout the code 'svn co https://svn.apache.org/repos/asf/sqoop/trunk/ sqoop' And I build a project by executing ant. I got as a result (inside the build folder) 2 jar files sqoop-1.4.2-incubating-SNAPSHOT.jar sqoop-test-1.4.2-incubating-SNAPSHOT.jar After all this I used this files for replacing the files in the instance with the sqoop installation. So I removed the jar files in /usr/lib/sqoop/ (sqoop-1.4.1-cdh4.0.0.jar and sqoop-test-1.4.1-cdh4.0.0.jar) replacing them with the files above. After that I get # sqoop version Sqoop 1.4.2-incubating-SNAPSHOT git commit id Compiled by victor.sanchez on Wed Jun 27 10:33:01 EDT 2012 But when I tried to run the list-tables ... it fails like this: # sqoop list-tables --connect 'jdbc:sqlserver://hadooptest01;username=victor;password=victor;database=hadoopDB_SQL' 12/06/27 16:18:29 ERROR tool.BaseSqoopTool: Got error creating database manager: java.lang.StringIndexOutOfBoundsException: String index out of range: -1 at java.lang.String.substring(String.java:1937) at org.apache.sqoop.ConnFactory.addManagersFromFile(ConnFactory.java:152) at org.apache.sqoop.ConnFactory.loadManagersFromConfDir(ConnFactory.java:224) at org.apache.sqoop.ConnFactory.instantiateFactories(ConnFactory.java:83) at org.apache.sqoop.ConnFactory.<init>(ConnFactory.java:60) at com.cloudera.sqoop.ConnFactory.<init>(ConnFactory.java:36) at org.apache.sqoop.tool.BaseSqoopTool.init(BaseSqoopTool.java:200) at org.apache.sqoop.tool.ListTablesTool.run(ListTablesTool.java:44) 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) Notice if I put back the "old" jar files sqoop list-tables works, but of course the incompatibility bug (https://issues.apache.org/jira/browse/SQOOP-480) is still there. If anyone has an idea of how to update my current sqoop installation with my manual build I will appreciate any tip. Thanks in advance! /Victor Victor Sanchez Database Architect Net Entertainment NE AB, Luntmakargatan 18, SE-111 37, Stockholm, SE T: , M: 076 000 7297, F: +46 8 578 545 10 [email protected] www.netent.com Better Games This email and the information it contains are confidential and may be legally privileged and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify me immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. You should not copy it for any purpose, or disclose its contents to any other person. Internet communications are not secure and, therefore, Net Entertainment does not accept legal responsibility for the contents of this message as it has been transmitted over a public network. If you suspect the message may have been intercepted or amended please call me. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. Thank you.
