https://community.cloudera.com/t5/Support-Questions/changing-temp-directory-in-sqoop-import/m-p/282613#M210095 <P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/21488">@Khanna</a>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><STRONG><U>command used :</U></STRONG><BR />sqoop import --driver "com.microsoft.sqlserver.jdbc.SQLServerDriver" --connect "jdbc:sqlserver://server:port;database=db_name;" --connection-manager "org.apache.sqoop.manager.SQLServerManager" --username &lt;&gt; -password &lt;&gt; --table 'table_name' --as-parquetfile --delete-target-dir --target-dir /user/test/axe/ --temporary-rootdir /user/test2/ --m 4 --split-by user_id</P><P>&nbsp;</P><P><U><STRONG>before mapreduce starts:</STRONG></U><BR />hadoop fs -ls -R /user/test/<BR />/user/test/axe<BR />/user/test/axe/.metadata<BR />/user/test/axe/.metadata/descriptor.properties<BR />/user/test/axe/.metadata/schema.avsc<BR />/user/test/axe/.metadata/schemas<BR />/user/test/axe/.metadata/schemas/1.avsc</P><P>&nbsp;</P><P><U><STRONG>when the mapreduce job starts:</STRONG></U><BR />hadoop fs -ls -R /user/test/<BR />/user/test/<FONT color="#FF0000">.temp</FONT><BR />/user/test/.<FONT color="#FF0000">temp</FONT>/job_1571067970221_0156<BR />/user/test/.<FONT color="#FF0000">temp</FONT>/job_1571067970221_0156/mr<BR />/user/test/.<FONT color="#FF0000">temp</FONT>/job_1571067970221_0156/mr/job_1571067970221_0156<BR />/user/test/.<FONT color="#FF0000">temp</FONT>/job_1571067970221_0156/mr/job_1571067970221_0156/.metadata<BR />/user/test/.<FONT color="#FF0000">temp</FONT>/job_1571067970221_0156/mr/job_1571067970221_0156/.metadata/descriptor.properties<BR />/user/test/.<FONT color="#FF0000">temp</FONT>/job_1571067970221_0156/mr/job_1571067970221_0156/.metadata/schema.avsc<BR />/user/test/.<FONT color="#FF0000">temp</FONT>/job_1571067970221_0156/mr/job_1571067970221_0156/.metadata/schemas<BR />/user/test/.<FONT color="#FF0000">temp</FONT>/job_1571067970221_0156/mr/job_1571067970221_0156/.metadata/schemas/1.avsc<BR />/user/test/axe<BR />/user/test/axe/.metadata<BR />/user/test/axe/.metadata/descriptor.properties<BR />/user/test/axe/.metadata/schema.avsc<BR />/user/test/axe/.metadata/schemas<BR />/user/test/axe/.metadata/schemas/1.avsc</P><P>&nbsp;</P><P><U><STRONG>once the import is complete:</STRONG></U><BR />hadoop fs -ls -R /user/test/<BR />/user/test/axe<BR />/user/test/axe/.metadata<BR />/user/test/axe/.metadata/descriptor.properties<BR />/user/test/axe/.metadata/schema.avsc<BR />/user/test/axe/.metadata/schemas<BR />/user/test/axe/.metadata/schemas/1.avsc<BR />/user/test/axe/.signals<BR />/user/test/axe/.signals/unbounded<BR />/user/test/axe/679dadfc-3657-410b-a805-6c98b8d1720b.parquet<BR />/user/test/axe/923bbf06-35d6-4156-8df3-a6e53ebf00f7.parquet<BR />/user/test/axe/aef24eac-15dd-4ebc-a61a-68265d53a320.parquet<BR />/user/test/axe/f903a079-87b3-48a0-bea6-aa02d92c5aac.parquet</P><P>&nbsp;</P> Mon, 11 Nov 2019 07:14:53 GMT sow 2019-11-11T07:14:53Z