phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abe Weinograd <>
Subject count on large table
Date Tue, 07 Oct 2014 20:34:35 GMT
I have a table with 1B  rows.  I know this can is very specific to my
environment, but just doing a SELECT COUNT(1) on the table   It never

We have a 10 node cluster with the RS's Heap size at 26GiB and skewed
towards the block cache.  In the RS logs, i see a lot of these:

2014-10-07 16:27:04,942 WARN org.apache.hadoop.ipc.RpcServer:

They stop eventually, but i the query times out and the query tool
reports: org.apache.phoenix.exception.PhoenixIOException: 187541ms passed
since the last invocation, timeout is currently set to 60000

Any ideas of where I can start in order to figure this out?

using Phoenix 4.1 on CDH 5.1 (Hbase 0.98.1)


View raw message