Member since
08-27-2018
4
Posts
0
Kudos Received
0
Solutions
08-30-2018
10:36 AM
Hello everyone, i have a sqoop command which exports data from Hive to MSSQL(Windows authontication) and it is working fine, but when i'm trying to run same command from Shell Script it is giving below error , ERROR: 18/08/30 06:32:04 DEBUG manager.SqlManager: No connection paramenters specified. Using regular API for making connection.
18/08/30 06:32:05 ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
java.sql.SQLException: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. Can some one please help me on this
... View more
Labels:
08-27-2018
09:58 AM
HI @Sindhu , i'm trying to export from hive to MS-SQL(Windows Auth), can you suggest me a solution for this.
... View more
08-27-2018
09:52 AM
Hi @Sindhu , @Praveen Singh Can you help on below issue,
I'm trying to export data into MSSQL Server Windows authentication from hive , i placed JTDS Drivers in Sqoop library, below is my sqoop command, sqoop export --connect "jdbc:jtds:sqlserver://<Servername>:1433;useNTLMv2=true;domain=<Domain Name>;databaseName=<DataBase name>" --table "<TableName>" --hcatalog-database <HIVE DB> --hcatalog-table <HIVE Table> --connection-manager org.apache.sqoop.manager.SQLServerManager --driver net.sourceforge.jtds.jdbc.Driver --username <SQL UserName> --password '<SQL Password>' --update-mode allowinsert --verbose
i'm getting the below error: 18/08/27 05:40:33 ERROR tool.ExportTool: Encountered IOException running export job: org.apache.hive.hcatalog.common.HCatException : 2016 : Error operation not supported : Store into a partition with bucket definition from Pig/Mapreduce is not supported Thanks in advance.
... View more
08-27-2018
09:42 AM
HI Team, I'm trying to export data into MSSQL Server Windows authentication from hive , i placed JTDS Drivers in Sqoop library, Can someone please help me on this. Many Thanks in advance!
... View more
Labels: