question Re: Select in impala has different value with hive in Support Questions

question Re: Select in impala has different value with hive in Support Questions https://community.cloudera.com/t5/Support-Questions/Select-in-impala-has-different-value-with-hive/m-p/67109#M13764  <a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/26818">@hendry</a> There could be two possibilities for this scenario 1. May be the hive and impala tables are referring to the two different files. But chances are less for this scenario unless any minor mistakes in the tables (or) some other internal error You can confirm this by > describe formatted db.tablename Run this command from both hive and impala and get the location and compare 2. Your file has duplicate records. I mean some key values are same but other columns may have different value. So it may return different value when you filter. So check your data in detail    Wed, 09 May 2018 17:13:58 GMT saranvisa 2018-05-09T17:13:58Z