SQOOP command permission issue on /tmp directory

SQOOP command permission issue on /tmp directory
0.0 0


Hi Team,

Facing the below issue while issuing SQOOP command in ITVERSITY lab while running a simple SQOOP eval query as below-

sqoop eval
–connect “jdbc:mysql://nn01.itversity.com:3306/retail_db”
–username retail_dba
–password itversity
–query "select count(1) from orders"
Can you please look into the issue.

Exception in thread “main” java.lang.RuntimeException: Could not create temporary directory: /tmp/sqoop-sinhadibyojyoti/compile/dd60d3538d81769a767c38bb584bbccc; check for a directory permissions issue on /tmp.
at org.apache.sqoop.SqoopOptions.getNonceJarDir(SqoopOptions.java:909)
at org.apache.sqoop.SqoopOptions.initDefaults(SqoopOptions.java:979)
at org.apache.sqoop.SqoopOptions.(SqoopOptions.java:376)
at com.cloudera.sqoop.SqoopOptions.(SqoopOptions.java:77)
at org.apache.sqoop.Sqoop.(Sqoop.java:85)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:224)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
at org.apache.sqoop.Sqoop.main(Sqoop.java:243)


plz give the permission on /temp to current user by which you are running the sqoop command.
Since sqoop makes intermediate file in temp dir it should have permission over there.
Or try with different user.


@Alok_Singh Can you share lab user name to resolve the issue.


@Divyojyoti_Sinha Issue was solved.Please try by running sqoop command again.


Thanks a lott @BaLu_SaI :slight_smile: it is working fine now…