Support Questions
Find answers, ask questions, and share your expertise

unable to import all tables by sqoop

Highlighted

unable to import all tables by sqoop

New Contributor

this is the sqoop command which I am using to import data from SQL Server to Hive

sqoop-import-all-tables --connect "jdbc:sqlserver://ip.ip.ip.ip\MIGERATIONSERVER;port=1433;username=sa;password=blablaq;

database=sqlserverdb" --create-hive-table --hive-import

--hive-database hivemtdb

The problem is that sqlserverdb has about 100 tables but when i issue this command it is just importing 6 or 7 random tables to hive. This behavior is really strange for me. I am unable to find where I am doing mistake.

2 REPLIES 2
Highlighted

Re: unable to import all tables by sqoop

Expert Contributor

when you connect as the user in your connect string, does it have correct permissions to view and export all the tables. That could be a factor. just log with the same user and check for your privileges on those tables and try to grant if they dont exist and run the sqoop command again.

Highlighted

Re: unable to import all tables by sqoop

New Contributor

the user has all rights and permission. it is an 'sa' account which means it has all the access