incorrect data,post sqoop from MS-SQL to Hadoop

[#1]

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

[#2 · Accepted solution]

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

[#3]

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