sharath
Reputation: 21
Importing limited number of tables using sqoop
I have 100 tables in mysql and i just want to import just 10 tables using sqoop. can anyone help me how to import just 10 tables?
sqoop import --connect
Upvotes: 0
Views: 57
Answers (1)
Dev
Reputation: 13753
You need to write 10 sqoop import commands for that.
sqoop import-all-tables can be used to import all the tables in a database and exclude few tables using
--exclude-tables <tables>
where <tables> is comma separated list of tables to exclude from import process.
Upvotes: 1
Related Questions
- Sqoop import multiple tables but not all
- sqoop import multiple tables
- sqoop: import-all-tables not importing all tables
- Import the all tables from RDBMS using sqoop
- import the whole database using sqoop
- Sqoop import all the table primary and non primary key tables at a time
- sqoop import-all-tables : not working
- How can I do this without having to import the tables one by one?
- Sqoop command-How to give schema name for Import All Tables
- sqoop free form query to import n records from a table