Re: incosistent result from orc select count(*)

2016-09-18 Thread Damien Carol
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 : > 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 sel

incosistent result from orc select count(*)

2016-09-16 Thread Sanjeev Verma
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 issu