hadoop-mapreduce-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From R J <rj201...@yahoo.com>
Subject Question about sqoop command error
Date Mon, 28 Jul 2014 01:35:44 GMT
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
Mime
View raw message