There're 1632 regions for the table. hbase release: 0.94.6-cdh4.3.1 No region server error logs found during this period. There was other jobs runing during this period.
Thanks, Lei [email protected] From: Ted Yu Date: 2014-06-10 20:44 To: [email protected] CC: user Subject: Re: HBase coprocessor AggregationClient take too long time How many regions does this table have ? What release of hbase are you using ? Do you observe exceptions in region server logs during this period ? Were there other jobs running around this period ? Cheers On Jun 10, 2014, at 4:38 AM, "[email protected]" <[email protected]> wrote: > > A simple java class to calculate the number of rows for a table. > > public class RowCount { > private static final byte[] TABLE_NAME = Bytes.toBytes("userdigest"); > private static final byte[] CF = Bytes.toBytes("cf"); > > public static void main(String[] args) throws Throwable { > > Configuration conf = new Configuration(); > conf.set("hbase.rpc.timeout", "1000000"); > conf.set("zookeeper.session.timeout", "300000"); > conf.setLong("hbase.client.scanner.caching", 10000); > Configuration configuration = HBaseConfiguration.create(conf); > > AggregationClient aggregationClient = new AggregationClient(configuration); > Scan scan = new Scan(); > scan.addFamily(CF); > long rowCount = aggregationClient.rowCount(TABLE_NAME, null, scan); > System.out.println("row count is " + rowCount); > } > } > > It didn't finish even after 2 hours. > Any insight on this? > > The total number of rows for the table is about 2G(2,000,000,000). > > Thanks, > Lei > > > > [email protected]
