Support Questions
Find answers, ask questions, and share your expertise

incorrect data,post sqoop from MS-SQL to Hadoop

New Contributor

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

Rising Star

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

Rising Star

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

New Contributor
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
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.