Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.
jayasimhareddy9
New Contributor

SHELL Script error of working isung SQOOP command ...

by New Contributor in Support Questions
‎08-30-2018 10:36 AM
‎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:

Re: Exporting Data from hive to MSSQL(Windows Auth...

by New Contributor in Support Questions
‎08-27-2018 09:58 AM
‎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

Re: sqoop import from SQL Server with windows auth...

by New Contributor in Support Questions
‎08-27-2018 09:52 AM
‎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

Exporting Data from hive to MSSQL(Windows Auth) us...

by New Contributor in Support Questions
‎08-27-2018 09:42 AM
‎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:
Contact Me
Online
Offline
Last Visited
‎08-30-2018 10:32 AM
Public Statistics
Date Registered ‎08-27-2018 08:59 AM
Last Visited ‎08-30-2018 10:32 AM
Total Messages Posted 4