Hai Fu Yu created PHOENIX-2305: ---------------------------------- Summary: Simple Join does not work Key: PHOENIX-2305 URL: https://issues.apache.org/jira/browse/PHOENIX-2305 Project: Phoenix Issue Type: Bug Affects Versions: 4.5.2 Environment: HDP2.3 Phoenix 4.5.2 Reporter: Hai Fu Yu Priority: Minor
Hi, I am trying to execute below query from sqlline and sqlline-thin, but it keeps giving me this error after timeout. Also, simply linking the phoenix-server.jar in hbase back to 4.5.1 works again. Query: select * from addr, emp (small tables) Tried Increasing phoenix.coprocessor.maxMetaDataCacheSize phoenix.coprocessor.maxServerCacheTimeToLiveMs phoenix.query.maxGlobalMemoryPercentage phoenix.query.maxServerCacheBytes but none of the above works. 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:171) at org.apache.phoenix.execute.HashJoinPlan.iterator(HashJoinPlan.java:121) at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:265) at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:255) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:254) at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1435) 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: java.sql.SQLException: java.util.concurrent.TimeoutException at org.apache.phoenix.cache.ServerCacheClient.addServerCache(ServerCacheClient.java:254) at org.apache.phoenix.join.HashCacheClient.addHashCache(HashCacheClient.java:83) at org.apache.phoenix.execute.HashJoinPlan$HashSubPlan.execute(HashJoinPlan.java:353) at org.apache.phoenix.execute.HashJoinPlan$1.call(HashJoinPlan.java:145) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask.run(JobManager.java:183) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: java.util.concurrent.TimeoutException at java.util.concurrent.FutureTask.get(FutureTask.java:201) at org.apache.phoenix.cache.ServerCacheClient.addServerCache(ServerCacheClient.java:246) ... 8 more -- This message was sent by Atlassian JIRA (v6.3.4#6332)