question Re: Error in exercise 2: exporting tables from MySQL to HDFS in Archives of Support Questions (Read Only)

Error in exercise 2: exporting tables from MySQL to HDFS

RaniFG — Fri, 16 Sep 2022 09:46:09 GMT

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????

Re: Error in exercise 2: exporting tables from MySQL to HDFS

cjervis — Tue, 27 Oct 2015 12:19:36 GMT

Perhaps this other thread will be of assistance.

tutorial exercise 2: no tables

Re: Error in exercise 2: exporting tables from MySQL to HDFS

RaniFG — Wed, 28 Oct 2015 00:15:46 GMT

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

Re: Error in exercise 2: exporting tables from MySQL to HDFS

cjervis — Wed, 28 Oct 2015 11:51:19 GMT

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

Re: Error in exercise 2: exporting tables from MySQL to HDFS

RaniFG — Wed, 28 Oct 2015 13:22:07 GMT

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.

Re: Error in exercise 2: exporting tables from MySQL to HDFS

cjervis — Wed, 28 Oct 2015 13:19:52 GMT

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