I have that part, what I dont understand is how I can create multiple
"Tables" within a Cache(Schema)? I have the following code that is using a
simple Employee Class.
IgniteCache<Object, Object> testCache =
ignite.getOrCreateCache(new CacheConfiguration<>("MAIN")
.setIndexedTypes(Long.class, Employee.class)
.setQueryEntities(Collections.singleton(
new QueryEntity(Integer.class,
String.class).setTableName("EMPLOYEE"))));
Employee e = new Employee(1, "Test", 123.34f, 3);
try (IgniteDataStreamer<Long, Employee> ds =
ignite.dataStreamer("MAIN")) {
ds.addData(1l, e);
}
how would one go about adding a second "Table" to the MAIN cache so that it
is queryable from DBeaver or other tools?
On Wed, Mar 20, 2019 at 4:29 AM Ilya Kasnacheev <ilya.kasnach...@gmail.com>
wrote:
> Hello!
>
> Please take a look at
> https://apacheignite.readme.io/docs/cache-queries#section-query-configuration-by-annotations
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> вт, 19 мар. 2019 г. в 20:25, Mike Needham <needb...@gmail.com>:
>
>> Do you have an example of how that could be done. I am struggling to
>> figure out how to set this up.
>>
>> On Mon, Mar 18, 2019 at 2:00 AM Ilya Kasnacheev <
>> ilya.kasnach...@gmail.com> wrote:
>>
>>> Hello!
>>>
>>> The best approach is to use .setIndexedTypes() instead of
>>> setQueryEntities(), and annotate complex types in question with
>>> @QuerySqlField.
>>> This way you can then pour those types into cache and it will work
>>> transparently.
>>>
>>> Regards,
>>> --
>>> Ilya Kasnacheev
>>>
>>>
>>> пт, 15 мар. 2019 г. в 18:28, Mike Needham <needb...@gmail.com>:
>>>
>>>> Perfect, now the next question is how would you do this for a more
>>>> complex object/table? Either one defined in a separate object or via SQL
>>>> DDL?
>>>>
>>>> On Fri, Mar 15, 2019 at 9:05 AM Ilya Kasnacheev <
>>>> ilya.kasnach...@gmail.com> wrote:
>>>>
>>>>> Hello!
>>>>>
>>>>> You will have to specify schema name (or cache name?) in ALLCAPS when
>>>>> creating cache.
>>>>>
>>>>> Regards,
>>>>> --
>>>>> Ilya Kasnacheev
>>>>>
>>>>>
>>>>> пт, 15 мар. 2019 г. в 16:45, Mike Needham <needb...@gmail.com>:
>>>>>
>>>>>> I see. did not have the "person" for the schema. Is there a way to
>>>>>> not have the quotes around that?
>>>>>>
>>>>>> On Fri, Mar 15, 2019 at 7:59 AM ilya.kasnacheev <
>>>>>> ilya.kasnach...@gmail.com> wrote:
>>>>>>
>>>>>>> Hello!
>>>>>>>
>>>>>>> Definitely works for me in DBeaver with this exact code:
>>>>>>>
>>>>>>> <
>>>>>>> http://apache-ignite-users.70518.x6.nabble.com/file/t1312/dbeaver-tables.png>
>>>>>>>
>>>>>>>
>>>>>>> Some of DBeaver's introspection does not work but statements are
>>>>>>> solid.
>>>>>>>
>>>>>>> Regards,
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> *Some days it just not worth chewing through the restraints*
>>>>>>
>>>>>
>>>>
>>>> --
>>>> *Some days it just not worth chewing through the restraints*
>>>>
>>>
>>
>> --
>> *Some days it just not worth chewing through the restraints*
>>
>
--
*Some days it just not worth chewing through the restraints*
