Sqoop provide capability to import all the tables using import-all-tables
- All the tables from a schema/database can be imported
- –exclude-tables, will facilitate to exclude the tables that need not be imported
- –auto-reset-to-one-mapper, will let import all tables to choose one mapper in case table does not have primary key
- Most of the features such as –query, –boundary-query, –where etc are not available with import-all-tables.