Help: trying export from sqoop

#1

I’m trying to export from HDFS to MSQL throught SQOOP. I’m not sure of the export-dir path.

Command:
sqoop export --connect jdbc:mysql://172.31.13.154/sqoopex --username sqoopuser --table madhav_scenario1 --export-dir /madhav/scenario1 --password xxxxxxxxxxx;

Error: 18/06/05 17:55:47 ERROR tool.ExportTool: Encountered IOException running export job: org.apache.hadoop.mapreduce.lib.input.InvalidInputException: Input path does not exist: hdf
s://ip-172-31-53-48.ec2.internal:8020/madhav/scenario1

Please help.

#2

Hi @Madhav,

You can write to only your home directory in HDFS which is /user/username. Replace username with your CloudxLab username.

Hope this helps.

Thanks