to be deterministic in normal scenarios. can
> you elaborate what is the difference you see after HBase restarted?
>
> bq. SELECT SUM(GUIDE_POSTS_ROW_COUNT) from SYSTEM.STATS WHERE
> PHYSICAL_NAME = 'MYTABLE';
>
> We calculate row count till the guidePosts is fou
/hbase.apache.org/apidocs/org/apache/hadoop/hbase/mapreduce/RowCounter.html
M/R.
On Tue, Dec 19, 2017 at 3:18 PM, James Taylor
mailto:jamestay...@apache.org>> wrote:
If it needs to be 100% accurate, then count(*) is the only way. If your data is
write-once data, you might be able to track th
ache.org/apidocs/org/apache/hadoop/hbase/mapreduce/RowCounter.html>
> http://hbase.apache.org/apidocs/org/apache/hadoop/hbase/
> mapreduce/RowCounter.html M/R.
>
> On Tue, Dec 19, 2017 at 3:18 PM, James Taylor
> wrote:
>
>> If it needs to be 100% accurate, then count(
way. If
your data is write-once data, you might be able to track the row
count at the application level through some kind of atomic counter
in a different table (but this will likely be brittle). If you can
live with an estimate, you could enable statistics [1], optionally
might be able to track the row count at the
> application level through some kind of atomic counter in a different table
> (but this will likely be brittle). If you can live with an estimate, you
> could enable statistics [1], optionally configuring Phoenix not to use
> stats for parall
If it needs to be 100% accurate, then count(*) is the only way. If your
data is write-once data, you might be able to track the row count at the
application level through some kind of atomic counter in a different table
(but this will likely be brittle). If you can live with an estimate, you
could
Hi,
Is there a way to get the total row count of a phoenix table without
running select count(*) from table ?
my use case is to monitor the record count in a table every x minutes,
so didn't want to put load on the system by running a select count(*)
query.
Thanks,
Jins George
= 'MYTABLE';
We calculate row count till the guidePosts is found in the region
and no count will be stored for a region having a size not enough for
guidepost width or remaining region after the last guidePosts. so this
row_count should not be used against actual count.
On Wed, Sep 13, 201
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 HBas
