Re: Access a cache loaded by DataStreamer with SQL

[Ilya Kasnacheev]

Hello!

I think you need to have different types for keys too.

Regards,
-- 
Ilya Kasnacheev


ср, 20 мар. 2019 г. в 21:00, Mike Needham :

> I guess I am not understanding how to build this for multiple tables in a
> cache that can be loaded using the datastreamer and are queryable from
> DBeaver or tableau.
>
> I changed the code to be
>
>  IgniteCache testCache =
> ignite.getOrCreateCache(new CacheConfiguration<>("MAIN")
> .setIndexedTypes(Long.class, Employee.class)
> .setIndexedTypes(Long.class, Department.class)
> );
> Employee e = new Employee(1, "Test", 123.34f, 3);
> try (IgniteDataStreamer ds =
> ignite.dataStreamer("MAIN")) {
> ds.addData(1l, e);
> }
> Department d = new Department(1, "Main", 12, 3);
> try (IgniteDataStreamer ds2 =
> ignite.dataStreamer("MAIN")) {
> ds2.addData(1l, d);
> }
>
>
>
> which created the two in the cache, but does not load anything to the
> department table.
>
> On Wed, Mar 20, 2019 at 10:01 AM Ilya Kasnacheev <
> ilya.kasnach...@gmail.com> wrote:
>
>> Hello!
>>
>> I don't understand what you are doing here. Why do you have two employee
>> tables here? What is desired table structure?
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> ср, 20 мар. 2019 г. в 16:44, Mike Needham :
>>
>>> 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 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 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 :

> 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 :
>>
>>> 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 :

> 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*
>>>
>>
>
> --
> *Some days it just not worth chewing through the 

Re: Access a cache loaded by DataStreamer with SQL

[Mike Needham]

I guess I am not understanding how to build this for multiple tables in a
cache that can be loaded using the datastreamer and are queryable from
DBeaver or tableau.

I changed the code to be

 IgniteCache testCache =
ignite.getOrCreateCache(new CacheConfiguration<>("MAIN")
.setIndexedTypes(Long.class, Employee.class)
.setIndexedTypes(Long.class, Department.class)
);
Employee e = new Employee(1, "Test", 123.34f, 3);
try (IgniteDataStreamer ds =
ignite.dataStreamer("MAIN")) {
ds.addData(1l, e);
}
Department d = new Department(1, "Main", 12, 3);
try (IgniteDataStreamer ds2 =
ignite.dataStreamer("MAIN")) {
ds2.addData(1l, d);
}



which created the two in the cache, but does not load anything to the
department table.

On Wed, Mar 20, 2019 at 10:01 AM Ilya Kasnacheev 
wrote:

> Hello!
>
> I don't understand what you are doing here. Why do you have two employee
> tables here? What is desired table structure?
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> ср, 20 мар. 2019 г. в 16:44, Mike Needham :
>
>> 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 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 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 :
>>>
 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 :
>
>> 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 :
>>>
 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*
>>
>

-- 
*Some days it just not worth chewing through the restraints*

Re: Access a cache loaded by DataStreamer with SQL

[Ilya Kasnacheev]

Hello!

I don't understand what you are doing here. Why do you have two employee
tables here? What is desired table structure?

Regards,
-- 
Ilya Kasnacheev


ср, 20 мар. 2019 г. в 16:44, Mike Needham :

> 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 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 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 
> 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 :
>>
>>> 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 :

> 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 :
>>
>>> 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*
>

Re: Access a cache loaded by DataStreamer with SQL

[Mike Needham]

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 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 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 
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 :
>
>> 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 :
>>>
 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 :
>
>> 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*

Re: Access a cache loaded by DataStreamer with SQL

[Ilya Kasnacheev]

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 :

> 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 
> 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 :
>>
>>> 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 :

> 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*
>

Re: Access a cache loaded by DataStreamer with SQL

[Mike Needham]

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 
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 :
>
>> 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 :
>>>
 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*

Re: Access a cache loaded by DataStreamer with SQL

[Ilya Kasnacheev]

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 :

> 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 
> 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 :
>>
>>> 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*
>

Re: Access a cache loaded by DataStreamer with SQL

[Mike Needham]

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 
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 :
>
>> 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*

Re: Access a cache loaded by DataStreamer with SQL

[Ilya Kasnacheev]

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 :

> 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 
> 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*
>

Re: Access a cache loaded by DataStreamer with SQL

[Mike Needham]

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 
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*

Re: Access a cache loaded by DataStreamer with SQL

[ilya.kasnacheev]

Hello!

Definitely works for me in DBeaver with this exact code:

 

Some of DBeaver's introspection does not work but statements are solid.

Regards,



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Access a cache loaded by DataStreamer with SQL

[Mike Needham]

OK, that appears to be part of the way, but they caches are not queryable
from any SQL tools like Tableau or DBeaver.  What am i missing?

On Fri, Mar 15, 2019 at 5:29 AM Ilya Kasnacheev 
wrote:

> Hello!
>
> Yes, I understand your confusuion here.
>
> Take a look at following elaborate snippet:
>
> package org.apache.ignite.examples;
> import java.util.Collections;
> import java.util.LinkedHashMap;
> import org.apache.ignite.Ignite;
> import org.apache.ignite.IgniteCache;
> import org.apache.ignite.IgniteDataStreamer;
> import org.apache.ignite.Ignition;
> import org.apache.ignite.cache.QueryEntity;
> import org.apache.ignite.cache.query.SqlFieldsQuery;
> import org.apache.ignite.configuration.CacheConfiguration;
>
> public class LoadTableWithDataStreamer {
> public static void main(String[] args) {
> try (Ignite ignite = Ignition.start()) {
> IgniteCache personCache = 
> ignite.getOrCreateCache(new CacheConfiguration<>("person")
> .setQueryEntities(Collections.singleton(
> new QueryEntity(Integer.class, 
> String.class).setTableName("person_table";
>
> IgniteCache placeCache = 
> ignite.getOrCreateCache(new CacheConfiguration<>("place")
> .setQueryEntities(Collections.singleton(
> new QueryEntity(Integer.class, 
> String.class).setTableName("place_table")
> // more decoration
> .setKeyFieldName("id").setValueFieldName("name")
> .setFields(new LinkedHashMap() {{
> // Note that extending LinkedHashMap isn't 
> production-ready
> put("id", Integer.class.getCanonicalName());
> put("name", String.class.getCanonicalName());
> }};
>
> try (IgniteDataStreamer ds = 
> ignite.dataStreamer("person")) {
> ds.addData(1, "John");
> }
>
> try (IgniteDataStreamer ds = 
> ignite.dataStreamer("place")) {
> ds.addData(1, "Siberia");
> }
>
> System.err.println("Query result");
> personCache.query(new SqlFieldsQuery("select _key, _val from 
> person_table")).getAll().forEach(System.err::println);
>
> // refer to different cache's table
> personCache.query(new SqlFieldsQuery("select id, name from 
> \"place\".place_table")).getAll().forEach(System.err::println);
> }
> }
> }
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> чт, 14 мар. 2019 г. в 22:59, Mike Needham :
>
>> Hi,
>>
>> Here is the code I am using
>>
>> package org.apache.ignite.examples;
>> import java.util.Collections;
>> import org.apache.ignite.Ignite;
>> import org.apache.ignite.IgniteCache;
>> import org.apache.ignite.IgniteDataStreamer;
>> import org.apache.ignite.Ignition;
>> import org.apache.ignite.cache.QueryEntity;
>> import org.apache.ignite.cache.query.SqlFieldsQuery;
>> import org.apache.ignite.configuration.CacheConfiguration;
>> import org.apache.ignite.configuration.IgniteConfiguration;
>>
>> public class LoadTableWithDataStreamer {
>> public static void main(String[] args) {
>> try (Ignite ignite =
>> Ignition.start("E:\\ignite\\apache-ignite-2.7.0-src\\examples\\config\\example-ignite.xml"))
>> {
>> IgniteCache personCache =
>> ignite.getOrCreateCache(new CacheConfiguration<>("PUBLIC")
>> .setQueryEntities(Collections.singleton(
>> new QueryEntity(Integer.class,
>> String.class).setTableName("person_table";
>>
>> IgniteCache placeCache =
>> ignite.getOrCreateCache(new CacheConfiguration<>("PUBLIC")
>> .setQueryEntities(Collections.singleton(
>> new QueryEntity(Integer.class,
>> String.class).setTableName("place_table";
>> try (IgniteDataStreamer ds =
>> ignite.dataStreamer("person")) {
>> ds.addData(1, "John");
>> }
>>
>> System.err.println("Query result");
>> personCache.query(new SqlFieldsQuery("select * from
>> person_table")).getAll().forEach(System.err::println);
>> }
>> }
>> }
>>
>> I want to create to queryable tables that I can load using the data
>> streamer.  The config is the default config in the java examples
>>
>>
>> On Mon, Mar 11, 2019 at 3:06 AM Ilya Kasnacheev <
>> ilya.kasnach...@gmail.com> wrote:
>>
>>> Hello!
>>>
>>> Can you perhaps post your config and code? Much easier than writing my
>>> own boilerplate.
>>>
>>> Regards,
>>> --
>>> Ilya Kasnacheev
>>>
>>>
>>> пт, 8 мар. 2019 г. в 00:36, Mike Needham :
>>>
 Would it be possible for someone to provide a sample that uses the
 DataStreamer for multiple large caches and the resulting caches are
 queryable from ODBC tools like Tableau and DBeaver?  I can get one to work,
 but cannot get the cache naming to work for a second one.

 On Thu, Mar 7, 2019 at 7:53 AM Ilya Kasnacheev 

Re: Access a cache loaded by DataStreamer with SQL

[Ilya Kasnacheev]

Hello!

Yes, I understand your confusuion here.

Take a look at following elaborate snippet:

package org.apache.ignite.examples;
import java.util.Collections;
import java.util.LinkedHashMap;
import org.apache.ignite.Ignite;
import org.apache.ignite.IgniteCache;
import org.apache.ignite.IgniteDataStreamer;
import org.apache.ignite.Ignition;
import org.apache.ignite.cache.QueryEntity;
import org.apache.ignite.cache.query.SqlFieldsQuery;
import org.apache.ignite.configuration.CacheConfiguration;

public class LoadTableWithDataStreamer {
public static void main(String[] args) {
try (Ignite ignite = Ignition.start()) {
IgniteCache personCache =
ignite.getOrCreateCache(new CacheConfiguration<>("person")
.setQueryEntities(Collections.singleton(
new QueryEntity(Integer.class,
String.class).setTableName("person_table";

IgniteCache placeCache =
ignite.getOrCreateCache(new CacheConfiguration<>("place")
.setQueryEntities(Collections.singleton(
new QueryEntity(Integer.class,
String.class).setTableName("place_table")
// more decoration
.setKeyFieldName("id").setValueFieldName("name")
.setFields(new LinkedHashMap() {{
// Note that extending LinkedHashMap isn't production-ready
put("id", Integer.class.getCanonicalName());
put("name", String.class.getCanonicalName());
}};

try (IgniteDataStreamer ds =
ignite.dataStreamer("person")) {
ds.addData(1, "John");
}

try (IgniteDataStreamer ds =
ignite.dataStreamer("place")) {
ds.addData(1, "Siberia");
}

System.err.println("Query result");
personCache.query(new SqlFieldsQuery("select _key, _val
from person_table")).getAll().forEach(System.err::println);

// refer to different cache's table
personCache.query(new SqlFieldsQuery("select id, name from
\"place\".place_table")).getAll().forEach(System.err::println);
}
}
}

Regards,
-- 
Ilya Kasnacheev


чт, 14 мар. 2019 г. в 22:59, Mike Needham :

> Hi,
>
> Here is the code I am using
>
> package org.apache.ignite.examples;
> import java.util.Collections;
> import org.apache.ignite.Ignite;
> import org.apache.ignite.IgniteCache;
> import org.apache.ignite.IgniteDataStreamer;
> import org.apache.ignite.Ignition;
> import org.apache.ignite.cache.QueryEntity;
> import org.apache.ignite.cache.query.SqlFieldsQuery;
> import org.apache.ignite.configuration.CacheConfiguration;
> import org.apache.ignite.configuration.IgniteConfiguration;
>
> public class LoadTableWithDataStreamer {
> public static void main(String[] args) {
> try (Ignite ignite =
> Ignition.start("E:\\ignite\\apache-ignite-2.7.0-src\\examples\\config\\example-ignite.xml"))
> {
> IgniteCache personCache =
> ignite.getOrCreateCache(new CacheConfiguration<>("PUBLIC")
> .setQueryEntities(Collections.singleton(
> new QueryEntity(Integer.class,
> String.class).setTableName("person_table";
>
> IgniteCache placeCache =
> ignite.getOrCreateCache(new CacheConfiguration<>("PUBLIC")
> .setQueryEntities(Collections.singleton(
> new QueryEntity(Integer.class,
> String.class).setTableName("place_table";
> try (IgniteDataStreamer ds =
> ignite.dataStreamer("person")) {
> ds.addData(1, "John");
> }
>
> System.err.println("Query result");
> personCache.query(new SqlFieldsQuery("select * from
> person_table")).getAll().forEach(System.err::println);
> }
> }
> }
>
> I want to create to queryable tables that I can load using the data
> streamer.  The config is the default config in the java examples
>
>
> On Mon, Mar 11, 2019 at 3:06 AM Ilya Kasnacheev 
> wrote:
>
>> Hello!
>>
>> Can you perhaps post your config and code? Much easier than writing my
>> own boilerplate.
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> пт, 8 мар. 2019 г. в 00:36, Mike Needham :
>>
>>> Would it be possible for someone to provide a sample that uses the
>>> DataStreamer for multiple large caches and the resulting caches are
>>> queryable from ODBC tools like Tableau and DBeaver?  I can get one to work,
>>> but cannot get the cache naming to work for a second one.
>>>
>>> On Thu, Mar 7, 2019 at 7:53 AM Ilya Kasnacheev <
>>> ilya.kasnach...@gmail.com> wrote:
>>>
 Hello!

 JDBC with SET STREAMING ON should work reasonably well. You could also
 use CacheStore.

 With .Net I guess you will have to stick to DataStreamer & learn how to
 integrate it with Indexing properly. Or use JDBC from .Net.

 Regards,
 --
 Ilya Kasnacheev


 чт, 7 мар. 2019 г. в 16:31, Mike Needham :

> 

Re: Access a cache loaded by DataStreamer with SQL

[Mike Needham]

Hi,

Here is the code I am using

package org.apache.ignite.examples;
import java.util.Collections;
import org.apache.ignite.Ignite;
import org.apache.ignite.IgniteCache;
import org.apache.ignite.IgniteDataStreamer;
import org.apache.ignite.Ignition;
import org.apache.ignite.cache.QueryEntity;
import org.apache.ignite.cache.query.SqlFieldsQuery;
import org.apache.ignite.configuration.CacheConfiguration;
import org.apache.ignite.configuration.IgniteConfiguration;

public class LoadTableWithDataStreamer {
public static void main(String[] args) {
try (Ignite ignite =
Ignition.start("E:\\ignite\\apache-ignite-2.7.0-src\\examples\\config\\example-ignite.xml"))
{
IgniteCache personCache =
ignite.getOrCreateCache(new CacheConfiguration<>("PUBLIC")
.setQueryEntities(Collections.singleton(
new QueryEntity(Integer.class,
String.class).setTableName("person_table";

IgniteCache placeCache =
ignite.getOrCreateCache(new CacheConfiguration<>("PUBLIC")
.setQueryEntities(Collections.singleton(
new QueryEntity(Integer.class,
String.class).setTableName("place_table";
try (IgniteDataStreamer ds =
ignite.dataStreamer("person")) {
ds.addData(1, "John");
}

System.err.println("Query result");
personCache.query(new SqlFieldsQuery("select * from
person_table")).getAll().forEach(System.err::println);
}
}
}

I want to create to queryable tables that I can load using the data
streamer.  The config is the default config in the java examples


On Mon, Mar 11, 2019 at 3:06 AM Ilya Kasnacheev 
wrote:

> Hello!
>
> Can you perhaps post your config and code? Much easier than writing my own
> boilerplate.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> пт, 8 мар. 2019 г. в 00:36, Mike Needham :
>
>> Would it be possible for someone to provide a sample that uses the
>> DataStreamer for multiple large caches and the resulting caches are
>> queryable from ODBC tools like Tableau and DBeaver?  I can get one to work,
>> but cannot get the cache naming to work for a second one.
>>
>> On Thu, Mar 7, 2019 at 7:53 AM Ilya Kasnacheev 
>> wrote:
>>
>>> Hello!
>>>
>>> JDBC with SET STREAMING ON should work reasonably well. You could also
>>> use CacheStore.
>>>
>>> With .Net I guess you will have to stick to DataStreamer & learn how to
>>> integrate it with Indexing properly. Or use JDBC from .Net.
>>>
>>> Regards,
>>> --
>>> Ilya Kasnacheev
>>>
>>>
>>> чт, 7 мар. 2019 г. в 16:31, Mike Needham :
>>>
 Is that the most efficient way to load millions of rows from a database
 table into a cache? I guess I am not seeing how this would work for
 millions of rows in the source database.  That also appears to be a JAVA
 only solution and it would be preferable to have it be usable for .NET as
 well as java and hopefully python.

 On Thu, Mar 7, 2019 at 6:55 AM Ilya Kasnacheev <
 ilya.kasnach...@gmail.com> wrote:

> Hello!
>
> What prevents you from reading rows from DB and feeding them to JDBC
> prepared statement?
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> чт, 7 мар. 2019 г. в 15:51, Mike Needham :
>
>> And what if the data is already in a database table?  I do not want
>> to read from the table to write to a file to load a cache.
>>
>> On Tue, Mar 5, 2019 at 4:06 AM Ilya Kasnacheev <
>> ilya.kasnach...@gmail.com> wrote:
>>
>>> Hello!
>>>
>>> The preferred approach is to use Thin JDBC client:
>>> https://apacheignite-sql.readme.io/docs/jdbc-driver
>>>
>>> Regards,
>>> --
>>> Ilya Kasnacheev
>>>
>>>
>>> пн, 4 мар. 2019 г. в 19:39, Mike Needham :
>>>
 Thanks for the links,  If SET STREAMING ON is the preferred method,
 how would you do this in code rather than from a file with all the 
 insert
 statements.

 On Mon, Mar 4, 2019 at 1:44 AM Ilya Kasnacheev <
 ilya.kasnach...@gmail.com> wrote:

> Hello!
>
> You can see at this page:
> https://apacheignite-sql.readme.io/docs/sql-and-key-value-usage
>
> And then substitite cache.put() with addData() and cache name will
> be SQL_PUBLIC_{table name in caps}
>
> There are not many examples since this is being discouraged in
> favor of SET STREAMING ON, actually:
> https://apacheignite-sql.readme.io/docs/set
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> пт, 1 мар. 2019 г. в 22:48, Mike Needham :
>
>> I have looked at the documentation and the code samples and
>> nothing is doing what I am trying to do.  I want to be able to use 
>> the
>> datastreamer to load 3 or 4 TABLES in a cache for an application 
>> that we
>> use. 

Re: Access a cache loaded by DataStreamer with SQL

[Ilya Kasnacheev]

Hello!

Can you perhaps post your config and code? Much easier than writing my own
boilerplate.

Regards,
-- 
Ilya Kasnacheev


пт, 8 мар. 2019 г. в 00:36, Mike Needham :

> Would it be possible for someone to provide a sample that uses the
> DataStreamer for multiple large caches and the resulting caches are
> queryable from ODBC tools like Tableau and DBeaver?  I can get one to work,
> but cannot get the cache naming to work for a second one.
>
> On Thu, Mar 7, 2019 at 7:53 AM Ilya Kasnacheev 
> wrote:
>
>> Hello!
>>
>> JDBC with SET STREAMING ON should work reasonably well. You could also
>> use CacheStore.
>>
>> With .Net I guess you will have to stick to DataStreamer & learn how to
>> integrate it with Indexing properly. Or use JDBC from .Net.
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> чт, 7 мар. 2019 г. в 16:31, Mike Needham :
>>
>>> Is that the most efficient way to load millions of rows from a database
>>> table into a cache? I guess I am not seeing how this would work for
>>> millions of rows in the source database.  That also appears to be a JAVA
>>> only solution and it would be preferable to have it be usable for .NET as
>>> well as java and hopefully python.
>>>
>>> On Thu, Mar 7, 2019 at 6:55 AM Ilya Kasnacheev <
>>> ilya.kasnach...@gmail.com> wrote:
>>>
 Hello!

 What prevents you from reading rows from DB and feeding them to JDBC
 prepared statement?

 Regards,
 --
 Ilya Kasnacheev


 чт, 7 мар. 2019 г. в 15:51, Mike Needham :

> And what if the data is already in a database table?  I do not want to
> read from the table to write to a file to load a cache.
>
> On Tue, Mar 5, 2019 at 4:06 AM Ilya Kasnacheev <
> ilya.kasnach...@gmail.com> wrote:
>
>> Hello!
>>
>> The preferred approach is to use Thin JDBC client:
>> https://apacheignite-sql.readme.io/docs/jdbc-driver
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> пн, 4 мар. 2019 г. в 19:39, Mike Needham :
>>
>>> Thanks for the links,  If SET STREAMING ON is the preferred method,
>>> how would you do this in code rather than from a file with all the 
>>> insert
>>> statements.
>>>
>>> On Mon, Mar 4, 2019 at 1:44 AM Ilya Kasnacheev <
>>> ilya.kasnach...@gmail.com> wrote:
>>>
 Hello!

 You can see at this page:
 https://apacheignite-sql.readme.io/docs/sql-and-key-value-usage

 And then substitite cache.put() with addData() and cache name will
 be SQL_PUBLIC_{table name in caps}

 There are not many examples since this is being discouraged in
 favor of SET STREAMING ON, actually:
 https://apacheignite-sql.readme.io/docs/set

 Regards,
 --
 Ilya Kasnacheev


 пт, 1 мар. 2019 г. в 22:48, Mike Needham :

> I have looked at the documentation and the code samples and
> nothing is doing what I am trying to do.  I want to be able to use the
> datastreamer to load 3 or 4 TABLES in a cache for an application that 
> we
> use.  If I create the tables using a create table syntax how do 
> attach a
> datastreamer to the different caches if the cache name is PUBLIC for 
> all of
> them?
>
> On Thu, Feb 28, 2019 at 8:13 AM Ilya Kasnacheev <
> ilya.kasnach...@gmail.com> wrote:
>
>> Hello!
>>
>> I have linked the documentation page, there are also some code
>> examples in distribution.
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> чт, 28 февр. 2019 г. в 17:10, Mike Needham :
>>
>>> Is there any examples that show the steps to do this correctly?
>>> I stumbled upon this but have no idea if it is the best way to do 
>>> this
>>>
>>> On Thu, Feb 28, 2019 at 6:27 AM Ilya Kasnacheev <
>>> ilya.kasnach...@gmail.com> wrote:
>>>
 Hello!

 There's no restriction on cache name but setting it up for the
 first time may be tricky indeed.

 Regards,
 --
 Ilya Kasnacheev


 ср, 27 февр. 2019 г. в 19:48, needbrew99 :

> OK, was able to get it working.  Apparently the cache name has
> to be PUBLIC
> and it will create a table based on the object definition that
> I have.
>
>
>
> --
> 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 

Re: Access a cache loaded by DataStreamer with SQL

[Mike Needham]

Would it be possible for someone to provide a sample that uses the
DataStreamer for multiple large caches and the resulting caches are
queryable from ODBC tools like Tableau and DBeaver?  I can get one to work,
but cannot get the cache naming to work for a second one.

On Thu, Mar 7, 2019 at 7:53 AM Ilya Kasnacheev 
wrote:

> Hello!
>
> JDBC with SET STREAMING ON should work reasonably well. You could also use
> CacheStore.
>
> With .Net I guess you will have to stick to DataStreamer & learn how to
> integrate it with Indexing properly. Or use JDBC from .Net.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> чт, 7 мар. 2019 г. в 16:31, Mike Needham :
>
>> Is that the most efficient way to load millions of rows from a database
>> table into a cache? I guess I am not seeing how this would work for
>> millions of rows in the source database.  That also appears to be a JAVA
>> only solution and it would be preferable to have it be usable for .NET as
>> well as java and hopefully python.
>>
>> On Thu, Mar 7, 2019 at 6:55 AM Ilya Kasnacheev 
>> wrote:
>>
>>> Hello!
>>>
>>> What prevents you from reading rows from DB and feeding them to JDBC
>>> prepared statement?
>>>
>>> Regards,
>>> --
>>> Ilya Kasnacheev
>>>
>>>
>>> чт, 7 мар. 2019 г. в 15:51, Mike Needham :
>>>
 And what if the data is already in a database table?  I do not want to
 read from the table to write to a file to load a cache.

 On Tue, Mar 5, 2019 at 4:06 AM Ilya Kasnacheev <
 ilya.kasnach...@gmail.com> wrote:

> Hello!
>
> The preferred approach is to use Thin JDBC client:
> https://apacheignite-sql.readme.io/docs/jdbc-driver
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> пн, 4 мар. 2019 г. в 19:39, Mike Needham :
>
>> Thanks for the links,  If SET STREAMING ON is the preferred method,
>> how would you do this in code rather than from a file with all the insert
>> statements.
>>
>> On Mon, Mar 4, 2019 at 1:44 AM Ilya Kasnacheev <
>> ilya.kasnach...@gmail.com> wrote:
>>
>>> Hello!
>>>
>>> You can see at this page:
>>> https://apacheignite-sql.readme.io/docs/sql-and-key-value-usage
>>>
>>> And then substitite cache.put() with addData() and cache name will
>>> be SQL_PUBLIC_{table name in caps}
>>>
>>> There are not many examples since this is being discouraged in favor
>>> of SET STREAMING ON, actually:
>>> https://apacheignite-sql.readme.io/docs/set
>>>
>>> Regards,
>>> --
>>> Ilya Kasnacheev
>>>
>>>
>>> пт, 1 мар. 2019 г. в 22:48, Mike Needham :
>>>
 I have looked at the documentation and the code samples and nothing
 is doing what I am trying to do.  I want to be able to use the 
 datastreamer
 to load 3 or 4 TABLES in a cache for an application that we use.  If I
 create the tables using a create table syntax how do attach a 
 datastreamer
 to the different caches if the cache name is PUBLIC for all of them?

 On Thu, Feb 28, 2019 at 8:13 AM Ilya Kasnacheev <
 ilya.kasnach...@gmail.com> wrote:

> Hello!
>
> I have linked the documentation page, there are also some code
> examples in distribution.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> чт, 28 февр. 2019 г. в 17:10, Mike Needham :
>
>> Is there any examples that show the steps to do this correctly?
>> I stumbled upon this but have no idea if it is the best way to do 
>> this
>>
>> On Thu, Feb 28, 2019 at 6:27 AM Ilya Kasnacheev <
>> ilya.kasnach...@gmail.com> wrote:
>>
>>> Hello!
>>>
>>> There's no restriction on cache name but setting it up for the
>>> first time may be tricky indeed.
>>>
>>> Regards,
>>> --
>>> Ilya Kasnacheev
>>>
>>>
>>> ср, 27 февр. 2019 г. в 19:48, needbrew99 :
>>>
 OK, was able to get it working.  Apparently the cache name has
 to be PUBLIC
 and it will create a table based on the object definition that
 I have.



 --
 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*

>>>
>>
>> --
>> *Some days it just not worth chewing through the restraints*
>>
>

-- 
*Some days it just not worth chewing through the restraints*

Re: Access a cache loaded by DataStreamer with SQL

[Ilya Kasnacheev]

Hello!

JDBC with SET STREAMING ON should work reasonably well. You could also use
CacheStore.

With .Net I guess you will have to stick to DataStreamer & learn how to
integrate it with Indexing properly. Or use JDBC from .Net.

Regards,
-- 
Ilya Kasnacheev


чт, 7 мар. 2019 г. в 16:31, Mike Needham :

> Is that the most efficient way to load millions of rows from a database
> table into a cache? I guess I am not seeing how this would work for
> millions of rows in the source database.  That also appears to be a JAVA
> only solution and it would be preferable to have it be usable for .NET as
> well as java and hopefully python.
>
> On Thu, Mar 7, 2019 at 6:55 AM Ilya Kasnacheev 
> wrote:
>
>> Hello!
>>
>> What prevents you from reading rows from DB and feeding them to JDBC
>> prepared statement?
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> чт, 7 мар. 2019 г. в 15:51, Mike Needham :
>>
>>> And what if the data is already in a database table?  I do not want to
>>> read from the table to write to a file to load a cache.
>>>
>>> On Tue, Mar 5, 2019 at 4:06 AM Ilya Kasnacheev <
>>> ilya.kasnach...@gmail.com> wrote:
>>>
 Hello!

 The preferred approach is to use Thin JDBC client:
 https://apacheignite-sql.readme.io/docs/jdbc-driver

 Regards,
 --
 Ilya Kasnacheev


 пн, 4 мар. 2019 г. в 19:39, Mike Needham :

> Thanks for the links,  If SET STREAMING ON is the preferred method,
> how would you do this in code rather than from a file with all the insert
> statements.
>
> On Mon, Mar 4, 2019 at 1:44 AM Ilya Kasnacheev <
> ilya.kasnach...@gmail.com> wrote:
>
>> Hello!
>>
>> You can see at this page:
>> https://apacheignite-sql.readme.io/docs/sql-and-key-value-usage
>>
>> And then substitite cache.put() with addData() and cache name will be
>> SQL_PUBLIC_{table name in caps}
>>
>> There are not many examples since this is being discouraged in favor
>> of SET STREAMING ON, actually:
>> https://apacheignite-sql.readme.io/docs/set
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> пт, 1 мар. 2019 г. в 22:48, Mike Needham :
>>
>>> I have looked at the documentation and the code samples and nothing
>>> is doing what I am trying to do.  I want to be able to use the 
>>> datastreamer
>>> to load 3 or 4 TABLES in a cache for an application that we use.  If I
>>> create the tables using a create table syntax how do attach a 
>>> datastreamer
>>> to the different caches if the cache name is PUBLIC for all of them?
>>>
>>> On Thu, Feb 28, 2019 at 8:13 AM Ilya Kasnacheev <
>>> ilya.kasnach...@gmail.com> wrote:
>>>
 Hello!

 I have linked the documentation page, there are also some code
 examples in distribution.

 Regards,
 --
 Ilya Kasnacheev


 чт, 28 февр. 2019 г. в 17:10, Mike Needham :

> Is there any examples that show the steps to do this correctly?  I
> stumbled upon this but have no idea if it is the best way to do this
>
> On Thu, Feb 28, 2019 at 6:27 AM Ilya Kasnacheev <
> ilya.kasnach...@gmail.com> wrote:
>
>> Hello!
>>
>> There's no restriction on cache name but setting it up for the
>> first time may be tricky indeed.
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> ср, 27 февр. 2019 г. в 19:48, needbrew99 :
>>
>>> OK, was able to get it working.  Apparently the cache name has
>>> to be PUBLIC
>>> and it will create a table based on the object definition that I
>>> have.
>>>
>>>
>>>
>>> --
>>> 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*
>>>
>>
>
> --
> *Some days it just not worth chewing through the restraints*
>

Re: Access a cache loaded by DataStreamer with SQL

[Mike Needham]

Is that the most efficient way to load millions of rows from a database
table into a cache? I guess I am not seeing how this would work for
millions of rows in the source database.  That also appears to be a JAVA
only solution and it would be preferable to have it be usable for .NET as
well as java and hopefully python.

On Thu, Mar 7, 2019 at 6:55 AM Ilya Kasnacheev 
wrote:

> Hello!
>
> What prevents you from reading rows from DB and feeding them to JDBC
> prepared statement?
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> чт, 7 мар. 2019 г. в 15:51, Mike Needham :
>
>> And what if the data is already in a database table?  I do not want to
>> read from the table to write to a file to load a cache.
>>
>> On Tue, Mar 5, 2019 at 4:06 AM Ilya Kasnacheev 
>> wrote:
>>
>>> Hello!
>>>
>>> The preferred approach is to use Thin JDBC client:
>>> https://apacheignite-sql.readme.io/docs/jdbc-driver
>>>
>>> Regards,
>>> --
>>> Ilya Kasnacheev
>>>
>>>
>>> пн, 4 мар. 2019 г. в 19:39, Mike Needham :
>>>
 Thanks for the links,  If SET STREAMING ON is the preferred method, how
 would you do this in code rather than from a file with all the insert
 statements.

 On Mon, Mar 4, 2019 at 1:44 AM Ilya Kasnacheev <
 ilya.kasnach...@gmail.com> wrote:

> Hello!
>
> You can see at this page:
> https://apacheignite-sql.readme.io/docs/sql-and-key-value-usage
>
> And then substitite cache.put() with addData() and cache name will be
> SQL_PUBLIC_{table name in caps}
>
> There are not many examples since this is being discouraged in favor
> of SET STREAMING ON, actually:
> https://apacheignite-sql.readme.io/docs/set
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> пт, 1 мар. 2019 г. в 22:48, Mike Needham :
>
>> I have looked at the documentation and the code samples and nothing
>> is doing what I am trying to do.  I want to be able to use the 
>> datastreamer
>> to load 3 or 4 TABLES in a cache for an application that we use.  If I
>> create the tables using a create table syntax how do attach a 
>> datastreamer
>> to the different caches if the cache name is PUBLIC for all of them?
>>
>> On Thu, Feb 28, 2019 at 8:13 AM Ilya Kasnacheev <
>> ilya.kasnach...@gmail.com> wrote:
>>
>>> Hello!
>>>
>>> I have linked the documentation page, there are also some code
>>> examples in distribution.
>>>
>>> Regards,
>>> --
>>> Ilya Kasnacheev
>>>
>>>
>>> чт, 28 февр. 2019 г. в 17:10, Mike Needham :
>>>
 Is there any examples that show the steps to do this correctly?  I
 stumbled upon this but have no idea if it is the best way to do this

 On Thu, Feb 28, 2019 at 6:27 AM Ilya Kasnacheev <
 ilya.kasnach...@gmail.com> wrote:

> Hello!
>
> There's no restriction on cache name but setting it up for the
> first time may be tricky indeed.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> ср, 27 февр. 2019 г. в 19:48, needbrew99 :
>
>> OK, was able to get it working.  Apparently the cache name has to
>> be PUBLIC
>> and it will create a table based on the object definition that I
>> have.
>>
>>
>>
>> --
>> 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*
>>
>

-- 
*Some days it just not worth chewing through the restraints*

Re: Access a cache loaded by DataStreamer with SQL

[Ilya Kasnacheev]

Hello!

What prevents you from reading rows from DB and feeding them to JDBC
prepared statement?

Regards,
-- 
Ilya Kasnacheev


чт, 7 мар. 2019 г. в 15:51, Mike Needham :

> And what if the data is already in a database table?  I do not want to
> read from the table to write to a file to load a cache.
>
> On Tue, Mar 5, 2019 at 4:06 AM Ilya Kasnacheev 
> wrote:
>
>> Hello!
>>
>> The preferred approach is to use Thin JDBC client:
>> https://apacheignite-sql.readme.io/docs/jdbc-driver
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> пн, 4 мар. 2019 г. в 19:39, Mike Needham :
>>
>>> Thanks for the links,  If SET STREAMING ON is the preferred method, how
>>> would you do this in code rather than from a file with all the insert
>>> statements.
>>>
>>> On Mon, Mar 4, 2019 at 1:44 AM Ilya Kasnacheev <
>>> ilya.kasnach...@gmail.com> wrote:
>>>
 Hello!

 You can see at this page:
 https://apacheignite-sql.readme.io/docs/sql-and-key-value-usage

 And then substitite cache.put() with addData() and cache name will be
 SQL_PUBLIC_{table name in caps}

 There are not many examples since this is being discouraged in favor of
 SET STREAMING ON, actually:
 https://apacheignite-sql.readme.io/docs/set

 Regards,
 --
 Ilya Kasnacheev


 пт, 1 мар. 2019 г. в 22:48, Mike Needham :

> I have looked at the documentation and the code samples and nothing is
> doing what I am trying to do.  I want to be able to use the datastreamer 
> to
> load 3 or 4 TABLES in a cache for an application that we use.  If I create
> the tables using a create table syntax how do attach a datastreamer to the
> different caches if the cache name is PUBLIC for all of them?
>
> On Thu, Feb 28, 2019 at 8:13 AM Ilya Kasnacheev <
> ilya.kasnach...@gmail.com> wrote:
>
>> Hello!
>>
>> I have linked the documentation page, there are also some code
>> examples in distribution.
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> чт, 28 февр. 2019 г. в 17:10, Mike Needham :
>>
>>> Is there any examples that show the steps to do this correctly?  I
>>> stumbled upon this but have no idea if it is the best way to do this
>>>
>>> On Thu, Feb 28, 2019 at 6:27 AM Ilya Kasnacheev <
>>> ilya.kasnach...@gmail.com> wrote:
>>>
 Hello!

 There's no restriction on cache name but setting it up for the
 first time may be tricky indeed.

 Regards,
 --
 Ilya Kasnacheev


 ср, 27 февр. 2019 г. в 19:48, needbrew99 :

> OK, was able to get it working.  Apparently the cache name has to
> be PUBLIC
> and it will create a table based on the object definition that I
> have.
>
>
>
> --
> 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*
>

Re: Access a cache loaded by DataStreamer with SQL

[Mike Needham]

And what if the data is already in a database table?  I do not want to read
from the table to write to a file to load a cache.

On Tue, Mar 5, 2019 at 4:06 AM Ilya Kasnacheev 
wrote:

> Hello!
>
> The preferred approach is to use Thin JDBC client:
> https://apacheignite-sql.readme.io/docs/jdbc-driver
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> пн, 4 мар. 2019 г. в 19:39, Mike Needham :
>
>> Thanks for the links,  If SET STREAMING ON is the preferred method, how
>> would you do this in code rather than from a file with all the insert
>> statements.
>>
>> On Mon, Mar 4, 2019 at 1:44 AM Ilya Kasnacheev 
>> wrote:
>>
>>> Hello!
>>>
>>> You can see at this page:
>>> https://apacheignite-sql.readme.io/docs/sql-and-key-value-usage
>>>
>>> And then substitite cache.put() with addData() and cache name will be
>>> SQL_PUBLIC_{table name in caps}
>>>
>>> There are not many examples since this is being discouraged in favor of
>>> SET STREAMING ON, actually:
>>> https://apacheignite-sql.readme.io/docs/set
>>>
>>> Regards,
>>> --
>>> Ilya Kasnacheev
>>>
>>>
>>> пт, 1 мар. 2019 г. в 22:48, Mike Needham :
>>>
 I have looked at the documentation and the code samples and nothing is
 doing what I am trying to do.  I want to be able to use the datastreamer to
 load 3 or 4 TABLES in a cache for an application that we use.  If I create
 the tables using a create table syntax how do attach a datastreamer to the
 different caches if the cache name is PUBLIC for all of them?

 On Thu, Feb 28, 2019 at 8:13 AM Ilya Kasnacheev <
 ilya.kasnach...@gmail.com> wrote:

> Hello!
>
> I have linked the documentation page, there are also some code
> examples in distribution.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> чт, 28 февр. 2019 г. в 17:10, Mike Needham :
>
>> Is there any examples that show the steps to do this correctly?  I
>> stumbled upon this but have no idea if it is the best way to do this
>>
>> On Thu, Feb 28, 2019 at 6:27 AM Ilya Kasnacheev <
>> ilya.kasnach...@gmail.com> wrote:
>>
>>> Hello!
>>>
>>> There's no restriction on cache name but setting it up for the first
>>> time may be tricky indeed.
>>>
>>> Regards,
>>> --
>>> Ilya Kasnacheev
>>>
>>>
>>> ср, 27 февр. 2019 г. в 19:48, needbrew99 :
>>>
 OK, was able to get it working.  Apparently the cache name has to
 be PUBLIC
 and it will create a table based on the object definition that I
 have.



 --
 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*

Re: Access a cache loaded by DataStreamer with SQL

[Ilya Kasnacheev]

Hello!

The preferred approach is to use Thin JDBC client:
https://apacheignite-sql.readme.io/docs/jdbc-driver

Regards,
-- 
Ilya Kasnacheev


пн, 4 мар. 2019 г. в 19:39, Mike Needham :

> Thanks for the links,  If SET STREAMING ON is the preferred method, how
> would you do this in code rather than from a file with all the insert
> statements.
>
> On Mon, Mar 4, 2019 at 1:44 AM Ilya Kasnacheev 
> wrote:
>
>> Hello!
>>
>> You can see at this page:
>> https://apacheignite-sql.readme.io/docs/sql-and-key-value-usage
>>
>> And then substitite cache.put() with addData() and cache name will be
>> SQL_PUBLIC_{table name in caps}
>>
>> There are not many examples since this is being discouraged in favor of
>> SET STREAMING ON, actually:
>> https://apacheignite-sql.readme.io/docs/set
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> пт, 1 мар. 2019 г. в 22:48, Mike Needham :
>>
>>> I have looked at the documentation and the code samples and nothing is
>>> doing what I am trying to do.  I want to be able to use the datastreamer to
>>> load 3 or 4 TABLES in a cache for an application that we use.  If I create
>>> the tables using a create table syntax how do attach a datastreamer to the
>>> different caches if the cache name is PUBLIC for all of them?
>>>
>>> On Thu, Feb 28, 2019 at 8:13 AM Ilya Kasnacheev <
>>> ilya.kasnach...@gmail.com> wrote:
>>>
 Hello!

 I have linked the documentation page, there are also some code examples
 in distribution.

 Regards,
 --
 Ilya Kasnacheev


 чт, 28 февр. 2019 г. в 17:10, Mike Needham :

> Is there any examples that show the steps to do this correctly?  I
> stumbled upon this but have no idea if it is the best way to do this
>
> On Thu, Feb 28, 2019 at 6:27 AM Ilya Kasnacheev <
> ilya.kasnach...@gmail.com> wrote:
>
>> Hello!
>>
>> There's no restriction on cache name but setting it up for the first
>> time may be tricky indeed.
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> ср, 27 февр. 2019 г. в 19:48, needbrew99 :
>>
>>> OK, was able to get it working.  Apparently the cache name has to be
>>> PUBLIC
>>> and it will create a table based on the object definition that I
>>> have.
>>>
>>>
>>>
>>> --
>>> 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*
>

Re: Access a cache loaded by DataStreamer with SQL

[Mike Needham]

Thanks for the links,  If SET STREAMING ON is the preferred method, how
would you do this in code rather than from a file with all the insert
statements.

On Mon, Mar 4, 2019 at 1:44 AM Ilya Kasnacheev 
wrote:

> Hello!
>
> You can see at this page:
> https://apacheignite-sql.readme.io/docs/sql-and-key-value-usage
>
> And then substitite cache.put() with addData() and cache name will be
> SQL_PUBLIC_{table name in caps}
>
> There are not many examples since this is being discouraged in favor of
> SET STREAMING ON, actually:
> https://apacheignite-sql.readme.io/docs/set
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> пт, 1 мар. 2019 г. в 22:48, Mike Needham :
>
>> I have looked at the documentation and the code samples and nothing is
>> doing what I am trying to do.  I want to be able to use the datastreamer to
>> load 3 or 4 TABLES in a cache for an application that we use.  If I create
>> the tables using a create table syntax how do attach a datastreamer to the
>> different caches if the cache name is PUBLIC for all of them?
>>
>> On Thu, Feb 28, 2019 at 8:13 AM Ilya Kasnacheev <
>> ilya.kasnach...@gmail.com> wrote:
>>
>>> Hello!
>>>
>>> I have linked the documentation page, there are also some code examples
>>> in distribution.
>>>
>>> Regards,
>>> --
>>> Ilya Kasnacheev
>>>
>>>
>>> чт, 28 февр. 2019 г. в 17:10, Mike Needham :
>>>
 Is there any examples that show the steps to do this correctly?  I
 stumbled upon this but have no idea if it is the best way to do this

 On Thu, Feb 28, 2019 at 6:27 AM Ilya Kasnacheev <
 ilya.kasnach...@gmail.com> wrote:

> Hello!
>
> There's no restriction on cache name but setting it up for the first
> time may be tricky indeed.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> ср, 27 февр. 2019 г. в 19:48, needbrew99 :
>
>> OK, was able to get it working.  Apparently the cache name has to be
>> PUBLIC
>> and it will create a table based on the object definition that I
>> have.
>>
>>
>>
>> --
>> 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*

Re: Access a cache loaded by DataStreamer with SQL

[Ilya Kasnacheev]

Hello!

You can see at this page:
https://apacheignite-sql.readme.io/docs/sql-and-key-value-usage

And then substitite cache.put() with addData() and cache name will be
SQL_PUBLIC_{table name in caps}

There are not many examples since this is being discouraged in favor of SET
STREAMING ON, actually:
https://apacheignite-sql.readme.io/docs/set

Regards,
-- 
Ilya Kasnacheev


пт, 1 мар. 2019 г. в 22:48, Mike Needham :

> I have looked at the documentation and the code samples and nothing is
> doing what I am trying to do.  I want to be able to use the datastreamer to
> load 3 or 4 TABLES in a cache for an application that we use.  If I create
> the tables using a create table syntax how do attach a datastreamer to the
> different caches if the cache name is PUBLIC for all of them?
>
> On Thu, Feb 28, 2019 at 8:13 AM Ilya Kasnacheev 
> wrote:
>
>> Hello!
>>
>> I have linked the documentation page, there are also some code examples
>> in distribution.
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> чт, 28 февр. 2019 г. в 17:10, Mike Needham :
>>
>>> Is there any examples that show the steps to do this correctly?  I
>>> stumbled upon this but have no idea if it is the best way to do this
>>>
>>> On Thu, Feb 28, 2019 at 6:27 AM Ilya Kasnacheev <
>>> ilya.kasnach...@gmail.com> wrote:
>>>
 Hello!

 There's no restriction on cache name but setting it up for the first
 time may be tricky indeed.

 Regards,
 --
 Ilya Kasnacheev


 ср, 27 февр. 2019 г. в 19:48, needbrew99 :

> OK, was able to get it working.  Apparently the cache name has to be
> PUBLIC
> and it will create a table based on the object definition that I
> have.
>
>
>
> --
> 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*
>

Re: Access a cache loaded by DataStreamer with SQL

[Павлухин Иван]

Hi Mike,

You can find a simple example of loading data with data streamer and
querying it with SQL in a following gist [1].

It is possible but somehow tricky to load table created by DDL using
data streamer. Perhaps, SQL COPY could be handy for you [2]. It uses
data streamer under the hood.

[1] https://gist.github.com/pavlukhin/0b30671b76abf01b2cc30230a11cc1f7
[2] https://apacheignite-sql.readme.io/docs/copy

пт, 1 мар. 2019 г. в 22:48, Mike Needham :
>
> I have looked at the documentation and the code samples and nothing is doing 
> what I am trying to do.  I want to be able to use the datastreamer to load 3 
> or 4 TABLES in a cache for an application that we use.  If I create the 
> tables using a create table syntax how do attach a datastreamer to the 
> different caches if the cache name is PUBLIC for all of them?
>
> On Thu, Feb 28, 2019 at 8:13 AM Ilya Kasnacheev  
> wrote:
>>
>> Hello!
>>
>> I have linked the documentation page, there are also some code examples in 
>> distribution.
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> чт, 28 февр. 2019 г. в 17:10, Mike Needham :
>>>
>>> Is there any examples that show the steps to do this correctly?  I stumbled 
>>> upon this but have no idea if it is the best way to do this
>>>
>>> On Thu, Feb 28, 2019 at 6:27 AM Ilya Kasnacheev  
>>> wrote:

 Hello!

 There's no restriction on cache name but setting it up for the first time 
 may be tricky indeed.

 Regards,
 --
 Ilya Kasnacheev


 ср, 27 февр. 2019 г. в 19:48, needbrew99 :
>
> OK, was able to get it working.  Apparently the cache name has to be 
> PUBLIC
> and it will create a table based on the object definition that I have.
>
>
>
> --
> 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



-- 
Best regards,
Ivan Pavlukhin

Re: Access a cache loaded by DataStreamer with SQL

[Mike Needham]

I have looked at the documentation and the code samples and nothing is
doing what I am trying to do.  I want to be able to use the datastreamer to
load 3 or 4 TABLES in a cache for an application that we use.  If I create
the tables using a create table syntax how do attach a datastreamer to the
different caches if the cache name is PUBLIC for all of them?

On Thu, Feb 28, 2019 at 8:13 AM Ilya Kasnacheev 
wrote:

> Hello!
>
> I have linked the documentation page, there are also some code examples in
> distribution.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> чт, 28 февр. 2019 г. в 17:10, Mike Needham :
>
>> Is there any examples that show the steps to do this correctly?  I
>> stumbled upon this but have no idea if it is the best way to do this
>>
>> On Thu, Feb 28, 2019 at 6:27 AM Ilya Kasnacheev <
>> ilya.kasnach...@gmail.com> wrote:
>>
>>> Hello!
>>>
>>> There's no restriction on cache name but setting it up for the first
>>> time may be tricky indeed.
>>>
>>> Regards,
>>> --
>>> Ilya Kasnacheev
>>>
>>>
>>> ср, 27 февр. 2019 г. в 19:48, needbrew99 :
>>>
 OK, was able to get it working.  Apparently the cache name has to be
 PUBLIC
 and it will create a table based on the object definition that I have.



 --
 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*

Re: Access a cache loaded by DataStreamer with SQL

[Ilya Kasnacheev]

Hello!

I have linked the documentation page, there are also some code examples in
distribution.

Regards,
-- 
Ilya Kasnacheev


чт, 28 февр. 2019 г. в 17:10, Mike Needham :

> Is there any examples that show the steps to do this correctly?  I
> stumbled upon this but have no idea if it is the best way to do this
>
> On Thu, Feb 28, 2019 at 6:27 AM Ilya Kasnacheev 
> wrote:
>
>> Hello!
>>
>> There's no restriction on cache name but setting it up for the first time
>> may be tricky indeed.
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> ср, 27 февр. 2019 г. в 19:48, needbrew99 :
>>
>>> OK, was able to get it working.  Apparently the cache name has to be
>>> PUBLIC
>>> and it will create a table based on the object definition that I have.
>>>
>>>
>>>
>>> --
>>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>>
>>
>
> --
> *Some days it just not worth chewing through the restraints*
>

Re: Access a cache loaded by DataStreamer with SQL

[Mike Needham]

Is there any examples that show the steps to do this correctly?  I stumbled
upon this but have no idea if it is the best way to do this

On Thu, Feb 28, 2019 at 6:27 AM Ilya Kasnacheev 
wrote:

> Hello!
>
> There's no restriction on cache name but setting it up for the first time
> may be tricky indeed.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> ср, 27 февр. 2019 г. в 19:48, needbrew99 :
>
>> OK, was able to get it working.  Apparently the cache name has to be
>> PUBLIC
>> and it will create a table based on the object definition that I have.
>>
>>
>>
>> --
>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>
>

-- 
*Some days it just not worth chewing through the restraints*

Re: Access a cache loaded by DataStreamer with SQL

[Ilya Kasnacheev]

Hello!

There's no restriction on cache name but setting it up for the first time
may be tricky indeed.

Regards,
-- 
Ilya Kasnacheev


ср, 27 февр. 2019 г. в 19:48, needbrew99 :

> OK, was able to get it working.  Apparently the cache name has to be PUBLIC
> and it will create a table based on the object definition that I have.
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: Access a cache loaded by DataStreamer with SQL

[needbrew99]

OK, was able to get it working.  Apparently the cache name has to be PUBLIC
and it will create a table based on the object definition that I have.  



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Access a cache loaded by DataStreamer with SQL

[Mike Needham]

I have looked at the docs and it is not clear to me how to set-up a
queryable table that can be loaded with a datastreamer.  If I want to use
the datastreamer and still have it queryable from a third party tool like
Tableau what would I need to set-up.  I tried one thing and it showed up in
the DBeaver but under a schema of Test, that was my cache name, but I
cannot query it as it says invalid schema.  Is there some config when the
cache is created that needs to be set so that it also generates TABLES that
are queryable.  Sorry for all the questions as I am trying to do a quick
proof of concept for our users and need to load 10 million initially into a
cache and have it queryable from SQL interfaces.

On Wed, Feb 27, 2019 at 8:14 AM Ilya Kasnacheev 
wrote:

> Hello!
>
> Please refer to this page: https://apacheignite.readme.io/docs/indexes
>
> In short, you can use CREATE TABLE or GetOrCreateCache
> indexedTypes+annotations or QueryEntities. All of those are compatible with
> DataStreamer as long as type name and field/column names match.
>
> By default caches do not have corresponding tables.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> вт, 26 февр. 2019 г. в 21:35, Mike Needham :
>
>> Hi All,
>>
>> I have a cache that I have loaded using the DataStreamer and can confirm
>> there is a cache created by using the ignitevisor utility  with the cache
>> command.  I cannot query it from any JDBC tools and am not sure why.  Do I
>> need to use a CREATE TABLE syntax in order for this to work instead of the
>> GetOrCreateCache<>(CacheName).  Or is there someother thing on the config
>> side that I am missiung
>>
>> Any help appreciated as I am just starting to evaluate this for a project.
>>
>>
>> --
>> *Some days it just not worth chewing through the restraints*
>>
>

-- 
*Some days it just not worth chewing through the restraints*

Re: Access a cache loaded by DataStreamer with SQL

[Ilya Kasnacheev]

Hello!

Please refer to this page: https://apacheignite.readme.io/docs/indexes

In short, you can use CREATE TABLE or GetOrCreateCache
indexedTypes+annotations or QueryEntities. All of those are compatible with
DataStreamer as long as type name and field/column names match.

By default caches do not have corresponding tables.

Regards,
-- 
Ilya Kasnacheev


вт, 26 февр. 2019 г. в 21:35, Mike Needham :

> Hi All,
>
> I have a cache that I have loaded using the DataStreamer and can confirm
> there is a cache created by using the ignitevisor utility  with the cache
> command.  I cannot query it from any JDBC tools and am not sure why.  Do I
> need to use a CREATE TABLE syntax in order for this to work instead of the
> GetOrCreateCache<>(CacheName).  Or is there someother thing on the config
> side that I am missiung
>
> Any help appreciated as I am just starting to evaluate this for a project.
>
>
> --
> *Some days it just not worth chewing through the restraints*
>

Access a cache loaded by DataStreamer with SQL

[Mike Needham]

Hi All,

I have a cache that I have loaded using the DataStreamer and can confirm
there is a cache created by using the ignitevisor utility  with the cache
command.  I cannot query it from any JDBC tools and am not sure why.  Do I
need to use a CREATE TABLE syntax in order for this to work instead of the
GetOrCreateCache<>(CacheName).  Or is there someother thing on the config
side that I am missiung

Any help appreciated as I am just starting to evaluate this for a project.

-- 
*Some days it just not worth chewing through the restraints*