you always specify schema
explicitly in SQL query,
there is no difference in which one to use.
Thanks,
Stan
From: takumi
Sent: 8 марта 2018 г. 18:02
To: user@ignite.apache.org
Subject: RE: How to use SqlQuery for multi tables
I solved my self.
It was the cause that I didn't set to SqlSche
I solved my self.
It was the cause that I didn't set to SqlSchema of CacheConfigration.
Please tell me in connection with this.
I don't know which instance query() method should be called.
If it is an instance of the same schema, whichever one I am using will not
change?
--
Sent from: http://
Thank you for your reply.
In addition to this, I want to know how to use SqlFieldsQuery instead of
SqlQuery.
I would like you to teach me about that.
My code is here.
--
public class Main {
private static final String CACHE_NAME1 = "binaryCache1";
From: takumi
Sent: 7 марта 2018 г. 18:40
To: user@ignite.apache.org
Subject: How to use SqlQuery for multi tables
I want to use sql "select" from 2 caches.
For example.
SqlQuery sql = new SqlQuery(cache1, "select a.* from cache1 a, cache2 b
where a.id = b.id");
QueryCursor>
I want to use sql "select" from 2 caches.
For example.
SqlQuery sql = new SqlQuery(cache1, "select a.* from cache1 a, cache2 b
where a.id = b.id");
QueryCursor> results = cache.query(sql);
※ cache1, cache2 have BinaryObject Data.
I call QueryEntity#addQueryField("id", String.class.get