I have a database that contains about 830 tables. I tried doing a sqoop import-all-tables and it imported about 150 tables and failed on one table.
1. Is there a way for me to specify exclusions in the sqoop command?
2. How do I sqoop import the remaining 680 tables? When i use the same sqoop command, it fails as it specifies that some tables are already exisiting?
Here is the sqoop command used:
sqoop import-all-tables --connect "jdbc:sqlserver://220.127.116.11;database=axios; username=sqoop;password=hadoop" --warehouse-dir=/user/Axios -m 1