hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Felix.徐 <ygnhz...@gmail.com>
Subject Re: Showing wrong count after importing table in Hive
Date Thu, 09 Feb 2012 06:11:46 GMT
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 <bhavesh25shah@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
>
>

Mime
View raw message