also pls note that it only fails with tenant-specific connections

On Mon, Jul 6, 2015 at 7:17 PM, Alex Kamil <alex.kamil@gmail.com> wrote:
Maryann,

here is the query, I don't see warnings
SELECT '\''||C.ROWKEY||'\'' AS RK, C.VS FROM  test.table1 AS C JOIN (SELECT DISTINCT B.ROWKEY, B.VS FROM test.table2 AS B) B ON (C.ROWKEY=B.ROWKEY AND C.VS=B.VS) LIMIT 2147483647;

thanks
Alex

On Fri, Jul 3, 2015 at 10:36 PM, Maryann Xue <maryann.xue@gmail.com> wrote:
Hi Alex,

Most likely what happened was as suggested by the error message: the cache might have expired. Could you please check if there are any Phoenix warnings in the client log and share your query?



Thanks,
Maryann

On Fri, Jul 3, 2015 at 4:01 PM, Alex Kamil <alex.kamil@gmail.com> wrote:
getting this error with phoenix 3.3.0/hbase 0.94.15, any ideas?

org.apache.phoenix.exception.PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException: Could not find hash cache for joinId: ???Z^XI??. The cache might have expired 
and have been removed.                                                                                                                                                                                                         
        at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:96)                                                                                                                                         
        at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:511)                                                                                                                           
        at org.apache.phoenix.iterate.MergeSortResultIterator.getIterators(MergeSortResultIterator.java:48)                                                                                                                    
        at org.apache.phoenix.iterate.MergeSortResultIterator.minIterator(MergeSortResultIterator.java:84)                                                                                                                     
        at org.apache.phoenix.iterate.MergeSortResultIterator.next(MergeSortResultIterator.java:111)                                                                                                                           
        at org.apache.phoenix.iterate.DelegateResultIterator.next(DelegateResultIterator.java:44)                                                                                                                              
        at org.apache.phoenix.iterate.LimitingResultIterator.next(LimitingResultIterator.java:47)                                                                                                                              
        at org.apache.phoenix.iterate.DelegateResultIterator.next(DelegateResultIterator.java:44)                                                                                                                              
        at org.apache.phoenix.jdbc.PhoenixResultSet.next(PhoenixResultSet.java:739)                                                                                                                                            
        at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)

thanks
Alex