201.Sqoop Import – Managing Table using Hive Import – Error out – create-hive-table

  • Command to import table into hive and give error if table already exists
    • sqoop import --connect jdbc:mysql://ms.itversity.com:3306/retail_db --username retail_user --password itversity --table orders --hive-import --hive-database training_sqoop_retail --create-hive-table
  • To validate files in directory
    • hadoop fs -Is /user/training/orders
  • Command to remove files in directory
    • hadoop fs -rm -R /user/training/orders
  • Command to import data into hive
    • sqoop import --connect jdbc:mysql://ms.itversity.com:3306/retail_db --username retail_user --password itversity --table orders --hive-import --hive-database training_sqoop_retail --hive-overwrite

Share this post