- Command to import order_items table using –warehouse-dir:
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
- To validate the imported table:
hadoop fs -Is /user/training/sqoop_import/retail_db/order_items