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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB