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://126.96.36.199;database=axios; username=sqoop;password=hadoop" --warehouse-dir=/user/Axios -m 1
But how come one write 150 tables in exclude-tables argument, is there any other alternative for mentioning these many tables in exclude-tables argument.
@harsh8 , as this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post.