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.