hbase中使用phoenix 联表查询时报错: Could not find hash cache for joinId: R�:r�y��. The cache might have expired and have been removed

其原因是因为服务器端缓存的最大生存时间过期,需要更改phoenix配置文件并重启:

// 根据实际的配置文件位置
vim /opt/smr/phoenix/bin/hbase-site.xml

configuration里添加phoenix.coprocessor.maxServerCacheTimeToLiveMsphoenix.coprocessor.maxMetaDataCacheTimeToLiveMs配置项

<configuration>
<property>
  <name>phoenix.coprocessor.maxServerCacheTimeToLiveMs</name>
  <value>1800000</value>
</property>
<property>
  <name>phoenix.coprocessor.maxMetaDataCacheTimeToLiveMs</name>
  <value>1800000</value>
</property> 
</configuration>

重启phoenix即可

happy coding!