phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alex Kamil <alex.ka...@gmail.com>
Subject Re: Could not find hash cache for joinId
Date Mon, 06 Jul 2015 23:17:39 GMT
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
>>
>
>

Mime
View raw message