Sqoop export - failed with unable to parse exception

#1

Hi,

I need your help plz.
Sqoop exporting is failing with Java IO exception. this is in reference to practice test #9 on udemy. For your reference, copying problem and my solution that is failing. Please help. Thank you!

problem:

Export h1b data from hdfs to MySQL Database

  • h1b data with ascii character “\001” as delimiter is available in HDFS
  • HDFS Location: /public/h1b/h1b_data_to_be_exported

my solution-

sqoop export \
--connect "jdbc:mysql://ms.itversity.com/retail_export" \
--username retail_user \
--password itversity \
--table h1b_data_kondapalli \
--input-fields-terminated-by "\001" \
--export-dir "/public/h1b/h1b_data_to_be_exported" \
--input-null-string "NA" \
--input-null-non-string "NA" \
--m 1

error:

0 Likes

#2

Dear @Swetha_Kondapalli, the issue is due to the recent upgrade and we need to downgrade our MySQL Database. Issue will be fixed in next couple of days.

0 Likes

closed #3
0 Likes