Return-Path: X-Original-To: apmail-ignite-user-archive@minotaur.apache.org Delivered-To: apmail-ignite-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A30FC18BD1 for ; Fri, 23 Oct 2015 07:58:32 +0000 (UTC) Received: (qmail 20888 invoked by uid 500); 23 Oct 2015 07:58:32 -0000 Delivered-To: apmail-ignite-user-archive@ignite.apache.org Received: (qmail 20845 invoked by uid 500); 23 Oct 2015 07:58:32 -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 20836 invoked by uid 99); 23 Oct 2015 07:58:32 -0000 Received: from mail-relay.apache.org (HELO mail-relay.apache.org) (140.211.11.15) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 Oct 2015 07:58:32 +0000 Received: from mail-ob0-f175.google.com (mail-ob0-f175.google.com [209.85.214.175]) by mail-relay.apache.org (ASF Mail Server at mail-relay.apache.org) with ESMTPSA id 2C8131A0181 for ; Fri, 23 Oct 2015 07:58:32 +0000 (UTC) Received: by obctp1 with SMTP id tp1so60712822obc.2 for ; Fri, 23 Oct 2015 00:58:31 -0700 (PDT) X-Gm-Message-State: ALoCoQm5fYipBiBMHpb4XPsUVH9oSu9FhZKwOG1qSPgqxjRman/PfsrFbd00MYDaizUr4NlDQa/f X-Received: by 10.182.91.80 with SMTP id cc16mr13862092obb.19.1445587111277; Fri, 23 Oct 2015 00:58:31 -0700 (PDT) MIME-Version: 1.0 Received: by 10.202.223.67 with HTTP; Fri, 23 Oct 2015 00:57:51 -0700 (PDT) In-Reply-To: <3158fb9.9c88.150936d62b3.Coremail.xeseo@163.com> References: <24889b5f.32cb.150599d173f.Coremail.xeseo@163.com> <1444707676042-1597.post@n6.nabble.com> <3158fb9.9c88.150936d62b3.Coremail.xeseo@163.com> From: Dmitriy Setrakyan Date: Fri, 23 Oct 2015 00:57:51 -0700 Message-ID: Subject: Re: Using different SQL to load cache every time? To: user Content-Type: multipart/alternative; boundary=e89a8fb200b442950b0522c0fa99 --e89a8fb200b442950b0522c0fa99 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I am a bit confused with the question. In the subject it says =E2=80=9Cload= cache=E2=80=9D, but in the body it says =E2=80=9Cquery cache=E2=80=9D. If the question is about =E2=80=9Cloading cache", then, as Sergi suggested,= you need to implement your own CacheStore. You can take any of the cache stores already provided and adapt them for your needs. More on CacheStore here: https://apacheignite.readme.io/docs/persistent-store If the question is about =E2=80=9Cquerying cache=E2=80=9D in memory, then y= ou can create SQL queries dynamically on the fly and execute them over Ignite data grid. More on SQL here: https://apacheignite.readme.io/docs/sql-queries D. On Thu, Oct 22, 2015 at 11:40 PM, Edison wrote: > Hi, > > Instead of given the SQL in EntryMapping, is it possible to use dynamic > SQL to query the cache every time? > If yes, how? > > Thanks, > > > > --e89a8fb200b442950b0522c0fa99 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I am a bit confused with the question. In the subject= it says =E2=80=9Cload cache=E2=80=9D, but in the body it says =E2=80=9Cque= ry cache=E2=80=9D.

If the question is about =E2=80= =9Cloading cache", then, as Sergi suggested, you need to implement you= r own CacheStore. You can take any of the cache stores already provided and= adapt them for your needs. More on CacheStore here:=C2=A0https://apacheignite.readme= .io/docs/persistent-store

If the question is a= bout =E2=80=9Cquerying cache=E2=80=9D in memory, then you can create SQL qu= eries dynamically on the fly and execute them over Ignite data grid. More o= n SQL here:=C2=A0https://apacheignite.readme.io/docs/sql-queries

D.

On Thu, Oc= t 22, 2015 at 11:40 PM, Edison <xeseo@163.com> wrote:
Hi,

Instead of giv= en the SQL in EntryMapping, is it possible to use dynamic SQL to query the = cache every time?=C2=A0
If yes, how?

Tha= nks,


=C2=A0

<= /blockquote>

--e89a8fb200b442950b0522c0fa99--