ranger-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Colm O hEigeartaigh (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (RANGER-1142) Sqoop import error
Date Thu, 02 Nov 2017 17:29:00 GMT

     [ https://issues.apache.org/jira/browse/RANGER-1142?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Colm O hEigeartaigh resolved RANGER-1142.
-----------------------------------------
    Resolution: Not A Problem

Did you mean to file this JIRA at the Sqoop project?

> Sqoop import error
> ------------------
>
>                 Key: RANGER-1142
>                 URL: https://issues.apache.org/jira/browse/RANGER-1142
>             Project: Ranger
>          Issue Type: Improvement
>            Reporter: anusha
>            Priority: Major
>
> Trying to import data in Sqoop from MS SQL Server database which has Windows Authentication.

> Trying to run the following command on the hive command prompt. 
> sqoop import --driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" --connect="jdbc:microsoft:sqlserver://**.**.**.**
:1433/DB_Schema;Integrated Security=TRUE" 
>  --table dbo.TABLE_NAME
> Error Received : 
> Error 1:
> --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.
> Error 2 : 
> Got exception running Sqoop: java.lang.RuntimeException: Could not load db driver class:
com.microsoft.jdbc.sqlserver.SQLServerDriver
> java.lang.RuntimeException: Could not load db driver class: com.microsoft.jdbc.sqlserver.SQLServerDriver
> Could some one guide me . 
> versions : 
> Sqoop 1.4.6
>      



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message