How to load multiple tables in Sqoop

Question

How can I import multiple tables via sqoop. Suppose I have 150 tables to load, how can I load them at once?

Answer 1

U can use " import-all-tables " option to load all tables into HDFS at once.​ Refer to the command below:

sqoop import-all-tables --connect jdbc:mysql://localhost/sqoop --username root --password hadoop --target-dir '/Sqoop21/AllTables'