Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

unable to import all tables by sqoop

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

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.

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

Don't have an account?
Coming from Hortonworks? Activate your account here