Support Questions

Find answers, ask questions, and share your expertise

incorrect data,post sqoop from MS-SQL to Hadoop

avatar
Explorer

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

1 ACCEPTED SOLUTION

avatar
Expert Contributor

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

View solution in original post

2 REPLIES 2

avatar
Expert Contributor

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

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