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
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.
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.