Scribd
Upload
34 views1 page

Scoop

The document provides various commands for using Sqoop to import and export data between MySQL and Hadoop. It includes commands for importing specific tables, importing all tables, exporting data, and listing databases and tables. Each command specifies connection details, username, password, and target directories or tables.

Uploaded by

pranathiponnam
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
34 views1 page

Scoop

The document provides various commands for using Sqoop to import and export data between MySQL and Hadoop. It includes commands for importing specific tables, importing all tables, exporting data, and listing databases and tables. Each command specifies connection details, username, password, and target directories or tables.

Uploaded by

pranathiponnam
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

sqoop import \

--connect jdbc:mysql://localhost/training \
--username root --password password \
--table emp -m 1\
--target-dir /user/ubh01/input1
------------------------------------------------------

sqoop import -–connect jdbc:mysql://localhost/root \


-–username root --password password \
-–table emp \
-–hive-import \
–-hive-table training.emp -m 1

-------------------------------------------------
sqoop import-all-tables --connect jdbc:mysql://localhost/training \
--username root --password password -m 1 \
--warehouse-dir /user/ubh01/output3

sqoop export --connect jdbc:mysql://localhost/training \


--username root --password password \
--table emp --m 1 --export-dir /input1

sqoop list-databases --connect jdbc:mysql://localhost/ --username root --password


password

sqoop list-tables --connect jdbc:mysql://localhost/training --username root --


password password

You might also like