03-03-2019 11:57 PM - last edited on 03-04-2019 06:13 AM by cjervis
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?
03-05-2019 07:25 AM - edited 03-05-2019 07:25 AM
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
03-05-2019 07:15 PM