Hi Dharam, Geode does not support a multi iterator index with overflow (Bullet point two indexes with overflow <http://geode.apache.org/docs/guide/developing/query_index/indexes_with_overflow_regions.html#concept_87BE7DB32C714EB0BF7532AF93569328>). Single iterator indexes are allowed but the multi iterator ends up creating references to the actual values. This defeats the purpose of overflow and instead of causing confusion when overflowing doesn't have the desired result with indexes, we just prevent it from happening.
-Jason On Mon, Dec 19, 2016 at 3:33 AM Thacker, Dharam <[email protected]> wrote: > Hi Team, > > > > Could you guide me on how to manage eviction with replicated region having > functional indexes? I have complex object graph and OQL refers to nested > collection object as well in where condition. For the same reason, I have > defined function indexes with replicated region. I have also set eviction > policy with HEAP_PERCENTAGE and action as OVERFLOW_TO_DISK. > > > > *Example:* > > > > <geode:index id=*"a_b_indx"* expression=*"c.remoteId"* from=*"/A > i,i.remotes c"* cache-ref=*"geodeCache"* type=*"FUNCTIONAL"*/> > > > > > > I am getting an exception indicating, such kind of indexes are not > supported with overflow region. Is there any reason for such limitation? > Such indexes on nested collection fields are most common according to me. > > > > Thanks & Regards, > > Dharam > > > > This email is confidential and subject to important disclaimers and > conditions including on offers for the purchase or sale of securities, > accuracy and completeness of information, viruses, confidentiality, legal > privilege, and legal entity disclaimers, available at > http://www.jpmorgan.com/pages/disclosures/email >
