hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Damien Carol <damien.ca...@gmail.com>
Subject Re: incosistent result from orc select count(*)
Date Sun, 18 Sep 2016 08:03:23 GMT
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.verma82@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
>

Mime
View raw message