Skip to content

Instantly share code, notes, and snippets.

@prasku5
Created May 3, 2018 17:54
Show Gist options
  • Save prasku5/b80a405884f0b78c92bebd143a86c789 to your computer and use it in GitHub Desktop.
Save prasku5/b80a405884f0b78c92bebd143a86c789 to your computer and use it in GitHub Desktop.
sqoop create-hive-table \
--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 \
--hive-table <table_name> (This is our desired table name in Hive)
-m 4
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment