Row count

[Flavio Pompermaier]

Hi to all,
I'm trying to investigate the best option to have get the row count out of
a table.

I've tried the following:


   1. SELECT COUNT(*) FROM MYTABLE
      1. very slow without an index, very quick with an index
      2. however the result could be non-deterministic if HBase has just
      been restarted..
   2. SELECT SUM(GUIDE_POSTS_ROW_COUNT) from SYSTEM.STATS WHERE
   PHYSICAL_NAME = 'MYTABLE';
   1. the result here is completely different from the first one..323329772
      vs 13376168. How is that possible?

Best,
Flavio