Hi, I meet the same problem once, then I change the amount of imported columns it works fine. Sometimes blank rows would be generated by sqoop..I do not actually know what the problem really is..
2012/2/9 Bhavesh Shah <bhavesh25s...@gmail.com> > > > > > 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 > >
