@Justin MillerI too faced the same problem, finally i resolved the issue with the below mention procedure,it may help you i hope. Sqoop SQL Server data import to
HDFS worked with manual parametric the authentication(using windows credential) with added parameter on the SQL
Server JDBC driver, as integrated security is not supported by the SQL driver
as of now due to the Kerberos authentication(Delegated tokens distributed over cluster while running MR job). So we need to pass the windows
authentication with password and with the integrated security disabled mode to
import the data to the system. As normal SQL server
driver does not support, so I had used the jtds.jar
and the different driver class to pull the data to the Hadoop Lake. Sample Command I tried on the
server as follows, sqoop import --table Table1 --connect
"jdbc:jtds:sqlserver://<Hostname>:<Port>;useNTLMv2=true;domain=<WindowsDomainName>;databaseName=XXXXXXXXXXXXX"
\ --connection-manager
org.apache.sqoop.manager.SQLServerManager --driver
net.sourceforge.jtds.jdbc.Driver --username XXXXX --password 'XXXXXXX' \ --verbose --target-dir
/tmp/33 -m 1 -- --schema dbo
... View more
