- To save the imported table as avro file format:
sqoop import --connect jdbc:mysql --username retail_user --password itversity --table order_items --warehouse-dir /user/training/sqoop_import/retail_db --delete-target-dir --as-avrodatafile
- To validate imported files:
hadoop fs -ls /user/training/sqoop_import/retail_db/order_items