Regarding Sqoop Import

Hi All ,

I was trying to import all the tables to my HDFS location “/user/amit_achary/spark”

I used the below scripts “sqoop import-all-tables --connect “jdbc:mysql://” --username retail_dba --password itversity --target-dir /user/amit_achary/spark”

It is showing the error as “Warning: /usr/hdp/ does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.”

Anyone please help me on this issue.

Regards ,

@amit0900 that’s a warning and not an error message.

its a warning. but data is not getting imported :frowning:

@amit0900 Replace target-dir with warehouse-dir

Yes , I did the same now. But only one table is getting imported :frowning: Please give me the solution for this.

#To import all tables and does not support target-dir so warehouse-dir if needed
sqoop import-all-tables --connect jdbc:mysql://localhost:3306/retail_db
–username root
–password cloudera
–warehouse-dir /user/cloudera/cca175/review/sqoop_import/mysql_all_tables
-m 5