- Command to import data by specified delimiters
sqoop import --connect jdbc:mysql://ms.itversity.com:3306/retail_db --username retail_user --password itversity --table orders --warehouse-dir /user/training/sqoop_import/retail_db --delete-target-dir --fields-terminated-by '|' --lines-terminated-by ':'
- Command to delete directory if it exists in local system
rm -rf orders
- Command to get files from hdfs to local system
hadoop fs -get /user/training/sqoop_import/retail_db/orders .
- Command to view the data in file
view part-m-00000