Re: Search on a composite key

2019-01-21 Thread ihorps
hello to just sum it up here... I've found a page which describes some queering techniques (although it was under indexes section) - https://apacheignite-sql.readme.io/docs/schema-and-indexes. To make it run I needed to annotate my Key class like: public class Key { @QuerySqlField(index =

Re: Search on a composite key

2019-01-18 Thread Ilya Kasnacheev
. > > 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

Re: Search on a composite key

2019-01-18 Thread ihorps
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

Re: Search on a composite key

2019-01-18 Thread Mikhail
Hi Please read this doc: https://apacheignite.readme.io/docs/cache-queries this section describes exactly what you want. Thanks, Mike. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Search on a composite key

2019-01-18 Thread ihorps
hi all Could somebody advise me how to query properly from Ignite cache based on composite key condition? Let's say I have a key class: public class Key { private int countryId; private Date dateKey; ... } and a Value class: public class Value { private int value1; private boolean value2;