Skip to content

Instantly share code, notes, and snippets.

@prasku5

prasku5/Simple_Sqoop_Export

Created May 2, 2018 09:57
Show Gist options
  • Save prasku5/2823a939b984adfad84e22aca83b91f1 to your computer and use it in GitHub Desktop.
Save prasku5/2823a939b984adfad84e22aca83b91f1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Simple_Sqoop_Export
sqoop export \
--connect jdbc:mysql://localhost/destination_database_name \
--driver com.mysql.jdbc.Driver \
--username <username> \
--password <password> \
--table source_table_name \ (This is the destination table in MySQL)
--export-dir /apps/hive/warehouse/movies (This is the Source file to export from HDFS)
--input-fields-terminated-by '\0001' (This is the delimiter in HDFS File )
-m 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment