HI @Sindhu , i'm trying to export from hive to MS-SQL(Windows Auth), can you suggest me a solution for this. ... View more

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