phoenix.query.maxServerCacheBytes is a client side parameter. If you are using bin/sqlline.py then set this property in bin/hbase-site.xml and restart sqlline.
- mujtaba On Tue, Jul 19, 2016 at 1:59 PM, Nathan Davis <[email protected]> wrote: > Hi, > I am running a standalone HBase locally with Phoenex installed by dropping > the jars into HBase lib directory. I have added the following to my > hbase-site.xml and restarted HBase: > > <property> >> <name>phoenix.query.maxServerCacheBytes</name> >> <value>419430400</value> >> </property> >> <property> >> <name>phoenix.query.maxGlobalMemoryPercentage</name> >> <value>25</value> >> </property> > > > However, I am still getting the following error when doing a regular inner > join to an 5mill-sized RHS table (Notice that the error says "...maximum > allowed size (104857600 bytes)" even though I have changed that setting to > 400MB): > > java.sql.SQLException: Encountered exception in sub plan [0] execution. >> at org.apache.phoenix.execute.HashJoinPlan.iterator(HashJoinPlan.java:193) >> at org.apache.phoenix.execute.HashJoinPlan.iterator(HashJoinPlan.java:138) >> at >> org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:276) >> at >> org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:261) >> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) >> at >> org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:260) >> at >> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:248) >> at >> org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:172) >> at >> org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:177) >> at >> org.apache.phoenix.jdbc.PhoenixConnection.executeStatements(PhoenixConnection.java:354) >> at >> org.apache.phoenix.util.PhoenixRuntime.executeStatements(PhoenixRuntime.java:298) >> at org.apache.phoenix.util.PhoenixRuntime.main(PhoenixRuntime.java:243) >> Caused by: org.apache.phoenix.join.MaxServerCacheSizeExceededException: >> Size of hash cache (104857638 bytes) exceeds the maximum allowed size >> (104857600 bytes) >> at >> org.apache.phoenix.join.HashCacheClient.serialize(HashCacheClient.java:110) >> at >> org.apache.phoenix.join.HashCacheClient.addHashCache(HashCacheClient.java:83) >> at >> org.apache.phoenix.execute.HashJoinPlan$HashSubPlan.execute(HashJoinPlan.java:381) >> at org.apache.phoenix.execute.HashJoinPlan$1.call(HashJoinPlan.java:162) >> at org.apache.phoenix.execute.HashJoinPlan$1.call(HashJoinPlan.java:158) >> at java.util.concurrent.FutureTask.run(FutureTask.java:266) >> at >> org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask.run(JobManager.java:183) >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) >> at java.lang.Thread.run(Thread.java:745) > > > It seems like my `maxServerCacheBytes` setting is not getting picked up, > but not sure why. I'm pretty newb to Phoenix so I'm sure it's something > simple... > > Thanks up front for the help! > > -Nathan Davis >
