phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nipur Patodi <er.nipur.pat...@gmail.com>
Subject Issue while joining data using pheonix
Date Tue, 11 Aug 2015 07:43:49 GMT
Hi All,

I am trying to join data in hbase phoenix tables. How ever I am getting
this exception.


*Error: Encountered exception in sub plan [0] execution. (state=,code=0)*
*java.sql.SQLException: Encountered exception in sub plan [0] execution.*
* at
org.apache.phoenix.execute.HashJoinPlan.iterator(HashJoinPlan.java:157)*
* at
org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:251)*
* at
org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:241)*
* at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)*
* at
org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:240)*
* at
org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1250)*
* at sqlline.Commands.execute(Commands.java:822)*
* at sqlline.Commands.sql(Commands.java:732)*
* at sqlline.SqlLine.dispatch(SqlLine.java:808)*
* at sqlline.SqlLine.begin(SqlLine.java:681)*
* at sqlline.SqlLine.start(SqlLine.java:398)*
* at sqlline.SqlLine.main(SqlLine.java:292)*
*Caused by: org.apache.phoenix.join.MaxServerCacheSizeExceededException:
Size of hash cache (104857664 bytes) exceeds the maximum allowed size
(104857600 bytes)*
* at
org.apache.phoenix.join.HashCacheClient.serialize(HashCacheClient.java:109)*
* at
org.apache.phoenix.join.HashCacheClient.addHashCache(HashCacheClient.java:82)*
* at
org.apache.phoenix.execute.HashJoinPlan$HashSubPlan.execute(HashJoinPlan.java:339)*
* at org.apache.phoenix.execute.HashJoinPlan$1.call(HashJoinPlan.java:136)*
* at java.util.concurrent.FutureTask.run(FutureTask.java:266)*
* at
org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask.run(JobManager.java:172)*
* 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)*

I also tried changing phoenix.query.maxServerCacheBytes to 1GB and
phoenix.query.maxGlobalMemoryPercentage to 40 in hbase-site.xml ( as I am
using ambari). but it desn't worked.

Any suggestion would be extremely helpful.

Thanks,
_Nipur

Mime
View raw message