- Command to import order_items table and overwrite the directory if exists:
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
- To validate:
sqoop eval --connect jdbc:mysql://ms.itversity.com:3306/retail_db --username retail_user --password itversity -e "DESCRIBE order_items"