https://community.cloudera.com/t5/Support-Questions/changing-temp-directory-in-sqoop-import/m-p/281984#M209696 <P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/70827">@sow</a>&nbsp;</P><P>Have you tried changing your&nbsp;<SPAN>&nbsp;<STRONG>--target-dir /user/database/test/ --m 1</STRONG></SPAN></P><P><SPAN>$ sqoop import -D yarn.app.mapreduce.am.staging-dir=/user/test/ --driver "com.microsoft.sqlserver.jdbc.SQLServerDriver" --connect "jdbc:sqlserver://ip:port;database=database;" --connection-manager "org.apache.sqoop.manager.SQLServerManager" --username &lt;username&gt; -password &lt;password&gt; --table 'tablename' --as-parquetfile --delete-target-dir<FONT color="#FF0000"> <STRONG>--target-dir /user/test/ --m 1</STRONG></FONT></SPAN></P><P>&nbsp;</P><P>While running hive import <STRONG>target-dir</STRONG> argument value controls where the data needs to store temporarily before loading into Hive table, but <STRONG>target-dir</STRONG> doesn't create hive table in that location.</P><P>If you want to import to specific directory then use <STRONG>target-dir</STRONG> without hive-import argument and create hive table on top of HDFS directory.</P><P><SPAN><FONT color="#FF0000"><STRONG><BR /><FONT color="#000000">HTH</FONT></STRONG></FONT></SPAN></P> Mon, 04 Nov 2019 15:27:36 GMT Shelton 2019-11-04T15:27:36Z