sqoop 报错：Could not load db driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver

一、问题描述

将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包，下载路径

https://docs.microsoft.com/zh-cn/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-2017

或者从maven仓库下载对应版本，以mssql-jdbc-6.1.0.jre8.jar为例

2.放到cdh的sqoop的lib目录下

/opt/cloudera/parcels/CDH/lib/sqoop/lib