- Command to reset number of mappers to one mapper while importing table
sqoop import --connect jdbc:mysql://ms.itversity.com:3306/retail_db --username retail_user --password itversity --table order_items --warehouse-dir /user/training/sqoop_import/retail_db --delete-target-dir --autoreset-to-one-mapper
- Command to reset number of mappers to one mapper while importing table with no primary key
sqoop import --connect jdbc:mysql://ms.itversity.com:3306/retail_db --username retail_user --password itversity --table order_items_nopk --warehouse-dir /user/training/sqoop_import/retail_db --delete-target-dir --autoreset-to-one-mapper --num-mappers 8