RE: How to use SqlQuery for multi tables

2018-03-08 Thread Stanislav Lukyanov
or if 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 SqlSchema

RE: How to use SqlQuery for multi tables

2018-03-08 Thread takumi
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:

RE: How to use SqlQuery for multi tables

2018-03-08 Thread takumi
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";

RE: How to use SqlQuery for multi tables

2018-03-08 Thread Stanislav Lukyanov
Hi, When you create a cache via Java API you provide a value type to the QueryEntity. Then the table name for SQL queries will have a form .. Can you share the code that you use to create the caches? Then it would be easier to tell what will be the exact names of the tables. Thanks, Stan