SQL Query Docs Updated

classic Classic list List threaded Threaded
16 messages Options
Sergi Vladykin Sergi Vladykin
Reply | Threaded
Open this post in threaded view
|

SQL Query Docs Updated

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 Alexey Kuznetsov
Reply | Threaded
Open this post in threaded view
|

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
yakov yakov
Reply | Threaded
Open this post in threaded view
|

Re: SQL Query Docs Updated

In reply to this post by Sergi Vladykin
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

kcheng.mvp kcheng.mvp
Reply | Threaded
Open this post in threaded view
|

Re: SQL Query Docs Updated

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


Sergi Vladykin Sergi Vladykin
Reply | Threaded
Open this post in threaded view
|

Re: SQL Query Docs Updated

In reply to this post by yakov
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
>

Sergi Vladykin Sergi Vladykin
Reply | Threaded
Open this post in threaded view
|

Re: SQL Query Docs Updated

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



kcheng.mvp kcheng.mvp
Reply | Threaded
Open this post in threaded view
|

Re: SQL Query Docs Updated

Sergi,

Thank your quick reply very much, in the sql query section, i noticed there are two ways: one is using xml configuration, the other is using annotation.

right now my case I need to init the cache from jdbc datasource, so I think the annotation should be used in this case to tell how the data is indexed and which filed could be queried with annotation.

is my understanding right?

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




kcheng.mvp kcheng.mvp
Reply | Threaded
Open this post in threaded view
|

Re: SQL Query Docs Updated

In reply to this post by Sergi Vladykin
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




kcheng.mvp kcheng.mvp
Reply | Threaded
Open this post in threaded view
|

Re: SQL Query Docs Updated

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 Alexey Kuznetsov
Reply | Threaded
Open this post in threaded view
|

Re: SQL Query Docs Updated

Ken, 

We have documentation for store.


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
kcheng.mvp kcheng.mvp
Reply | Threaded
Open this post in threaded view
|

Re: SQL Query Docs Updated

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


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 Alexey Kuznetsov
Reply | Threaded
Open this post in threaded view
|

Re: SQL Query Docs Updated


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.


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
kcheng.mvp kcheng.mvp
Reply | Threaded
Open this post in threaded view
|

Re: SQL Query Docs Updated

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:

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.


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 Alexey Kuznetsov
Reply | Threaded
Open this post in threaded view
|

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.


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:

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.


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
kcheng.mvp kcheng.mvp
Reply | Threaded
Open this post in threaded view
|

Re: SQL Query Docs Updated

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.


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:

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.


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

dsetrakyan dsetrakyan
Reply | Threaded
Open this post in threaded view
|

Re: SQL Query Docs Updated

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.


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:

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.


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