Member since
12-04-2014
2
Posts
1
Kudos Received
0
Solutions
12-12-2014
07:25 AM
Thank You Abe.. I have placed the SQLJDBC4.jar driver in the /var/lib/sqoop/ as well as /var/lib/sqoop2/ folder. Am using the query to import top 10 rows from a dumy table and it works great. sqoop import --connect "jdbc:sqlserver://myserver;database=MyDB" --username me --password pwd --driver com.microsoft.sqlserver.jdbc.SQLServerDriver --query 'select top 10 ACODE from [dbo].[ACNT] WHERE $CONDITIONS' -m 1 --target-dir /tmp/test_sqoop/ I still get the WARNING Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail. Please set $ACCUMULO_HOME to the root of your Accumulo installation. I know its only a warning, I just wanna make sure I dont have to install APACHE ACCUMULO to fix this ? Thanks! Nithin
... View more
12-04-2014
07:27 AM
1 Kudo
I have been trying to import SQL Server Data using a Hue Data Connector.. On the web page: http://www.cloudera.com/content/cloudera/en/documentation/cdh4/latest/CDH4-Installation-Guide/cdh4ig_topic_13_7.html they asked me to install the JDBC 4 driver for SQL Server and after running the following commands on the terminal, I could install the JDBC 4 SQL Server Driver. Now when I am trying to execute the following command sqoop import --connect jdbc:sql://myserver --username Me --table Mytable I get the following error. Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail. Please set $ACCUMULO_HOME to the root of your Accumulo installation. 14/12/04 10:15:58 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5-cdh5.2.0 14/12/04 10:15:59 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/12/04 10:15:59 INFO manager.SqlManager: Using default fetchSize of 1000 14/12/04 10:15:59 INFO tool.CodeGenTool: Beginning code generation 14/12/04 10:16:00 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: Could not load db driver class: com.microsoft.jdbc.sqlserver.SQLServerDrive java.lang.RuntimeException: Could not load db driver class: com.microsoft.jdbc.sqlserver.SQLServerDrive at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:848) at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52) at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:736) at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:759) at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:269) at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:240) at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:226) at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:295) at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1829) at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1641) at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:478) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605) at org.apache.sqoop.Sqoop.run(Sqoop.java:143) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227) at org.apache.sqoop.Sqoop.main(Sqoop.java:236) Is it smething to do with the way I have set up the VM ? How do I set the $ACCUMULO_HOME to the root of your Accumulo installation ? Thank You in Advance!
... View more
Labels: