Hello! SQL can filter (and query) fields from both keys and values and there should be examples on readme.io.
Just make sure you have a secondary index on this field. Regards, -- Ilya Kasnacheev пт, 18 янв. 2019 г. в 19:08, ihorps <[email protected]>: > hi Mikhail > > Thank you for your response. > > Yes, I've read the documentation (provided in your link) before I posted > the > message here but somehow I understood that there are two ways to search on > composite key: > 1. Scan Queries - does the job but doesn't look efficient enough such as it > we have to iterate through all keys to match some condition on that > composed > key > 2. SQL Queries (https://apacheignite-sql.readme.io/docs/java-sql-api) - > does > the job but example here contains only search on value object. And if I > need > to search through keys I need to put a reference to a key for there value > objects (this is what I want to avoid for now). Something like it was > described here - > > http://apache-ignite-users.70518.x6.nabble.com/Composite-key-as-Ignite-key-and-its-should-be-queryable-td24313.html. > > > So I thought if there is an option in Apache Ignite where I can run on a > cache some predicate for its composite keys, which on their own could be > indexed on some property to gain a performance against linear iteration > through all of them. > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
