Skip to content

Instantly share code, notes, and snippets.

@prasku5

prasku5/Sqoop_Import_Exclude_Tables

Created May 3, 2018 19:10
Show Gist options
  • Save prasku5/dfa3e5a989a4440c77890ba90eff9805 to your computer and use it in GitHub Desktop.
Save prasku5/dfa3e5a989a4440c77890ba90eff9805 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Sqoop_Import_Exclude_Tables
sqoop import-all-tables \
--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 )
--exclude-tables <table1>,<table2> (we can exclude tables of our choice with this tag)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment