prasku5 · May 3, 2018 17:24
diff --git a/Sqoop_Import_Hive_Overwrite b/Sqoop_Import_Hive_Overwrite
 sqoop import \   
 --connect jdbc:mysql://localhost/source_database_name \ (This is the path to access the Source DB using JDBC Driver)  
 --username <username> \                                 (Source Database Username)
 --password <password> \                                 (Source Database password)
 --database source_database_name \                       (The database name will become folder name in target HDFS )
 --table Source_table_name \                             (This will store the files in .gz compression which is default)                                      
 --hive-import \                                         (This will import the data imported in HDFS as Hive table automatically)
 --hive-table <table name>\                              (This will be the name of hive table of our choice instead of default MySQL table name)
 --hive-overwrite \                                      (This will overwrite the existing file in HDFS and recreate new table in Hive)
 -m 4
	sqoop import \
	--connect jdbc:mysql://localhost/source_database_name \ (This is the path to access the Source DB using JDBC Driver)
	--username <username> \ (Source Database Username)
	--password <password> \ (Source Database password)
	--database source_database_name \ (The database name will become folder name in target HDFS )
	--table Source_table_name \ (This will store the files in .gz compression which is default)
	--hive-import \ (This will import the data imported in HDFS as Hive table automatically)
	--hive-table <table name>\ (This will be the name of hive table of our choice instead of default MySQL table name)
	--hive-overwrite \ (This will overwrite the existing file in HDFS and recreate new table in Hive)
	-m 4