I was trying to import all tables from retail_db. Created the db problem6_rak. It dumps the records for categories table and fails with an error. There is no problem with the directory on hdfs.
The sqoop command used is as below:
sqoop import-all-tables --connect “jdbc:mysql://nn01.itversity.com:3306/retail_db” --username retail_dba --password itversity --warehouse-dir /user/hive/warehouse/problem6_rak --hive-import --hive-database problem6_rak --create-hive-table --as-textfile;
Here is the error:
It would be great if somebody could help!