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
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
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