-Showing wrong count after importing table in Hive
Bhavesh Shah 2012-02-09, 04:12
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,