receiving below error while importing table data using sqoop. pls help


2 Answer(s)


Hi Pratik,

Please replace 127.0.0.1 to localhost and use user as cloudera and use --password instead of -P.

Please use the following command:
[cloudera@localhost ~]$ sqoop import --connect jdbc:mysql://localhost:3306/sqoop --username cloudera --password your_sql_password  --table cities --target-dir /user/cloudera/nyse-project -m 1

Please make sure provided details in the command are valid.

Hope this helps.


Thanks. tried the above aswell. But it doesnt seem to work.