When I need to know a row count for table I kept a separate table just for that purpose and would update/query that table. Low tech but it worked.
-Pete -----Original Message----- From: Jeff Whiting [mailto:je...@qualtrics.com] Sent: Wednesday, March 16, 2011 1:46 PM To: user@hbase.apache.org Cc: Stack Subject: Re: Row Counters Just a random thought. What about keeping a per region row count? Then if you needed to get a row count for a table you'd just have to query each region once and sum. Seems like it wouldn't be too expensive because you'd just have a row counter variable. It maybe more complicated than I'm making it out to be though... ~Jeff On 3/16/2011 2:40 PM, Stack wrote: > On Wed, Mar 16, 2011 at 1:35 PM, Vivek Krishna<vivekris...@gmail.com> wrote: >> 1. How do I count rows fast in hbase? >> >> First I tired count 'test' , takes ages. >> >> Saw that I could use RowCounter, but looks like it is deprecated. > It is not. Make sure you are using the one from mapreduce package as > opposed to mapred package. > > >> I just need to verify the total counts. Is it possible to see somewhere in >> the web interface or ganglia or by any other means? >> > We don't keep a current count on a table. Too expensive. Run the > rowcounter MR job. This page may be of help: > http://hbase.apache.org/apidocs/org/apache/hadoop/hbase/mapreduce/package-summary.html#package_description > > Good luck, > St.Ack -- Jeff Whiting Qualtrics Senior Software Engineer je...@qualtrics.com
