I am using HDP 2.4 sandbox. I created a few tables in mysql ( in a new database ) and i am trying to import into hive database called "cards". But is i failing with below error after creating first table. Same command works fine in HDP 2.3 sandbox. I had given 777 permission for all the folders as mentioned in below post , but still i get the error https://community.hortonworks.com/questions/9984/permission-denied-using-sqoop-from-mysql-on-sandbo.html https://community.hortonworks.com/questions/10949/permission-denied-for-user-while-creating-a-hive-t.html SQOOP command: sqoop import-all-tables --connect "jdbc:mysql://sandbox.hortonworks.com:3306/retail_db" --username retail_dba --hive-database cards -m 1 --warehouse-dir /apps/hive/warehouse/cards.db --hive-import --create-hive-table --hive-overwrite --compress --driver com.mysql.jdbc.Driver --password hadoop; Error Message: 16/05/17 07:20:42 INFO mapreduce.ImportJobBase: Transferred 576 bytes in 20.5035 seconds (28.0928 bytes/sec) 16/05/17 07:20:42 INFO mapreduce.ImportJobBase: Retrieved 58 records. 16/05/17 07:20:42 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM categories AS t WHERE 1=0 16/05/17 07:20:42 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM categories AS t WHERE 1=0 16/05/17 07:20:42 INFO hive.HiveImport: Loading uploaded data into Hive Logging initialized using configuration in jar:file:/usr/hdp/2.4.0.0-169/hive/lib/hive-common-1.2.1000.2.4.0.0-169.jar!/hive-log4j.properties OK Time taken: 8.528 seconds Loading data to table cards.categories Moved: 'hdfs://sandbox.hortonworks.com:8020/apps/hive/warehouse/cards.db/categories/part-m-00000.gz' to trash at: hdfs://sandbox.hortonworks.com:8020/user/root/.Trash/Current Failed with exception Unable to move source hdfs://sandbox.hortonworks.com:8020/apps/hive/warehouse/cards.db/categories/part-m-00000.gz to destination hdfs://sandbox.hortonworks.com:8020/apps/hive/warehouse/cards.db/categories/part-m-00000.gz FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask ... View more