question Re: incorrect data,post sqoop from MS-SQL to Hadoop in Support Questions

incorrect data,post sqoop from MS-SQL to Hadoop

ispirit — Tue, 21 Apr 2026 11:38:10 GMT

Hi All,

We have sqooped data from MS-SQL 2008 into HDFS and created external tables . The record count shows same between the MS-SQL table and Hive tables. However, if i fire same query on MS-SQL table and Hive table, the output is different. The query is being fired through Hue(tested through Impala as well). Could you please help, if i missed something?

Regards.

Sandeep Suman

Re: incorrect data,post sqoop from MS-SQL to Hadoop

Jerry — Tue, 05 Mar 2019 15:25:53 GMT

Hi Sandeep,

It seems the data has been imported as the count is same. But sometimes the datatype might be different between MS-SQL and Hive tables which result in NULL values.

Let's try to check the datatype between the tables and also share the sqoop command for further check

Thanks
Jerry

Re: incorrect data,post sqoop from MS-SQL to Hadoop

ispirit — Wed, 06 Mar 2019 03:15:00 GMT

Hi Jerry,

Thanks for your help. Few columns had different data types and table was created using delimiter ',' and column data had elements with '','.

Regards.

Sandeep Suman