Zhao, Yes, the only way is to use a scanner but it will take a _long_ time. HBASE-32 <https://issues.apache.org/jira/browse/HBASE-32>is about adding a row count estimator. For those who want to know why it's so slow, having a scanner that goes on each row of a table requires doing a read request on disk for each one of them (except for the stuff in the memcache that waits to be flushed). If you have 6 500 000 rows like I saw last week on the IRC channel, i may take well over 80 minutes (it depends on the cpu/io/network load, hardware, etc).
J-D On Mon, Jul 21, 2008 at 5:21 AM, ZhaoWei <[EMAIL PROTECTED]> wrote: > Hi J-D, > How to get row count of a table, only scanner? > > > Thanks! > > > Daniel, > > > > Sorry, this feature is still missing in HBase. For the moment, the best > you > > can do is to use HDFS web UI. If you would like to this in a future > release, > > feel free to fill a Jira: https://issues.apache.org/jira/browse/HBASE > > > > J-D > > > > On Sat, Jul 19, 2008 at 5:58 PM, Daniel <[EMAIL PROTECTED]> wrote: > > > > > hi all, > > > it's a bit strange, but i cant find some class or method to get the > > > 'size' of a created table - maybe the total size of all the HStores ? > > > or is there any command in HQL can do this? > > > Thanks. > > > > > > Daniel > > > >
