Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 613F4200C1F for ; Sat, 18 Feb 2017 23:30:22 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 5FD7C160B66; Sat, 18 Feb 2017 22:30:22 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id CE1E7160B55 for ; Sat, 18 Feb 2017 23:30:21 +0100 (CET) Received: (qmail 96868 invoked by uid 500); 18 Feb 2017 22:30:20 -0000 Mailing-List: contact user-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ignite.apache.org Delivered-To: mailing list user@ignite.apache.org Received: (qmail 96858 invoked by uid 99); 18 Feb 2017 22:30:20 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 18 Feb 2017 22:30:20 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 72CA6180A5A for ; Sat, 18 Feb 2017 22:30:20 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.174 X-Spam-Level: ** X-Spam-Status: No, score=2.174 tagged_above=-999 required=6.31 tests=[DKIM_ADSP_CUSTOM_MED=0.001, NML_ADSP_CUSTOM_MED=1.2, RCVD_IN_DNSWL_NONE=-0.0001, SPF_SOFTFAIL=0.972, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id 484_iI5pIZCu for ; Sat, 18 Feb 2017 22:30:19 +0000 (UTC) Received: from mbob.nabble.com (mbob.nabble.com [162.253.133.15]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id 31AD25F3FF for ; Sat, 18 Feb 2017 22:30:19 +0000 (UTC) Received: from static.162.255.23.37.macminivault.com (unknown [162.255.23.37]) by mbob.nabble.com (Postfix) with ESMTP id 9CE0F3D06F4B for ; Sat, 18 Feb 2017 14:09:05 -0800 (PST) Date: Sat, 18 Feb 2017 15:30:17 -0700 (MST) From: diopek To: user@ignite.apache.org Message-ID: <1487457017208-10717.post@n6.nabble.com> Subject: Ignite cache range query using cache keys MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit archived-at: Sat, 18 Feb 2017 22:30:22 -0000 What is the possible query API to do range query using cache key For example, for the following cache IgniteCache, 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.