Sir we a importing SQL data through scoop in hive of text which has all special characters and when we take a count of that table is 5000from SQL table its and cross checking the same in hive it gives 6143 there is a difference of 1143 records which are null how to avoid this please help us getting this sorted.
Can you please share the exact sqoop command you are running at your end.
Also, I think your Hive table is a TextFormat table(correct me if I am wrong).
If you have the table in Textformat, this means your data from Source SQL DB contains change line characters such as "\n" in some of your fields.
To resolve the issue, import the data to an ORC Hive table.
Example on how to create ORC table in Hive:
CREATE TABLE test_details_txt( visit_id INT, store_id SMALLINT) STORED AS ORC;