Hello All, I have imported near about 10 tables in Hive from MS SQL Server. But when I try to cross check the records in Hive in one of the Table I have found more record when I run the query (select count(*) from tblName;).
Then I have drop the that Table and again imported it in Hive. I have observed in Console Logs that (Retrieved 203 records). And then I tried again for (select count(*) from tblName;) and I got the count as 298. I dont understand this why this happens. Is anything is wrong in query or it happens due to some incorrect command of sqoop-import. All other table records are fine. I got stuck here and I had spend much time to search for this. Pls help me out from this. -- Thanks and Regards, Bhavesh Shah