Hi, Use “_key” to access a key in an SQL query.
Updated the bottom of this documentation section: http://apacheignite.gridgain.org/v1.8/docs/sql-queries#query-types <http://apacheignite.gridgain.org/v1.8/docs/sql-queries#query-types> "Use _key and _value keywords in an SQL query in order to compare to an entry's complete key or value rather than to individual fields. Apply the same keywords if you need to return a key or a value as a result of an SQL query execution.” — Denis > On Feb 18, 2017, at 2:30 PM, diopek <[email protected]> wrote: > > What is the possible query API to do range query using cache key > For example, for the following cache > IgniteCache<Long, MyPOJO>, where key is Java Long and value is POJO, > > So, how can we retrieve all the Objects in a single API call using criteria > like; > > *' key >= 1 AND key <= 5000'* > > SqlQuery API provides capability to create SQL string by referring cache > value object fields by their Java attribute names in SQL string. So, is > there any default symbol like 'key' for Cache keys so that can be used in a > SQL String as above. Thanks, > > > > > > -- > View this message in context: > http://apache-ignite-users.70518.x6.nabble.com/Ignite-cache-range-query-using-cache-keys-tp10717.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com.
