Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dgadiraju/3e919a2328b50e0182dce4fa1c83d0b2 to your computer and use it in GitHub Desktop.
Save dgadiraju/3e919a2328b50e0182dce4fa1c83d0b2 to your computer and use it in GitHub Desktop.
#Default behavior
sqoop import \
--connect jdbc:mysql://ms.itversity.com:3306/hr_db \
--username hr_user \
--password itversity \
--table employees \
--warehouse-dir /user/dgadiraju/sqoop_import/hr_db
#Changing default delimiters and nulls
sqoop import \
--connect jdbc:mysql://ms.itversity.com:3306/hr_db \
--username hr_user \
--password itversity \
--table employees \
--warehouse-dir /user/dgadiraju/sqoop_import/hr_db \
--null-non-string -1 \
--fields-terminated-by "\000" \
--lines-terminated-by ":"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment