一、问题描述
将sql server的数据导入hive,结果报错:
Warning: /opt/cloudera/parcels/CDH-5.15.2-1.cdh5.15.2.p0.3/bin/../lib/sqoop/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
19/05/06 09:34:03 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.15.2
19/05/06 09:34:03 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
19/05/06 09:34:03 INFO manager.SqlManager: Using default fetchSize of 1000
19/05/06 09:34:03 INFO tool.CodeGenTool: Beginning code generation
19/05/06 09:34:03 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: Could not load db driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver
java.lang.RuntimeException: Could not load db driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver
二、问题原因
缺少驱动jar包mssql-jdbc.jar
三、解决
1.下载连接sql server的jar包,下载路径
或者从maven仓库下载对应版本,以mssql-jdbc-6.1.0.jre8.jar为例
2.放到cdh的sqoop的lib目录下
/opt/cloudera/parcels/CDH/lib/sqoop/lib