Hi Gordon, Thank you for the reply. I downloaded the jdbc driver from http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html . I downloaded the file ojdbc6.jar and put it in the directory /home/catfish/scoop/sqoop-1.4.4.bin__hadoop-0.20/bin/ $cd /home/catfish/scoop/sqoop-1.4.4.bin__hadoop-0.20/bin/ $ls ojdbc6.jar ojdbc6.jar $sqoop import --driver oracle.jdbc.driver.OracleDriver --connect jdbc:oracle:thin:@server123.mycot.com:1521/instance1 --username scott --password tiger --table tab1
I still get the same error: Warning: /usr/lib/hcatalog does not exist! HCatalog jobs will fail. Please set $HCAT_HOME to the root of your HCatalog installation. 14/07/28 05:08:20 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead. 14/07/28 05:08:20 WARN sqoop.ConnFactory: Parameter --driver is set to an explicit driver however appropriate connection manager is not being set (via --connection-manager). Sqoop is going to fall back to org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which connection manager should be used next time. 14/07/28 05:08:20 INFO manager.SqlManager: Using default fetchSize of 1000 14/07/28 05:08:20 INFO tool.CodeGenTool: Beginning code generation 14/07/28 05:08:20 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: Could not load db driver class: oracle.jdbc.driver.OracleDriver java.lang.RuntimeException: Could not load db driver class: oracle.jdbc.driver.OracleDriver at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:772) at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52) at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:660) at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:683) at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:240) at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:223) at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:347) at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1277) at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1089) at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:396) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:502) at org.apache.sqoop.Sqoop.run(Sqoop.java:145) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) 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) On Sunday, July 27, 2014 8:49 PM, Gordon Wang <gw...@pivotal.io> wrote: You did not download Oracle JDBC driver jar. Please download the JDBC driver from the vendor site. and follow this page http://sqoop.apache.org/docs/1.4.4/SqoopUserGuide.html#_connecting_to_a_database_server to make sqoop work. On Mon, Jul 28, 2014 at 9:35 AM, R J <rj201...@yahoo.com> wrote: Hi All, > > >I installed sqoop and wanted to try the sqoop command on my linux server where >I have Hadoop environment running. > > >I unzipped the scoop executable at: >/home/catfish/scoop/sqoop-1.4.4.bin__hadoop-0.20/bin/ > > >$sqoop import --driver oracle.jdbc.driver.OracleDriver --connect >jdbc:oracle:thin:@server123.mycot.com:1521/instance1 --username scott >--password tiger --table tab1 >I get the following errors: >Warning: /usr/lib/hcatalog does not exist! HCatalog jobs will fail. >Please set $HCAT_HOME to the root of your HCatalog installation. >14/07/28 01:31:26 WARN tool.BaseSqoopTool: Setting your password on the >command-line is insecure. Consider using -P instead. >14/07/28 01:31:26 WARN sqoop.ConnFactory: Parameter --driver is set to an >explicit driver however appropriate connection manager is not being set (via >--connection-manager). Sqoop is going to fall back to >org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which >connection manager should be used next time. >14/07/28 01:31:26 INFO manager.SqlManager: Using default fetchSize of 1000 >14/07/28 01:31:26 INFO tool.CodeGenTool: Beginning code generation >14/07/28 01:31:26 ERROR sqoop.Sqoop: Got exception running Sqoop: >java.lang.RuntimeException: Could not load db driver class: >oracle.jdbc.driver.OracleDriver >java.lang.RuntimeException: Could not load db driver class: >oracle.jdbc.driver.OracleDriver > at >org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:772) > at >org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52) > at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:660) > at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:683) > at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:240) > at >org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:223) > at >org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:347) > at >org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1277) > at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1089) > at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96) > at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:396) > at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:502) > at org.apache.sqoop.Sqoop.run(Sqoop.java:145) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) > 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) > > > >Could you please suggest how I could make the sqoop command work? Thanks a lot. > > >Shu > > -- RegardsGordon Wang
