phoenix 使用异常

使用select count(*) 出现如下错误:

Error: Task org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask@6e91893 rejected from org.apache.phoenix.job.JobManager$1@26ae880a[Running, pool size = 128, active threads = 128, queued tasks = 5000, completed tasks = 36647] (state=08000,code=101)
org.apache.phoenix.exception.PhoenixIOException: Task org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask@6e91893 rejected from org.apache.phoenix.job.JobManager$1@26ae880a[Running, pool size = 128, active threads = 128, queued tasks = 5000, completed tasks = 36647]
	at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:120)
	at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:1024)
	at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:916)
	at org.apache.phoenix.iterate.ConcatResultIterator.getIterators(ConcatResultIterator.java:50)
	at org.apache.phoenix.iterate.ConcatResultIterator.currentIterator(ConcatResultIterator.java:97)
	at org.apache.phoenix.iterate.ConcatResultIterator.next(ConcatResultIterator.java:117)
	at org.apache.phoenix.iterate.BaseGroupedAggregatingResultIterator.next(BaseGroupedAggregatingResultIterator.java:64)
	at org.apache.phoenix.iterate.UngroupedAggregatingResultIterator.next(UngroupedAggregatingResultIterator.java:39)
	at org.apache.phoenix.jdbc.PhoenixResultSet.next(PhoenixResultSet.java:779)
	at sqlline.BufferedRows.<init>(BufferedRows.java:37)
	at sqlline.SqlLine.print(SqlLine.java:1660)
	at sqlline.Commands.execute(Commands.java:833)
	at sqlline.Commands.sql(Commands.java:732)
	at sqlline.SqlLine.dispatch(SqlLine.java:813)
	at sqlline.SqlLine.begin(SqlLine.java:686)
	at sqlline.SqlLine.start(SqlLine.java:398)
	at sqlline.SqlLine.main(SqlLine.java:291)

解决办法:
修改hbase-site.xml
添加如下参数

phoenix.query.queueSize=10000   # 默认是5000

重启hbase
借鉴:
http://mail-archives.apache.org/mod_mbox/phoenix-user/201501.mbox/%3CCAAF1Jdg-E4=54e5dC3WazL=MVUe8C93E4zoHobiYWaOVs86TCA@mail.gmail.com%3E
https://blog.csdn.net/qq_36732988/article/details/87915449

原文地址:https://www.cnblogs.com/yjt1993/p/13230709.html