Re: Showing wrong count after importing table in Hive

2012-02-08 Thread Bhavesh Shah
Thanks all for your reply. My problem is solved using --hive-drop-import-delims. Now I am getting the correct count as that in MS SQL Server. But I want to ask one more thing that if I continue to use --hive-drop-import-delims option everytime to all tables (in case of sqoop-import-all-tables) whi

Re: Showing wrong count after importing table in Hive

2012-02-08 Thread Felix . 徐
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 > > > > >Hello All, > > I have imported near about 10 tables in Hive from

Showing wrong count after importing table in Hive

2012-02-08 Thread Bhavesh Shah
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