- Command to import order_items table using compress
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 --compress
- Command to import table as compressed file using a specific compression codec
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 --compress --compression-codec org.apache.hadoop.io.compress.SnappyCodec