【异常】Caused by: org.apache.phoenix.coprocessor.HashJoinCacheNotFoundException:

1 详细异常

Caused by: org.apache.phoenix.coprocessor.HashJoinCacheNotFoundException: ERROR 900 (HJ01): 
Hash Join cache not found joinId: 948789376099633279. The cache might have expired and have been removed.

　　

2 查询到的一些信息

https://community.hortonworks.com/questions/149867/orgapachephoenixcoprocessorhashjoincachenotfoundex.html

里面提到增加regionserver的这个参数来解决问题

phoenix.coprocessor.maxServerCacheTimeToLiveMs

 

3 然后修改参数，重启hbase

 

<property>

<name>phoenix.coprocessor.maxServerCacheTimeToLiveMs</name>

<value>300000000</value>

   </property> 

 

4 并且更新本地client的hbase-site.xml文件，再次查询解决问题