can you confirm what values are set for phoenix.groupby.estimatedDistinctValues(Integer) and phoenix.groupby.maxCacheSize(long)?
On Wed, Aug 31, 2016 at 12:24 PM, Dong-iL, Kim <[email protected]> wrote: > Hi. > > when I’m using simple groupby query, exception occured as below. > What shall I do? > > Thanks. > > Error: org.apache.phoenix.exception.PhoenixIOException: > org.apache.hadoop.hbase.DoNotRetryIOException: PLAYER_ACTION,\x00\x00B\ > x8D2J7GvczV2U8J8Z2itjcODTGI\x003\x001\x004\x00\x80\x00\x00\x00\x00l\ > xE1e1157988054337976043\x00\x00\x00\x01V\xBA\x8DH~,1472148086609. > d1b6338ff6820e5469eb78643e4e177d.: Number of bytes to resize to must be > greater than zero, but instead is -1984010164 > at org.apache.phoenix.util.ServerUtil.createIOException( > ServerUtil.java:87) > at org.apache.phoenix.util.ServerUtil.throwIOException( > ServerUtil.java:53) > at org.apache.phoenix.coprocessor.BaseScannerRegionObserver. > postScannerOpen(BaseScannerRegionObserver.java:229) > at org.apache.hadoop.hbase.regionserver. > RegionCoprocessorHost$52.call(RegionCoprocessorHost.java:1334) > at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$ > RegionOperation.call(RegionCoprocessorHost.java:1673) > at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost. > execOperation(RegionCoprocessorHost.java:1749) > at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost. > execOperationWithResult(RegionCoprocessorHost.java:1712) > at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost. > postScannerOpen(RegionCoprocessorHost.java:1329) > at org.apache.hadoop.hbase.regionserver.RSRpcServices. > scan(RSRpcServices.java:2412) > at org.apache.hadoop.hbase.protobuf.generated. > ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33648) > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2178) > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:112) > at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop( > RpcExecutor.java:133) > at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor. > java:108) > at java.lang.Thread.run(Thread.java:745) > Caused by: java.lang.IllegalStateException: Number of bytes to resize to > must be greater than zero, but instead is -1984010164 > at org.apache.phoenix.memory.GlobalMemoryManager$ > GlobalMemoryChunk.resize(GlobalMemoryManager.java:135) > at org.apache.phoenix.cache.aggcache.SpillableGroupByCache$1. > removeEldestEntry(SpillableGroupByCache.java:172) > at java.util.LinkedHashMap.afterNodeInsertion( > LinkedHashMap.java:299) > at java.util.HashMap.putVal(HashMap.java:663) > at java.util.HashMap.put(HashMap.java:611) > at org.apache.phoenix.cache.aggcache.SpillableGroupByCache.cache( > SpillableGroupByCache.java:249) > at org.apache.phoenix.coprocessor.GroupedAggregateRegionObserver > .scanUnordered(GroupedAggregateRegionObserver.java:420) > at org.apache.phoenix.coprocessor.GroupedAggregateRegionObserver > .doPostScannerOpen(GroupedAggregateRegionObserver.java:165) > at org.apache.phoenix.coprocessor.BaseScannerRegionObserver. > postScannerOpen(BaseScannerRegionObserver.java:202) > ... 12 more (state=08000,code=101)
