Reply
Highlighted
New Contributor
Posts: 5
Registered: ‎11-04-2015
Accepted Solution

incorrect data,post sqoop from MS-SQL to Hadoop

[ Edited ]

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

Posts: 45
Topics: 0
Kudos: 13
Solutions: 4
Registered: ‎07-30-2018

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

[ Edited ]

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
Posts: 5
Registered: ‎11-04-2015

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

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
Announcements
New solutions