https://community.cloudera.com/t5/Support-Questions/Exporting-Data-from-hive-to-MSSQL-Windows-Auth-using-sqoop/m-p/227299#M189159 <A rel="user" href="https://community.cloudera.com/users/91459/jayasimhareddy992.html" nodeid="91459">@Jai C </A><P>The error is not related to the Windows authentication, but is because of the Hive/Hcatalog table being a bucketed table which is not supported from Sqoop export. You can verify the same by running command from Hive Cli / Beeline:<BR /></P><PRE>show create table &lt;database&gt;.&lt;table&gt;;</PRE><P>The table definition would be like, keyword being '<EM>clustered by':</EM><BR /></P><PRE>hive&gt; show create table default.test_bucket; OK CREATE TABLE `default.test_bucket`( `col1` int, `col2` string) CLUSTERED BY ( col1) INTO 3 BUCKETS ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.orc.OrcSerde' STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat' LOCATION 'hdfs://xxx.com:8020/apps/hive/warehouse/test_bucket' TBLPROPERTIES ( 'numFiles'='13', 'numRows'='0', 'rawDataSize'='0', 'totalSize'='8883', 'transactional'='true', 'transient_lastDdlTime'='1505206092') Time taken: 0.786 seconds, Fetched: 21 row(s)</PRE> Mon, 27 Aug 2018 17:26:19 GMT ssubhas 2018-08-27T17:26:19Z