Skip to content

Instantly share code, notes, and snippets.

@jiankuang

jiankuang/sqoop

Last active July 6, 2016 06:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jiankuang/564c46303329a9934116de77bde6c2cc to your computer and use it in GitHub Desktop.
Save jiankuang/564c46303329a9934116de77bde6c2cc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sqoop
# import mysql tables into HDFS using sqoop
sqoop import-all-tables --connect jdbc:mysql://localhost/retail_db --username retail_dba --password cloudera
# import mysql tables into hive using sqoop
sqoop import-all-tables --connect jdbc:mysql://localhost/retail_db --username retail_dba --password cloudera --hive-import --create-hive-table
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment