Re: Table size from API

2010-01-28 Thread Harry Chen
The only way I know how to do row count is to use Scan. If you want additional optimization, try FirstKeyOnlyFilter (see its API JavaDoc). Here is an example: final Scan sizeScan = new Scan().setFilter(new FirstKeyOnlyFilter()); final ResultScanner scanner = htable.getScanner(sizeScan); try {

Re: Table size from API

2010-01-27 Thread Andrew Purtell
Actual row count is not stored anywhere. It must be discovered by a table scan, or a distributed count (mapreduce job, usually). - Andy - Original Message > From: john smith > To: hbase-user@hadoop.apache.org > Sent: Thu, January 28, 2010 2:44:16 PM > Subject: Re: Tab

Re: Table size from API

2010-01-27 Thread john smith
I think META table stores some info about tables .. is it not the case? On Thu, Jan 28, 2010 at 12:10 PM, Dan Washusen wrote: > I think the shell just performs a scan and iterates over all the rows, > counting as it goes. You could do the same with the client API... > > 2010/1/28 john smith >

Re: Table size from API

2010-01-27 Thread Dan Washusen
I think the shell just performs a scan and iterates over all the rows, counting as it goes. You could do the same with the client API... 2010/1/28 john smith > Hi guys, > > Is there a way to get the rowcount of the table from java API .. I looked > at > HTable and HTableDesc... but I couldn't f

Table size from API

2010-01-27 Thread john smith
Hi guys, Is there a way to get the rowcount of the table from java API .. I looked at HTable and HTableDesc... but I couldn't find it .. It is similar to "count " frm Hbase shell. Thanks J-S