ambari-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joshi Omkar <>
Subject Import SQL Server table via Sqoop
Date Fri, 05 Jun 2015 14:35:52 GMT

I have HDP- running with Sqoop

>From the Hortonworks Sqoop doc<>.,
I reached the Microsoft doc<>.
which says that 'The Microsoft SQL Server SQOOP Connector for Hadoop is now part of Apache
SQOOP 1.4 and we are not providing a separate download anymore.'

When I execute the sqoop import :

sqoop import --connect jdbc:sqlserver://SESOCO1945/BigPUS2MONEY -- tb1 Stops --username somename

(OR even sqoop import --driver --connect jdbc:sqlserver://SESOCO1945/BigPUS2MONEY
--table tb1 --direct --username somename -P

I get :

Warning: /usr/hdp/ does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
15/06/05 16:16:25 INFO sqoop.Sqoop: Running Sqoop version:
Enter password:
15/06/05 16:16:33 INFO manager.SqlManager: Using default fetchSize of 1000
15/06/05 16:16:33 INFO tool.CodeGenTool: Beginning code generation
15/06/05 16:16:33 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException:
Could not load db driver class:
java.lang.RuntimeException: Could not load db driver class:
        at org.apache.sqoop.manager.SqlManager.makeConnection(
        at org.apache.sqoop.manager.GenericJdbcManager.getConnection(
        at org.apache.sqoop.manager.SqlManager.execute(
        at org.apache.sqoop.manager.SqlManager.execute(
        at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(
        at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(
        at org.apache.sqoop.manager.SqlManager.getColumnTypes(
        at org.apache.sqoop.manager.ConnManager.getColumnTypes(
        at org.apache.sqoop.orm.ClassWriter.getColumnTypes(
        at org.apache.sqoop.orm.ClassWriter.generate(
        at org.apache.sqoop.tool.CodeGenTool.generateORM(
        at org.apache.sqoop.tool.ImportTool.importTable(
        at org.apache.sqoop.Sqoop.runSqoop(
        at org.apache.sqoop.Sqoop.runTool(
        at org.apache.sqoop.Sqoop.runTool(
        at org.apache.sqoop.Sqoop.main(

Am I missing any parameters to sqoop import or do I need to install the driver ?

Omkar Joshi

View raw message