SQL Query Docs Updated
Locked
 
|
Guys,
I've just updated SQL Queries documentation, please read and send your feedback. http://apacheignite.gridgain.org/v1.3/docs/sql-queries Sergi |
Re: SQL Query Docs Updated
|
|
Sergi, I like new docs.
Couple of thought: 1. How about to add some info what will happened in case of multiple parallel query executions from different threads? What is recommended way to do it? 2. What will happened in case when one thread modify cache (put/update/remove) and another thread run SQL query? 3. What about paging for large queries? getAll() is not possible. I think a some idiomatic code sample could be very useful. On Wed, Aug 19, 2015 at 2:18 PM, Sergi Vladykin <[hidden email]> wrote: > Guys, > > I've just updated SQL Queries documentation, please read and send your > feedback. > > http://apacheignite.gridgain.org/v1.3/docs/sql-queries > > Sergi > -- Alexey Kuznetsov GridGain Systems www.gridgain.com |
|
|
In reply to this post by Sergi
I like the article.
Couple of points, though: 1. Annotations and XML configs are not identical. XML states that ID is UUID, but annotations listing states that it is primitive long. 2. I would prefer example that example can be copied-and-pasted and launched. Can we add cache config, indexes, and cache loading? 3. Need more accent on necessity of indexed types configuration. Can you put this into code box? --Yakov 2015-08-19 10:18 GMT+03:00 Sergi Vladykin <[hidden email]>: > Guys, > > I've just updated SQL Queries documentation, please read and send your > feedback. > > http://apacheignite.gridgain.org/v1.3/docs/sql-queries > > Sergi > |
|
It's really nice, but it's better to have an examples to load data from
jdbc store with annotation. On Wed, Aug 19, 2015 at 7:04 PM, Yakov Zhdanov <[hidden email]> wrote: > I like the article. > > Couple of points, though: > 1. Annotations and XML configs are not identical. XML states that ID is > UUID, but annotations listing states that it is primitive long. > 2. I would prefer example that example can be copied-and-pasted and > launched. Can we add cache config, indexes, and cache loading? > 3. Need more accent on necessity of indexed types configuration. Can you > put this into code box? > > > --Yakov > > 2015-08-19 10:18 GMT+03:00 Sergi Vladykin <[hidden email]>: > >> Guys, >> >> I've just updated SQL Queries documentation, please read and send your >> feedback. >> >> http://apacheignite.gridgain.org/v1.3/docs/sql-queries >> >> Sergi >> > > |
|
|
In reply to this post by yzhdanov
Alexey, Yakov
Ok, will try to fix. Sergi 2015-08-19 14:04 GMT+03:00 Yakov Zhdanov <[hidden email]>: > I like the article. > > Couple of points, though: > 1. Annotations and XML configs are not identical. XML states that ID is > UUID, but annotations listing states that it is primitive long. > 2. I would prefer example that example can be copied-and-pasted and > launched. Can we add cache config, indexes, and cache loading? > 3. Need more accent on necessity of indexed types configuration. Can you > put this into code box? > > > --Yakov > > 2015-08-19 10:18 GMT+03:00 Sergi Vladykin <[hidden email]>: > > > Guys, > > > > I've just updated SQL Queries documentation, please read and send your > > feedback. > > > > http://apacheignite.gridgain.org/v1.3/docs/sql-queries > > > > Sergi > > > |
|
|
In reply to this post by kcheng.mvp
Ken,
Jdbc store is a little bit separate beast, so I'd prefer keeping it's documentation separately from SQL queries section. But definitely you are right, we should have such a documentation with examples. Sergi 2015-08-19 18:40 GMT+03:00 Ken Cheng <[hidden email]>: > It's really nice, but it's better to have an examples to load data from > jdbc store with annotation. > > On Wed, Aug 19, 2015 at 7:04 PM, Yakov Zhdanov <[hidden email]> > wrote: > >> I like the article. >> >> Couple of points, though: >> 1. Annotations and XML configs are not identical. XML states that ID is >> UUID, but annotations listing states that it is primitive long. >> 2. I would prefer example that example can be copied-and-pasted and >> launched. Can we add cache config, indexes, and cache loading? >> 3. Need more accent on necessity of indexed types configuration. Can you >> put this into code box? >> >> >> --Yakov >> >> 2015-08-19 10:18 GMT+03:00 Sergi Vladykin <[hidden email]>: >> >>> Guys, >>> >>> I've just updated SQL Queries documentation, please read and send your >>> feedback. >>> >>> http://apacheignite.gridgain.org/v1.3/docs/sql-queries >>> >>> Sergi >>> >> >> > |
|
|
by the way I have fired a bug
https://issues.apache.org/jira/browse/IGNITE-1246, it's about jdbcdata source in a cluster environment On Wed, Aug 19, 2015 at 11:54 PM, Sergi Vladykin <[hidden email]> wrote: > Ken, > > Jdbc store is a little bit separate beast, so I'd prefer keeping it's > documentation separately from SQL queries section. > But definitely you are right, we should have such a documentation with > examples. > > Sergi > > 2015-08-19 18:40 GMT+03:00 Ken Cheng <[hidden email]>: > >> It's really nice, but it's better to have an examples to load data from >> jdbc store with annotation. >> >> On Wed, Aug 19, 2015 at 7:04 PM, Yakov Zhdanov <[hidden email]> >> wrote: >> >>> I like the article. >>> >>> Couple of points, though: >>> 1. Annotations and XML configs are not identical. XML states that ID is >>> UUID, but annotations listing states that it is primitive long. >>> 2. I would prefer example that example can be copied-and-pasted and >>> launched. Can we add cache config, indexes, and cache loading? >>> 3. Need more accent on necessity of indexed types configuration. Can you >>> put this into code box? >>> >>> >>> --Yakov >>> >>> 2015-08-19 10:18 GMT+03:00 Sergi Vladykin <[hidden email]>: >>> >>>> Guys, >>>> >>>> I've just updated SQL Queries documentation, please read and send your >>>> feedback. >>>> >>>> http://apacheignite.gridgain.org/v1.3/docs/sql-queries >>>> >>>> Sergi >>>> >>> >>> >> > |
|
|
there is no such document address it as well no examples in the github.
it's really appreciated you can supply a document and an example On Thu, Aug 20, 2015 at 12:03 AM, Ken Cheng <[hidden email]> wrote: > by the way I have fired a bug > https://issues.apache.org/jira/browse/IGNITE-1246, > it's about jdbcdata source in a cluster environment > > > On Wed, Aug 19, 2015 at 11:54 PM, Sergi Vladykin <[hidden email] > > wrote: > >> Ken, >> >> Jdbc store is a little bit separate beast, so I'd prefer keeping it's >> documentation separately from SQL queries section. >> But definitely you are right, we should have such a documentation with >> examples. >> >> Sergi >> >> 2015-08-19 18:40 GMT+03:00 Ken Cheng <[hidden email]>: >> >>> It's really nice, but it's better to have an examples to load data from >>> jdbc store with annotation. >>> >>> On Wed, Aug 19, 2015 at 7:04 PM, Yakov Zhdanov <[hidden email]> >>> wrote: >>> >>>> I like the article. >>>> >>>> Couple of points, though: >>>> 1. Annotations and XML configs are not identical. XML states that ID is >>>> UUID, but annotations listing states that it is primitive long. >>>> 2. I would prefer example that example can be copied-and-pasted and >>>> launched. Can we add cache config, indexes, and cache loading? >>>> 3. Need more accent on necessity of indexed types configuration. Can >>>> you put this into code box? >>>> >>>> >>>> --Yakov >>>> >>>> 2015-08-19 10:18 GMT+03:00 Sergi Vladykin <[hidden email]>: >>>> >>>>> Guys, >>>>> >>>>> I've just updated SQL Queries documentation, please read and send your >>>>> feedback. >>>>> >>>>> http://apacheignite.gridgain.org/v1.3/docs/sql-queries >>>>> >>>>> Sergi >>>>> >>>> >>>> >>> >> > |
Re: SQL Query Docs Updated
|
|
Ken,
We have documentation for store. See: https://apacheignite.readme.io/docs/persistent-store And: https://apacheignite.readme.io/docs/automatic-persistence Also take a look for example: examples\schema-import\README.txt There several bugs found with JdbcPojoStoreFactory and it seems for me that issue you opened is the same as https://issues.apache.org/jira/browse/IGNITE-1262 Andey Gura is working on it and AFAIK he should submit pull request in a couple of days. I hope in next release you can work with jdbc store and queries. Also about XML - it is not mandatory, you can configure ALL by code. On Wed, Aug 19, 2015 at 11:05 PM, Ken Cheng <[hidden email]> wrote: > there is no such document address it as well no examples in the github. > > it's really appreciated you can supply a document and an example > > On Thu, Aug 20, 2015 at 12:03 AM, Ken Cheng <[hidden email]> wrote: > >> by the way I have fired a bug >> https://issues.apache.org/jira/browse/IGNITE-1246, >> it's about jdbcdata source in a cluster environment >> >> >> On Wed, Aug 19, 2015 at 11:54 PM, Sergi Vladykin < >> [hidden email]> wrote: >> >>> Ken, >>> >>> Jdbc store is a little bit separate beast, so I'd prefer keeping it's >>> documentation separately from SQL queries section. >>> But definitely you are right, we should have such a documentation with >>> examples. >>> >>> Sergi >>> >>> 2015-08-19 18:40 GMT+03:00 Ken Cheng <[hidden email]>: >>> >>>> It's really nice, but it's better to have an examples to load data from >>>> jdbc store with annotation. >>>> >>>> On Wed, Aug 19, 2015 at 7:04 PM, Yakov Zhdanov <[hidden email]> >>>> wrote: >>>> >>>>> I like the article. >>>>> >>>>> Couple of points, though: >>>>> 1. Annotations and XML configs are not identical. XML states that ID >>>>> is UUID, but annotations listing states that it is primitive long. >>>>> 2. I would prefer example that example can be copied-and-pasted and >>>>> launched. Can we add cache config, indexes, and cache loading? >>>>> 3. Need more accent on necessity of indexed types configuration. Can >>>>> you put this into code box? >>>>> >>>>> >>>>> --Yakov >>>>> >>>>> 2015-08-19 10:18 GMT+03:00 Sergi Vladykin <[hidden email]>: >>>>> >>>>>> Guys, >>>>>> >>>>>> I've just updated SQL Queries documentation, please read and send >>>>>> your feedback. >>>>>> >>>>>> http://apacheignite.gridgain.org/v1.3/docs/sql-queries >>>>>> >>>>>> Sergi >>>>>> >>>>> >>>>> >>>> >>> >> > -- Alexey Kuznetsov GridGain Systems www.gridgain.com |
|
|
---Also about XML - it is not mandatory, you can configure ALL by code.
it's better to give an example with annotation, as right now I can not find such example. Thanks On Thu, Aug 20, 2015 at 12:19 AM, Alexey Kuznetsov <[hidden email]> wrote: > Ken, > > We have documentation for store. > > See: https://apacheignite.readme.io/docs/persistent-store > And: https://apacheignite.readme.io/docs/automatic-persistence > > Also take a look for example: examples\schema-import\README.txt > > There several bugs found with JdbcPojoStoreFactory and it seems for me > that issue you opened is the same as > https://issues.apache.org/jira/browse/IGNITE-1262 > > Andey Gura is working on it and AFAIK he should submit pull request in a > couple of days. > > I hope in next release you can work with jdbc store and queries. > > Also about XML - it is not mandatory, you can configure ALL by code. > > > On Wed, Aug 19, 2015 at 11:05 PM, Ken Cheng <[hidden email]> wrote: > >> there is no such document address it as well no examples in the github. >> >> it's really appreciated you can supply a document and an example >> >> On Thu, Aug 20, 2015 at 12:03 AM, Ken Cheng <[hidden email]> wrote: >> >>> by the way I have fired a bug >>> https://issues.apache.org/jira/browse/IGNITE-1246, >>> it's about jdbcdata source in a cluster environment >>> >>> >>> On Wed, Aug 19, 2015 at 11:54 PM, Sergi Vladykin < >>> [hidden email]> wrote: >>> >>>> Ken, >>>> >>>> Jdbc store is a little bit separate beast, so I'd prefer keeping it's >>>> documentation separately from SQL queries section. >>>> But definitely you are right, we should have such a documentation with >>>> examples. >>>> >>>> Sergi >>>> >>>> 2015-08-19 18:40 GMT+03:00 Ken Cheng <[hidden email]>: >>>> >>>>> It's really nice, but it's better to have an examples to load data >>>>> from jdbc store with annotation. >>>>> >>>>> On Wed, Aug 19, 2015 at 7:04 PM, Yakov Zhdanov <[hidden email]> >>>>> wrote: >>>>> >>>>>> I like the article. >>>>>> >>>>>> Couple of points, though: >>>>>> 1. Annotations and XML configs are not identical. XML states that ID >>>>>> is UUID, but annotations listing states that it is primitive long. >>>>>> 2. I would prefer example that example can be copied-and-pasted and >>>>>> launched. Can we add cache config, indexes, and cache loading? >>>>>> 3. Need more accent on necessity of indexed types configuration. Can >>>>>> you put this into code box? >>>>>> >>>>>> >>>>>> --Yakov >>>>>> >>>>>> 2015-08-19 10:18 GMT+03:00 Sergi Vladykin <[hidden email]>: >>>>>> >>>>>>> Guys, >>>>>>> >>>>>>> I've just updated SQL Queries documentation, please read and send >>>>>>> your feedback. >>>>>>> >>>>>>> http://apacheignite.gridgain.org/v1.3/docs/sql-queries >>>>>>> >>>>>>> Sergi >>>>>>> >>>>>> >>>>>> >>>>> >>>> >>> >> > > > -- > Alexey Kuznetsov > GridGain Systems > www.gridgain.com > |
Re: SQL Query Docs Updated
|
|
Ken,
https://github.com/apache/incubator-ignite/tree/master/examples/schema-import On Thu, Aug 20, 2015 at 12:04 AM, Ken Cheng <[hidden email]> wrote: > ---Also about XML - it is not mandatory, you can configure ALL by code. > > it's better to give an example with annotation, as right now I can not > find such example. Thanks > > On Thu, Aug 20, 2015 at 12:19 AM, Alexey Kuznetsov < > [hidden email]> wrote: > >> Ken, >> >> We have documentation for store. >> >> See: https://apacheignite.readme.io/docs/persistent-store >> And: https://apacheignite.readme.io/docs/automatic-persistence >> >> Also take a look for example: examples\schema-import\README.txt >> >> There several bugs found with JdbcPojoStoreFactory and it seems for me >> that issue you opened is the same as >> https://issues.apache.org/jira/browse/IGNITE-1262 >> >> Andey Gura is working on it and AFAIK he should submit pull request in a >> couple of days. >> >> I hope in next release you can work with jdbc store and queries. >> >> Also about XML - it is not mandatory, you can configure ALL by code. >> >> >> On Wed, Aug 19, 2015 at 11:05 PM, Ken Cheng <[hidden email]> wrote: >> >>> there is no such document address it as well no examples in the github. >>> >>> it's really appreciated you can supply a document and an example >>> >>> On Thu, Aug 20, 2015 at 12:03 AM, Ken Cheng <[hidden email]> >>> wrote: >>> >>>> by the way I have fired a bug >>>> https://issues.apache.org/jira/browse/IGNITE-1246, >>>> it's about jdbcdata source in a cluster environment >>>> >>>> >>>> On Wed, Aug 19, 2015 at 11:54 PM, Sergi Vladykin < >>>> [hidden email]> wrote: >>>> >>>>> Ken, >>>>> >>>>> Jdbc store is a little bit separate beast, so I'd prefer keeping it's >>>>> documentation separately from SQL queries section. >>>>> But definitely you are right, we should have such a documentation with >>>>> examples. >>>>> >>>>> Sergi >>>>> >>>>> 2015-08-19 18:40 GMT+03:00 Ken Cheng <[hidden email]>: >>>>> >>>>>> It's really nice, but it's better to have an examples to load data >>>>>> from jdbc store with annotation. >>>>>> >>>>>> On Wed, Aug 19, 2015 at 7:04 PM, Yakov Zhdanov <[hidden email]> >>>>>> wrote: >>>>>> >>>>>>> I like the article. >>>>>>> >>>>>>> Couple of points, though: >>>>>>> 1. Annotations and XML configs are not identical. XML states that ID >>>>>>> is UUID, but annotations listing states that it is primitive long. >>>>>>> 2. I would prefer example that example can be copied-and-pasted and >>>>>>> launched. Can we add cache config, indexes, and cache loading? >>>>>>> 3. Need more accent on necessity of indexed types configuration. Can >>>>>>> you put this into code box? >>>>>>> >>>>>>> >>>>>>> --Yakov >>>>>>> >>>>>>> 2015-08-19 10:18 GMT+03:00 Sergi Vladykin <[hidden email]> >>>>>>> : >>>>>>> >>>>>>>> Guys, >>>>>>>> >>>>>>>> I've just updated SQL Queries documentation, please read and send >>>>>>>> your feedback. >>>>>>>> >>>>>>>> http://apacheignite.gridgain.org/v1.3/docs/sql-queries >>>>>>>> >>>>>>>> Sergi >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> >> >> -- >> Alexey Kuznetsov >> GridGain Systems >> www.gridgain.com >> > > -- Alexey Kuznetsov GridGain Systems www.gridgain.com |
|
|
May be I dont address my question clearly.
yes, I notice this example, it's just a very simple to load data into cache. and all the "mapping" are in java code like this vals.add(new CacheTypeFieldMetadata("HOTELID", Types.INTEGER, "hotelId", Long.class)); or as format as xml my question can I just use annotation on the based pojo as below class Person { @QuerySqlField private String name; } as I prefer the annotation way for both init load and sql query. at least I can not find such example On Thu, Aug 20, 2015 at 1:11 AM, Alexey Kuznetsov <[hidden email]> wrote: > Ken, > > > https://github.com/apache/incubator-ignite/tree/master/examples/schema-import > > On Thu, Aug 20, 2015 at 12:04 AM, Ken Cheng <[hidden email]> wrote: > >> ---Also about XML - it is not mandatory, you can configure ALL by code. >> >> it's better to give an example with annotation, as right now I can not >> find such example. Thanks >> >> On Thu, Aug 20, 2015 at 12:19 AM, Alexey Kuznetsov < >> [hidden email]> wrote: >> >>> Ken, >>> >>> We have documentation for store. >>> >>> See: https://apacheignite.readme.io/docs/persistent-store >>> And: https://apacheignite.readme.io/docs/automatic-persistence >>> >>> Also take a look for example: examples\schema-import\README.txt >>> >>> There several bugs found with JdbcPojoStoreFactory and it seems for me >>> that issue you opened is the same as >>> https://issues.apache.org/jira/browse/IGNITE-1262 >>> >>> Andey Gura is working on it and AFAIK he should submit pull request in a >>> couple of days. >>> >>> I hope in next release you can work with jdbc store and queries. >>> >>> Also about XML - it is not mandatory, you can configure ALL by code. >>> >>> >>> On Wed, Aug 19, 2015 at 11:05 PM, Ken Cheng <[hidden email]> >>> wrote: >>> >>>> there is no such document address it as well no examples in the github. >>>> >>>> it's really appreciated you can supply a document and an example >>>> >>>> On Thu, Aug 20, 2015 at 12:03 AM, Ken Cheng <[hidden email]> >>>> wrote: >>>> >>>>> by the way I have fired a bug >>>>> https://issues.apache.org/jira/browse/IGNITE-1246, >>>>> it's about jdbcdata source in a cluster environment >>>>> >>>>> >>>>> On Wed, Aug 19, 2015 at 11:54 PM, Sergi Vladykin < >>>>> [hidden email]> wrote: >>>>> >>>>>> Ken, >>>>>> >>>>>> Jdbc store is a little bit separate beast, so I'd prefer keeping it's >>>>>> documentation separately from SQL queries section. >>>>>> But definitely you are right, we should have such a documentation >>>>>> with examples. >>>>>> >>>>>> Sergi >>>>>> >>>>>> 2015-08-19 18:40 GMT+03:00 Ken Cheng <[hidden email]>: >>>>>> >>>>>>> It's really nice, but it's better to have an examples to load data >>>>>>> from jdbc store with annotation. >>>>>>> >>>>>>> On Wed, Aug 19, 2015 at 7:04 PM, Yakov Zhdanov <[hidden email]> >>>>>>> wrote: >>>>>>> >>>>>>>> I like the article. >>>>>>>> >>>>>>>> Couple of points, though: >>>>>>>> 1. Annotations and XML configs are not identical. XML states that >>>>>>>> ID is UUID, but annotations listing states that it is primitive long. >>>>>>>> 2. I would prefer example that example can be copied-and-pasted and >>>>>>>> launched. Can we add cache config, indexes, and cache loading? >>>>>>>> 3. Need more accent on necessity of indexed types configuration. >>>>>>>> Can you put this into code box? >>>>>>>> >>>>>>>> >>>>>>>> --Yakov >>>>>>>> >>>>>>>> 2015-08-19 10:18 GMT+03:00 Sergi Vladykin <[hidden email] >>>>>>>> >: >>>>>>>> >>>>>>>>> Guys, >>>>>>>>> >>>>>>>>> I've just updated SQL Queries documentation, please read and send >>>>>>>>> your feedback. >>>>>>>>> >>>>>>>>> http://apacheignite.gridgain.org/v1.3/docs/sql-queries >>>>>>>>> >>>>>>>>> Sergi >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >>> >>> -- >>> Alexey Kuznetsov >>> GridGain Systems >>> www.gridgain.com >>> >> >> > > > -- > Alexey Kuznetsov > GridGain Systems > www.gridgain.com > |
Re: SQL Query Docs Updated
|
|
Ken,
Now I see what do you expect. The answer will be - NO. For now Ignite does not have such annotations to configure loading from store. But I think we should add them. I created issue for that: https://issues.apache.org/jira/browse/IGNITE-1271 On Thu, Aug 20, 2015 at 12:46 AM, Ken Cheng <[hidden email]> wrote: > May be I dont address my question clearly. > > yes, I notice this example, it's just a very simple to load data into > cache. > > and all the "mapping" are in java code like this > > vals.add(new CacheTypeFieldMetadata("HOTELID", Types.INTEGER, "hotelId", > Long.class)); > > or as format as xml > > my question can I just use annotation on the based pojo as below > > class Person { > > @QuerySqlField > > private String name; > > } > > > as I prefer the annotation way for both init load and sql query. > > > at least I can not find such example > > > > On Thu, Aug 20, 2015 at 1:11 AM, Alexey Kuznetsov <[hidden email] > > wrote: > >> Ken, >> >> >> https://github.com/apache/incubator-ignite/tree/master/examples/schema-import >> >> On Thu, Aug 20, 2015 at 12:04 AM, Ken Cheng <[hidden email]> wrote: >> >>> ---Also about XML - it is not mandatory, you can configure ALL by code. >>> >>> it's better to give an example with annotation, as right now I can not >>> find such example. Thanks >>> >>> On Thu, Aug 20, 2015 at 12:19 AM, Alexey Kuznetsov < >>> [hidden email]> wrote: >>> >>>> Ken, >>>> >>>> We have documentation for store. >>>> >>>> See: https://apacheignite.readme.io/docs/persistent-store >>>> And: https://apacheignite.readme.io/docs/automatic-persistence >>>> >>>> Also take a look for example: examples\schema-import\README.txt >>>> >>>> There several bugs found with JdbcPojoStoreFactory and it seems for me >>>> that issue you opened is the same as >>>> https://issues.apache.org/jira/browse/IGNITE-1262 >>>> >>>> Andey Gura is working on it and AFAIK he should submit pull request in >>>> a couple of days. >>>> >>>> I hope in next release you can work with jdbc store and queries. >>>> >>>> Also about XML - it is not mandatory, you can configure ALL by code. >>>> >>>> >>>> On Wed, Aug 19, 2015 at 11:05 PM, Ken Cheng <[hidden email]> >>>> wrote: >>>> >>>>> there is no such document address it as well no examples in the github. >>>>> >>>>> it's really appreciated you can supply a document and an example >>>>> >>>>> On Thu, Aug 20, 2015 at 12:03 AM, Ken Cheng <[hidden email]> >>>>> wrote: >>>>> >>>>>> by the way I have fired a bug >>>>>> https://issues.apache.org/jira/browse/IGNITE-1246, >>>>>> it's about jdbcdata source in a cluster environment >>>>>> >>>>>> >>>>>> On Wed, Aug 19, 2015 at 11:54 PM, Sergi Vladykin < >>>>>> [hidden email]> wrote: >>>>>> >>>>>>> Ken, >>>>>>> >>>>>>> Jdbc store is a little bit separate beast, so I'd prefer keeping >>>>>>> it's documentation separately from SQL queries section. >>>>>>> But definitely you are right, we should have such a documentation >>>>>>> with examples. >>>>>>> >>>>>>> Sergi >>>>>>> >>>>>>> 2015-08-19 18:40 GMT+03:00 Ken Cheng <[hidden email]>: >>>>>>> >>>>>>>> It's really nice, but it's better to have an examples to load data >>>>>>>> from jdbc store with annotation. >>>>>>>> >>>>>>>> On Wed, Aug 19, 2015 at 7:04 PM, Yakov Zhdanov <[hidden email] >>>>>>>> > wrote: >>>>>>>> >>>>>>>>> I like the article. >>>>>>>>> >>>>>>>>> Couple of points, though: >>>>>>>>> 1. Annotations and XML configs are not identical. XML states that >>>>>>>>> ID is UUID, but annotations listing states that it is primitive long. >>>>>>>>> 2. I would prefer example that example can be copied-and-pasted >>>>>>>>> and launched. Can we add cache config, indexes, and cache loading? >>>>>>>>> 3. Need more accent on necessity of indexed types configuration. >>>>>>>>> Can you put this into code box? >>>>>>>>> >>>>>>>>> >>>>>>>>> --Yakov >>>>>>>>> >>>>>>>>> 2015-08-19 10:18 GMT+03:00 Sergi Vladykin < >>>>>>>>> [hidden email]>: >>>>>>>>> >>>>>>>>>> Guys, >>>>>>>>>> >>>>>>>>>> I've just updated SQL Queries documentation, please read and send >>>>>>>>>> your feedback. >>>>>>>>>> >>>>>>>>>> http://apacheignite.gridgain.org/v1.3/docs/sql-queries >>>>>>>>>> >>>>>>>>>> Sergi >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>>> >>>> -- >>>> Alexey Kuznetsov >>>> GridGain Systems >>>> www.gridgain.com >>>> >>> >>> >> >> >> -- >> Alexey Kuznetsov >> GridGain Systems >> www.gridgain.com >> > > -- Alexey Kuznetsov GridGain Systems www.gridgain.com |
|
|
Thank you very much!
By the way, I want to contribute to the project. Are there any documents I can follow? On Thu, Aug 20, 2015 at 8:18 AM, Alexey Kuznetsov <[hidden email]> wrote: > Ken, > > Now I see what do you expect. > > The answer will be - NO. For now Ignite does not have such annotations to > configure loading from store. > > But I think we should add them. > > I created issue for that: > https://issues.apache.org/jira/browse/IGNITE-1271 > > On Thu, Aug 20, 2015 at 12:46 AM, Ken Cheng <[hidden email]> wrote: > >> May be I dont address my question clearly. >> >> yes, I notice this example, it's just a very simple to load data into >> cache. >> >> and all the "mapping" are in java code like this >> >> vals.add(new CacheTypeFieldMetadata("HOTELID", Types.INTEGER, "hotelId", >> Long.class)); >> >> or as format as xml >> >> my question can I just use annotation on the based pojo as below >> >> class Person { >> >> @QuerySqlField >> >> private String name; >> >> } >> >> >> as I prefer the annotation way for both init load and sql query. >> >> >> at least I can not find such example >> >> >> >> On Thu, Aug 20, 2015 at 1:11 AM, Alexey Kuznetsov < >> [hidden email]> wrote: >> >>> Ken, >>> >>> >>> https://github.com/apache/incubator-ignite/tree/master/examples/schema-import >>> >>> On Thu, Aug 20, 2015 at 12:04 AM, Ken Cheng <[hidden email]> >>> wrote: >>> >>>> ---Also about XML - it is not mandatory, you can configure ALL by code. >>>> >>>> it's better to give an example with annotation, as right now I can not >>>> find such example. Thanks >>>> >>>> On Thu, Aug 20, 2015 at 12:19 AM, Alexey Kuznetsov < >>>> [hidden email]> wrote: >>>> >>>>> Ken, >>>>> >>>>> We have documentation for store. >>>>> >>>>> See: https://apacheignite.readme.io/docs/persistent-store >>>>> And: https://apacheignite.readme.io/docs/automatic-persistence >>>>> >>>>> Also take a look for example: examples\schema-import\README.txt >>>>> >>>>> There several bugs found with JdbcPojoStoreFactory and it seems for me >>>>> that issue you opened is the same as >>>>> https://issues.apache.org/jira/browse/IGNITE-1262 >>>>> >>>>> Andey Gura is working on it and AFAIK he should submit pull request in >>>>> a couple of days. >>>>> >>>>> I hope in next release you can work with jdbc store and queries. >>>>> >>>>> Also about XML - it is not mandatory, you can configure ALL by code. >>>>> >>>>> >>>>> On Wed, Aug 19, 2015 at 11:05 PM, Ken Cheng <[hidden email]> >>>>> wrote: >>>>> >>>>>> there is no such document address it as well no examples in the >>>>>> github. >>>>>> >>>>>> it's really appreciated you can supply a document and an example >>>>>> >>>>>> On Thu, Aug 20, 2015 at 12:03 AM, Ken Cheng <[hidden email]> >>>>>> wrote: >>>>>> >>>>>>> by the way I have fired a bug >>>>>>> https://issues.apache.org/jira/browse/IGNITE-1246, >>>>>>> it's about jdbcdata source in a cluster environment >>>>>>> >>>>>>> >>>>>>> On Wed, Aug 19, 2015 at 11:54 PM, Sergi Vladykin < >>>>>>> [hidden email]> wrote: >>>>>>> >>>>>>>> Ken, >>>>>>>> >>>>>>>> Jdbc store is a little bit separate beast, so I'd prefer keeping >>>>>>>> it's documentation separately from SQL queries section. >>>>>>>> But definitely you are right, we should have such a documentation >>>>>>>> with examples. >>>>>>>> >>>>>>>> Sergi >>>>>>>> >>>>>>>> 2015-08-19 18:40 GMT+03:00 Ken Cheng <[hidden email]>: >>>>>>>> >>>>>>>>> It's really nice, but it's better to have an examples to load data >>>>>>>>> from jdbc store with annotation. >>>>>>>>> >>>>>>>>> On Wed, Aug 19, 2015 at 7:04 PM, Yakov Zhdanov < >>>>>>>>> [hidden email]> wrote: >>>>>>>>> >>>>>>>>>> I like the article. >>>>>>>>>> >>>>>>>>>> Couple of points, though: >>>>>>>>>> 1. Annotations and XML configs are not identical. XML states that >>>>>>>>>> ID is UUID, but annotations listing states that it is primitive long. >>>>>>>>>> 2. I would prefer example that example can be copied-and-pasted >>>>>>>>>> and launched. Can we add cache config, indexes, and cache loading? >>>>>>>>>> 3. Need more accent on necessity of indexed types configuration. >>>>>>>>>> Can you put this into code box? >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> --Yakov >>>>>>>>>> >>>>>>>>>> 2015-08-19 10:18 GMT+03:00 Sergi Vladykin < >>>>>>>>>> [hidden email]>: >>>>>>>>>> >>>>>>>>>>> Guys, >>>>>>>>>>> >>>>>>>>>>> I've just updated SQL Queries documentation, please read and >>>>>>>>>>> send your feedback. >>>>>>>>>>> >>>>>>>>>>> http://apacheignite.gridgain.org/v1.3/docs/sql-queries >>>>>>>>>>> >>>>>>>>>>> Sergi >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Alexey Kuznetsov >>>>> GridGain Systems >>>>> www.gridgain.com >>>>> >>>> >>>> >>> >>> >>> -- >>> Alexey Kuznetsov >>> GridGain Systems >>> www.gridgain.com >>> >> >> > > > -- > Alexey Kuznetsov > GridGain Systems > www.gridgain.com > |
|
Hi Ken,
It is great that you are interested in contributing. Please find more information here: https://ignite.apache.org/community/contribute.html Once you get familiar with the Ignite development process, please pick a Jira ticket and email here, so someone could add you to the Ignite Jira as a contributor. Thanks, D. On Wed, Aug 19, 2015 at 7:56 PM, Ken Cheng <[hidden email]> wrote: > Thank you very much! > > By the way, I want to contribute to the project. Are there any documents I > can follow? > > On Thu, Aug 20, 2015 at 8:18 AM, Alexey Kuznetsov <[hidden email] > > wrote: > >> Ken, >> >> Now I see what do you expect. >> >> The answer will be - NO. For now Ignite does not have such annotations to >> configure loading from store. >> >> But I think we should add them. >> >> I created issue for that: >> https://issues.apache.org/jira/browse/IGNITE-1271 >> >> On Thu, Aug 20, 2015 at 12:46 AM, Ken Cheng <[hidden email]> wrote: >> >>> May be I dont address my question clearly. >>> >>> yes, I notice this example, it's just a very simple to load data into >>> cache. >>> >>> and all the "mapping" are in java code like this >>> >>> vals.add(new CacheTypeFieldMetadata("HOTELID", Types.INTEGER, "hotelId", >>> Long.class)); >>> >>> or as format as xml >>> >>> my question can I just use annotation on the based pojo as below >>> >>> class Person { >>> >>> @QuerySqlField >>> >>> private String name; >>> >>> } >>> >>> >>> as I prefer the annotation way for both init load and sql query. >>> >>> >>> at least I can not find such example >>> >>> >>> >>> On Thu, Aug 20, 2015 at 1:11 AM, Alexey Kuznetsov < >>> [hidden email]> wrote: >>> >>>> Ken, >>>> >>>> >>>> https://github.com/apache/incubator-ignite/tree/master/examples/schema-import >>>> >>>> On Thu, Aug 20, 2015 at 12:04 AM, Ken Cheng <[hidden email]> >>>> wrote: >>>> >>>>> ---Also about XML - it is not mandatory, you can configure ALL by >>>>> code. >>>>> >>>>> it's better to give an example with annotation, as right now I can not >>>>> find such example. Thanks >>>>> >>>>> On Thu, Aug 20, 2015 at 12:19 AM, Alexey Kuznetsov < >>>>> [hidden email]> wrote: >>>>> >>>>>> Ken, >>>>>> >>>>>> We have documentation for store. >>>>>> >>>>>> See: https://apacheignite.readme.io/docs/persistent-store >>>>>> And: https://apacheignite.readme.io/docs/automatic-persistence >>>>>> >>>>>> Also take a look for example: examples\schema-import\README.txt >>>>>> >>>>>> There several bugs found with JdbcPojoStoreFactory and it seems for >>>>>> me that issue you opened is the same as >>>>>> https://issues.apache.org/jira/browse/IGNITE-1262 >>>>>> >>>>>> Andey Gura is working on it and AFAIK he should submit pull request >>>>>> in a couple of days. >>>>>> >>>>>> I hope in next release you can work with jdbc store and queries. >>>>>> >>>>>> Also about XML - it is not mandatory, you can configure ALL by code. >>>>>> >>>>>> >>>>>> On Wed, Aug 19, 2015 at 11:05 PM, Ken Cheng <[hidden email]> >>>>>> wrote: >>>>>> >>>>>>> there is no such document address it as well no examples in the >>>>>>> github. >>>>>>> >>>>>>> it's really appreciated you can supply a document and an example >>>>>>> >>>>>>> On Thu, Aug 20, 2015 at 12:03 AM, Ken Cheng <[hidden email]> >>>>>>> wrote: >>>>>>> >>>>>>>> by the way I have fired a bug >>>>>>>> https://issues.apache.org/jira/browse/IGNITE-1246, >>>>>>>> it's about jdbcdata source in a cluster environment >>>>>>>> >>>>>>>> >>>>>>>> On Wed, Aug 19, 2015 at 11:54 PM, Sergi Vladykin < >>>>>>>> [hidden email]> wrote: >>>>>>>> >>>>>>>>> Ken, >>>>>>>>> >>>>>>>>> Jdbc store is a little bit separate beast, so I'd prefer keeping >>>>>>>>> it's documentation separately from SQL queries section. >>>>>>>>> But definitely you are right, we should have such a documentation >>>>>>>>> with examples. >>>>>>>>> >>>>>>>>> Sergi >>>>>>>>> >>>>>>>>> 2015-08-19 18:40 GMT+03:00 Ken Cheng <[hidden email]>: >>>>>>>>> >>>>>>>>>> It's really nice, but it's better to have an examples to load >>>>>>>>>> data from jdbc store with annotation. >>>>>>>>>> >>>>>>>>>> On Wed, Aug 19, 2015 at 7:04 PM, Yakov Zhdanov < >>>>>>>>>> [hidden email]> wrote: >>>>>>>>>> >>>>>>>>>>> I like the article. >>>>>>>>>>> >>>>>>>>>>> Couple of points, though: >>>>>>>>>>> 1. Annotations and XML configs are not identical. XML states >>>>>>>>>>> that ID is UUID, but annotations listing states that it is primitive long. >>>>>>>>>>> 2. I would prefer example that example can be copied-and-pasted >>>>>>>>>>> and launched. Can we add cache config, indexes, and cache loading? >>>>>>>>>>> 3. Need more accent on necessity of indexed types configuration. >>>>>>>>>>> Can you put this into code box? >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> --Yakov >>>>>>>>>>> >>>>>>>>>>> 2015-08-19 10:18 GMT+03:00 Sergi Vladykin < >>>>>>>>>>> [hidden email]>: >>>>>>>>>>> >>>>>>>>>>>> Guys, >>>>>>>>>>>> >>>>>>>>>>>> I've just updated SQL Queries documentation, please read and >>>>>>>>>>>> send your feedback. >>>>>>>>>>>> >>>>>>>>>>>> http://apacheignite.gridgain.org/v1.3/docs/sql-queries >>>>>>>>>>>> >>>>>>>>>>>> Sergi >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Alexey Kuznetsov >>>>>> GridGain Systems >>>>>> www.gridgain.com >>>>>> >>>>> >>>>> >>>> >>>> >>>> -- >>>> Alexey Kuznetsov >>>> GridGain Systems >>>> www.gridgain.com >>>> >>> >>> >> >> >> -- >> Alexey Kuznetsov >> GridGain Systems >> www.gridgain.com >> > > |
«
Return to Apache Ignite Developers - Legacy Mail Archive
|
1 view|%1 views
| Free forum by Nabble | Edit this page |