Sam, Collections can't be indexed in Ignite. You can easily implement CONTAINS function as you described, but as I mentioned, using it will trigger full scan.
Another option you have is to implement IndexingSpi and use SpiQuery to execute queries. But this will imply implementing indexing and querying logic from scratch, and you will not be able to use full SQL capabilities. My recommendation would be to split collection into separate collocated entries. -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Fetch-by-contains-on-a-field-as-Array-or-List-tp10276p10316.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.