incorrect data,post sqoop from MS-SQL to Hadoop

2 replies
2553 views
Translate All

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

JerryAnswer

Gold ⭐️

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

JerryAnswer

Gold ⭐️

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

Translate

ispiritAuthor

Silver ⭐️

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

Translate

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.