Could you please get hte result of this query: *EXPLAIN EXTENDED select count(*) from table where id= <...>*
2016-09-17 4:15 GMT+02:00 Sanjeev Verma <sanjeev.verm...@gmail.com>: > Hi > > on hive-1.2.1 orc backed table I am running query select * from table > where id=some it is returning me some 40 rows but when I did select > count(*) from table where id= then > it is returning me 14. tried to disable compute query using stats but no > luck. > > could you please help me find out the issue, is there any caching involved > here which is giving me bad results. > > Thanks >