phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Flavio Pompermaier <pomperma...@okkam.it>
Subject Row count
Date Wed, 13 Sep 2017 10:34:01 GMT
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

Mime
View raw message