Error in exercise 2: exporting tables from MySQL to HDFS

[#1]

When I run the following command:

sqoop import-all-tables \
    -m 1 \
    --connect jdbc:mysql://quickstart:3306/retail_db \
    --username=retail_dba \
    --password=cloudera \
    --compression-codec=snappy \
    --as-avrodatafile \
    --warehouse-dir=/user/hive/warehouse

I get the following error:

/usr/lib/sqoop/bin/sqoop: line 101: /usr/jars/bin/hadoop: No such file or directory
/usr/lib/sqoop/bin/sqoop: line 101: exec: /usr/jars/bin/hadoop: cannot execute: No such file or directory

I tried to remove that file using:

hadoop fs -rm -r -skipTrash /usr/jars/bin/hadoop

I still get the same error!!!!!

any suggestions????

[#2 · Accepted solution]

Perhaps this other thread will be of assistance.  

tutorial exercise 2: no tables

[#3 · Accepted solution]

Perhaps this other thread will be of assistance.  

tutorial exercise 2: no tables

[#4]

Thanks for the suggestion! I tried the suggested commands but I still have the same problem. 

[#5]

Sorry to hear that. Hopefully someone more knowledgable than I will jump in with something better. 

[#6 · Accepted solution]

Thanks for following up. Problem is solved; I ran hive server and made the namenode leave the safe mode. Then the command included in the thread you posted worked finally.

[#7]

Great! Feel free to mark your last comment as the solution. Perhaps it will help others as well.