192.Sqoop Import – Specifying Delimiters – Import NYSE Data with \t as delimiter

  • 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

Share this post