I am new to hadoop and have recently started work on sqoop. While trying to export a table from hadoop to sql server i am getting the following error: input path does not exist hdfs://sandbox:8020/user/root/ The command i am using is : sqoop export --connect "jdbc:sqlserver://;username=;password=xxxxx;database=" --table --export-dir /user/root/ -input-fields-terminated-by " " Could you please guide what i am missing here. Also could you please let me know the command to navigate to the hadoop directory where the tables are stored.
0
votes
1 Answers
0
votes
For a proper sqoop export, Sqoop requires the complete data file location. You cant just specify the root folder.
Try specifying the complete src path
sqoop export --connect jdbc:oracle:thin:<>:1521/<> --username <> --password <> --table <> --export-dir hdfs://<>/user/<>/<> -m 1 --input-fields-terminated-by '|' --input-null-string '\\N' --input-null-non-string '\\N'
Hope this helps
