Igniters,
There is a lot of SQL related documentation available for Ignite. However, the one can get lost in it when he/she does her first steps on a learning path. It’s time to simplify these are first steps with a clear and straightforward getting started guide. I’ve put the requirements into this JIRA ticket: https://issues.apache.org/jira/browse/IGNITE-5886 <https://issues.apache.org/jira/browse/IGNITE-5886> Please share your thoughts in JIRA or in this discussion. Akmal, who perfected his technical writer skills working for IBM, volunteered to take over this task. Akmal, please create an account in Ignite JIRA and share it with us. You’ll be able to assign the task on yourself afterwards. https://issues.apache.org/jira/projects/IGNITE <https://issues.apache.org/jira/projects/IGNITE> Moreover, once the guide is ready Prachi will use it as a basis for the new SQL screencast we need to produce. — Denis |
Denis, All:
Jira account details: Username: abchaudhri Email: akmal.chaudhri AT gridgain.com Full Name: Akmal Chaudhri Thank you. On 31 July 2017 at 19:02, Denis Magda <[hidden email]> wrote: > Igniters, > > There is a lot of SQL related documentation available for Ignite. However, > the one can get lost in it when he/she does her first steps on a learning > path. It’s time to simplify these are first steps with a clear and > straightforward getting started guide. I’ve put the requirements into this > JIRA ticket: > https://issues.apache.org/jira/browse/IGNITE-5886 > > Please share your thoughts in JIRA or in this discussion. > > Akmal, who perfected his technical writer skills working for IBM, > volunteered to take over this task. Akmal, please create an account in > Ignite JIRA and share it with us. You’ll be able to assign the task on > yourself afterwards. > https://issues.apache.org/jira/projects/IGNITE > > Moreover, once the guide is ready Prachi will use it as a basis for the > new SQL screencast we need to produce. > > — > Denis > |
Akmal,
The contributor permissions are granted in JIRA. Please go ahead and assign the ticket on yourself. Keep us posted on the progress and don’t hesitate raising any questions if you face troubles. — Denis > On Aug 2, 2017, at 7:17 AM, Akmal Chaudhri <[hidden email]> wrote: > > Denis, All: > > Jira account details: > > Username: abchaudhri > Email: akmal.chaudhri AT gridgain.com > Full Name: Akmal Chaudhri > > Thank you. > > On 31 July 2017 at 19:02, Denis Magda <[hidden email]> wrote: > >> Igniters, >> >> There is a lot of SQL related documentation available for Ignite. However, >> the one can get lost in it when he/she does her first steps on a learning >> path. It’s time to simplify these are first steps with a clear and >> straightforward getting started guide. I’ve put the requirements into this >> JIRA ticket: >> https://issues.apache.org/jira/browse/IGNITE-5886 >> >> Please share your thoughts in JIRA or in this discussion. >> >> Akmal, who perfected his technical writer skills working for IBM, >> volunteered to take over this task. Akmal, please create an account in >> Ignite JIRA and share it with us. You’ll be able to assign the task on >> yourself afterwards. >> https://issues.apache.org/jira/projects/IGNITE >> >> Moreover, once the guide is ready Prachi will use it as a basis for the >> new SQL screencast we need to produce. >> >> — >> Denis >> |
In reply to this post by dmagda
Denis, All
I have made some progress with the documentation: https://apacheignite.readme.io/v2.1/docs/getting-started-sql ODBC connectivity and examples are missing, but should be completed very soon. Community feedback welcome. Thanks. On 31 July 2017 at 19:02, Denis Magda <[hidden email]> wrote: > Igniters, > > There is a lot of SQL related documentation available for Ignite. However, > the one can get lost in it when he/she does her first steps on a learning > path. It’s time to simplify these are first steps with a clear and > straightforward getting started guide. I’ve put the requirements into this > JIRA ticket: > https://issues.apache.org/jira/browse/IGNITE-5886 > > Please share your thoughts in JIRA or in this discussion. > > Akmal, who perfected his technical writer skills working for IBM, > volunteered to take over this task. Akmal, please create an account in > Ignite JIRA and share it with us. You’ll be able to assign the task on > yourself afterwards. > https://issues.apache.org/jira/projects/IGNITE > > Moreover, once the guide is ready Prachi will use it as a basis for the > new SQL screencast we need to produce. > > — > Denis > |
Akmal,
Good start! Please consider the following feedback: 1. Connectivity section. Emphasize that ignite-core.jar has to be copied to the classpath of an app or tool and give a link to more advanced JDBC Thin driver documentation if the one needs more details. Probably, similar steps should be brought up for the ODBC once it’s ready. 2. Make the first letters of city and people tables uppercase: city -> City, people -> People 3. Rename INSERT section to “Inserting Data”, SELECT to “Querying Data”, UPDATE -> “Modifying Data”, DELETE to “Removing Data” or to better alternatives. 4. Show how to insert at least 2 cities and 5 people in the INSERT section. — Denis > On Aug 11, 2017, at 10:42 AM, Akmal Chaudhri <[hidden email]> wrote: > > Denis, All > > I have made some progress with the documentation: > > https://apacheignite.readme.io/v2.1/docs/getting-started-sql <https://apacheignite.readme.io/v2.1/docs/getting-started-sql> > > ODBC connectivity and examples are missing, but should be completed very soon. > > Community feedback welcome. > > Thanks. > > On 31 July 2017 at 19:02, Denis Magda <[hidden email] <mailto:[hidden email]>> wrote: > Igniters, > > There is a lot of SQL related documentation available for Ignite. However, the one can get lost in it when he/she does her first steps on a learning path. It’s time to simplify these are first steps with a clear and straightforward getting started guide. I’ve put the requirements into this JIRA ticket: > https://issues.apache.org/jira/browse/IGNITE-5886 <https://issues.apache.org/jira/browse/IGNITE-5886> > > Please share your thoughts in JIRA or in this discussion. > > Akmal, who perfected his technical writer skills working for IBM, volunteered to take over this task. Akmal, please create an account in Ignite JIRA and share it with us. You’ll be able to assign the task on yourself afterwards. > https://issues.apache.org/jira/projects/IGNITE <https://issues.apache.org/jira/projects/IGNITE> > > Moreover, once the guide is ready Prachi will use it as a basis for the new SQL screencast we need to produce. > > — > Denis > |
Igniters,
The SQL getting started guide is ready and published: https://apacheignite.readme.io/v2.1/docs/getting-started-sql <https://apacheignite.readme.io/v2.1/docs/getting-started-sql> Akmal thanks for your efforts and please apply the following minor changes: * Add ODBC source files to your GitHub project. * Add a flat SQL file (script) to the same project that will include all the pure SQL statements used in the guide. Basing on this guide I’ve prepared and release a guide for DBeaver SQL tool: https://apacheignite-tools.readme.io/docs/dbeaver <https://apacheignite-tools.readme.io/docs/dbeaver> — Denis > On Aug 11, 2017, at 3:17 PM, Denis Magda <[hidden email]> wrote: > > Akmal, > > Good start! Please consider the following feedback: > > 1. Connectivity section. Emphasize that ignite-core.jar has to be copied to the classpath of an app or tool and give a link to more advanced JDBC Thin driver documentation if the one needs more details. Probably, similar steps should be brought up for the ODBC once it’s ready. > > 2. Make the first letters of city and people tables uppercase: city -> City, people -> People > > 3. Rename INSERT section to “Inserting Data”, SELECT to “Querying Data”, UPDATE -> “Modifying Data”, DELETE to “Removing Data” or to better alternatives. > > 4. Show how to insert at least 2 cities and 5 people in the INSERT section. > > — > Denis > >> On Aug 11, 2017, at 10:42 AM, Akmal Chaudhri <[hidden email]> wrote: >> >> Denis, All >> >> I have made some progress with the documentation: >> >> https://apacheignite.readme.io/v2.1/docs/getting-started-sql <https://apacheignite.readme.io/v2.1/docs/getting-started-sql> >> >> ODBC connectivity and examples are missing, but should be completed very soon. >> >> Community feedback welcome. >> >> Thanks. >> >> On 31 July 2017 at 19:02, Denis Magda <[hidden email] <mailto:[hidden email]>> wrote: >> Igniters, >> >> There is a lot of SQL related documentation available for Ignite. However, the one can get lost in it when he/she does her first steps on a learning path. It’s time to simplify these are first steps with a clear and straightforward getting started guide. I’ve put the requirements into this JIRA ticket: >> https://issues.apache.org/jira/browse/IGNITE-5886 <https://issues.apache.org/jira/browse/IGNITE-5886> >> >> Please share your thoughts in JIRA or in this discussion. >> >> Akmal, who perfected his technical writer skills working for IBM, volunteered to take over this task. Akmal, please create an account in Ignite JIRA and share it with us. You’ll be able to assign the task on yourself afterwards. >> https://issues.apache.org/jira/projects/IGNITE <https://issues.apache.org/jira/projects/IGNITE> >> >> Moreover, once the guide is ready Prachi will use it as a basis for the new SQL screencast we need to produce. >> >> — >> Denis >> > |
When I have the opportunity to test the ODBC code and ensure that it
performs, I will add it to GH. At the moment, just snippets exist. If anyone can assist with this, I would appreciate it, as I have no experience with ODBC. I made some efforts to build the ODBC driver and have had some success on Windows and Linux, but have been unable to run any C++ code. On 16 August 2017 at 21:41, Denis Magda <[hidden email]> wrote: > Igniters, > > The SQL getting started guide is ready and published: > https://apacheignite.readme.io/v2.1/docs/getting-started-sql > > Akmal thanks for your efforts and please apply the following minor changes: > * Add ODBC source files to your GitHub project. > * Add a flat SQL file (script) to the same project that will include all > the pure SQL statements used in the guide. > > Basing on this guide I’ve prepared and release a guide for DBeaver SQL > tool: > https://apacheignite-tools.readme.io/docs/dbeaver > > — > Denis > > On Aug 11, 2017, at 3:17 PM, Denis Magda <[hidden email]> wrote: > > Akmal, > > Good start! Please consider the following feedback: > > 1. Connectivity section. Emphasize that ignite-core.jar has to be copied > to the classpath of an app or tool and give a link to more advanced JDBC > Thin driver documentation if the one needs more details. Probably, similar > steps should be brought up for the ODBC once it’s ready. > > 2. Make the first letters of city and people tables uppercase: city -> > City, people -> People > > 3. Rename INSERT section to “Inserting Data”, SELECT to “Querying Data”, > UPDATE -> “Modifying Data”, DELETE to “Removing Data” or to better > alternatives. > > 4. Show how to insert at least 2 cities and 5 people in the INSERT section. > > — > Denis > > On Aug 11, 2017, at 10:42 AM, Akmal Chaudhri <[hidden email]> > wrote: > > Denis, All > > I have made some progress with the documentation: > > https://apacheignite.readme.io/v2.1/docs/getting-started-sql < > https://apacheignite.readme.io/v2.1/docs/getting-started-sql> > > ODBC connectivity and examples are missing, but should be completed very > soon. > > Community feedback welcome. > > Thanks. > > On 31 July 2017 at 19:02, Denis Magda <[hidden email] < > mailto:[hidden email] <[hidden email]>>> wrote: > Igniters, > > There is a lot of SQL related documentation available for Ignite. However, > the one can get lost in it when he/she does her first steps on a learning > path. It’s time to simplify these are first steps with a clear and > straightforward getting started guide. I’ve put the requirements into this > JIRA ticket: > https://issues.apache.org/jira/browse/IGNITE-5886 < > https://issues.apache.org/jira/browse/IGNITE-5886> > > Please share your thoughts in JIRA or in this discussion. > > Akmal, who perfected his technical writer skills working for IBM, > volunteered to take over this task. Akmal, please create an account in > Ignite JIRA and share it with us. You’ll be able to assign the task on > yourself afterwards. > https://issues.apache.org/jira/projects/IGNITE <https://issues.apache.org/ > jira/projects/IGNITE> > > Moreover, once the guide is ready Prachi will use it as a basis for the > new SQL screencast we need to produce. > > — > Denis > > > > |
Akmal,
I work on the ODBC driver and would be glad to help. You can send mails with your requests to devlist and I will try to help as much as I can. Best Regards, Igor On Thu, Aug 17, 2017 at 3:28 PM, Akmal Chaudhri <[hidden email] > wrote: > When I have the opportunity to test the ODBC code and ensure that it > performs, I will add it to GH. At the moment, just snippets exist. If > anyone can assist with this, I would appreciate it, as I have no experience > with ODBC. I made some efforts to build the ODBC driver and have had some > success on Windows and Linux, but have been unable to run any C++ code. > > On 16 August 2017 at 21:41, Denis Magda <[hidden email]> wrote: > > > Igniters, > > > > The SQL getting started guide is ready and published: > > https://apacheignite.readme.io/v2.1/docs/getting-started-sql > > > > Akmal thanks for your efforts and please apply the following minor > changes: > > * Add ODBC source files to your GitHub project. > > * Add a flat SQL file (script) to the same project that will include all > > the pure SQL statements used in the guide. > > > > Basing on this guide I’ve prepared and release a guide for DBeaver SQL > > tool: > > https://apacheignite-tools.readme.io/docs/dbeaver > > > > — > > Denis > > > > On Aug 11, 2017, at 3:17 PM, Denis Magda <[hidden email]> wrote: > > > > Akmal, > > > > Good start! Please consider the following feedback: > > > > 1. Connectivity section. Emphasize that ignite-core.jar has to be copied > > to the classpath of an app or tool and give a link to more advanced JDBC > > Thin driver documentation if the one needs more details. Probably, > similar > > steps should be brought up for the ODBC once it’s ready. > > > > 2. Make the first letters of city and people tables uppercase: city -> > > City, people -> People > > > > 3. Rename INSERT section to “Inserting Data”, SELECT to “Querying Data”, > > UPDATE -> “Modifying Data”, DELETE to “Removing Data” or to better > > alternatives. > > > > 4. Show how to insert at least 2 cities and 5 people in the INSERT > section. > > > > — > > Denis > > > > On Aug 11, 2017, at 10:42 AM, Akmal Chaudhri < > [hidden email]> > > wrote: > > > > Denis, All > > > > I have made some progress with the documentation: > > > > https://apacheignite.readme.io/v2.1/docs/getting-started-sql < > > https://apacheignite.readme.io/v2.1/docs/getting-started-sql> > > > > ODBC connectivity and examples are missing, but should be completed very > > soon. > > > > Community feedback welcome. > > > > Thanks. > > > > On 31 July 2017 at 19:02, Denis Magda <[hidden email] < > > mailto:[hidden email] <[hidden email]>>> wrote: > > Igniters, > > > > There is a lot of SQL related documentation available for Ignite. > However, > > the one can get lost in it when he/she does her first steps on a learning > > path. It’s time to simplify these are first steps with a clear and > > straightforward getting started guide. I’ve put the requirements into > this > > JIRA ticket: > > https://issues.apache.org/jira/browse/IGNITE-5886 < > > https://issues.apache.org/jira/browse/IGNITE-5886> > > > > Please share your thoughts in JIRA or in this discussion. > > > > Akmal, who perfected his technical writer skills working for IBM, > > volunteered to take over this task. Akmal, please create an account in > > Ignite JIRA and share it with us. You’ll be able to assign the task on > > yourself afterwards. > > https://issues.apache.org/jira/projects/IGNITE < > https://issues.apache.org/ > > jira/projects/IGNITE> > > > > Moreover, once the guide is ready Prachi will use it as a basis for the > > new SQL screencast we need to produce. > > > > — > > Denis > > > > > > > > > |
Igor,
Would you mind helping us to test the snippets? I do believe it will take you a couple of minutes since the environment is set up on your side. — Denis > On Aug 17, 2017, at 5:37 AM, Igor Sapego <[hidden email]> wrote: > > Akmal, > > I work on the ODBC driver and would be glad to help. You can send > mails with your requests to devlist and I will try to help as much as I > can. > > Best Regards, > Igor > > On Thu, Aug 17, 2017 at 3:28 PM, Akmal Chaudhri <[hidden email] >> wrote: > >> When I have the opportunity to test the ODBC code and ensure that it >> performs, I will add it to GH. At the moment, just snippets exist. If >> anyone can assist with this, I would appreciate it, as I have no experience >> with ODBC. I made some efforts to build the ODBC driver and have had some >> success on Windows and Linux, but have been unable to run any C++ code. >> >> On 16 August 2017 at 21:41, Denis Magda <[hidden email]> wrote: >> >>> Igniters, >>> >>> The SQL getting started guide is ready and published: >>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql >>> >>> Akmal thanks for your efforts and please apply the following minor >> changes: >>> * Add ODBC source files to your GitHub project. >>> * Add a flat SQL file (script) to the same project that will include all >>> the pure SQL statements used in the guide. >>> >>> Basing on this guide I’ve prepared and release a guide for DBeaver SQL >>> tool: >>> https://apacheignite-tools.readme.io/docs/dbeaver >>> >>> — >>> Denis >>> >>> On Aug 11, 2017, at 3:17 PM, Denis Magda <[hidden email]> wrote: >>> >>> Akmal, >>> >>> Good start! Please consider the following feedback: >>> >>> 1. Connectivity section. Emphasize that ignite-core.jar has to be copied >>> to the classpath of an app or tool and give a link to more advanced JDBC >>> Thin driver documentation if the one needs more details. Probably, >> similar >>> steps should be brought up for the ODBC once it’s ready. >>> >>> 2. Make the first letters of city and people tables uppercase: city -> >>> City, people -> People >>> >>> 3. Rename INSERT section to “Inserting Data”, SELECT to “Querying Data”, >>> UPDATE -> “Modifying Data”, DELETE to “Removing Data” or to better >>> alternatives. >>> >>> 4. Show how to insert at least 2 cities and 5 people in the INSERT >> section. >>> >>> — >>> Denis >>> >>> On Aug 11, 2017, at 10:42 AM, Akmal Chaudhri < >> [hidden email]> >>> wrote: >>> >>> Denis, All >>> >>> I have made some progress with the documentation: >>> >>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql < >>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql> >>> >>> ODBC connectivity and examples are missing, but should be completed very >>> soon. >>> >>> Community feedback welcome. >>> >>> Thanks. >>> >>> On 31 July 2017 at 19:02, Denis Magda <[hidden email] < >>> mailto:[hidden email] <[hidden email]>>> wrote: >>> Igniters, >>> >>> There is a lot of SQL related documentation available for Ignite. >> However, >>> the one can get lost in it when he/she does her first steps on a learning >>> path. It’s time to simplify these are first steps with a clear and >>> straightforward getting started guide. I’ve put the requirements into >> this >>> JIRA ticket: >>> https://issues.apache.org/jira/browse/IGNITE-5886 < >>> https://issues.apache.org/jira/browse/IGNITE-5886> >>> >>> Please share your thoughts in JIRA or in this discussion. >>> >>> Akmal, who perfected his technical writer skills working for IBM, >>> volunteered to take over this task. Akmal, please create an account in >>> Ignite JIRA and share it with us. You’ll be able to assign the task on >>> yourself afterwards. >>> https://issues.apache.org/jira/projects/IGNITE < >> https://issues.apache.org/ >>> jira/projects/IGNITE> >>> >>> Moreover, once the guide is ready Prachi will use it as a basis for the >>> new SQL screencast we need to produce. >>> >>> — >>> Denis >>> >>> >>> >>> >> |
I've checked ODBC snippets and fixed all found issues.
Best Regards, Igor On Thu, Aug 17, 2017 at 11:16 PM, Denis Magda <[hidden email]> wrote: > Igor, > > Would you mind helping us to test the snippets? I do believe it will take > you a couple of minutes since the environment is set up on your side. > > — > Denis > > > On Aug 17, 2017, at 5:37 AM, Igor Sapego <[hidden email]> wrote: > > > > Akmal, > > > > I work on the ODBC driver and would be glad to help. You can send > > mails with your requests to devlist and I will try to help as much as I > > can. > > > > Best Regards, > > Igor > > > > On Thu, Aug 17, 2017 at 3:28 PM, Akmal Chaudhri < > [hidden email] > >> wrote: > > > >> When I have the opportunity to test the ODBC code and ensure that it > >> performs, I will add it to GH. At the moment, just snippets exist. If > >> anyone can assist with this, I would appreciate it, as I have no > experience > >> with ODBC. I made some efforts to build the ODBC driver and have had > some > >> success on Windows and Linux, but have been unable to run any C++ code. > >> > >> On 16 August 2017 at 21:41, Denis Magda <[hidden email]> wrote: > >> > >>> Igniters, > >>> > >>> The SQL getting started guide is ready and published: > >>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql > >>> > >>> Akmal thanks for your efforts and please apply the following minor > >> changes: > >>> * Add ODBC source files to your GitHub project. > >>> * Add a flat SQL file (script) to the same project that will include > all > >>> the pure SQL statements used in the guide. > >>> > >>> Basing on this guide I’ve prepared and release a guide for DBeaver SQL > >>> tool: > >>> https://apacheignite-tools.readme.io/docs/dbeaver > >>> > >>> — > >>> Denis > >>> > >>> On Aug 11, 2017, at 3:17 PM, Denis Magda <[hidden email]> wrote: > >>> > >>> Akmal, > >>> > >>> Good start! Please consider the following feedback: > >>> > >>> 1. Connectivity section. Emphasize that ignite-core.jar has to be > copied > >>> to the classpath of an app or tool and give a link to more advanced > JDBC > >>> Thin driver documentation if the one needs more details. Probably, > >> similar > >>> steps should be brought up for the ODBC once it’s ready. > >>> > >>> 2. Make the first letters of city and people tables uppercase: city -> > >>> City, people -> People > >>> > >>> 3. Rename INSERT section to “Inserting Data”, SELECT to “Querying > Data”, > >>> UPDATE -> “Modifying Data”, DELETE to “Removing Data” or to better > >>> alternatives. > >>> > >>> 4. Show how to insert at least 2 cities and 5 people in the INSERT > >> section. > >>> > >>> — > >>> Denis > >>> > >>> On Aug 11, 2017, at 10:42 AM, Akmal Chaudhri < > >> [hidden email]> > >>> wrote: > >>> > >>> Denis, All > >>> > >>> I have made some progress with the documentation: > >>> > >>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql < > >>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql> > >>> > >>> ODBC connectivity and examples are missing, but should be completed > very > >>> soon. > >>> > >>> Community feedback welcome. > >>> > >>> Thanks. > >>> > >>> On 31 July 2017 at 19:02, Denis Magda <[hidden email] < > >>> mailto:[hidden email] <[hidden email]>>> wrote: > >>> Igniters, > >>> > >>> There is a lot of SQL related documentation available for Ignite. > >> However, > >>> the one can get lost in it when he/she does her first steps on a > learning > >>> path. It’s time to simplify these are first steps with a clear and > >>> straightforward getting started guide. I’ve put the requirements into > >> this > >>> JIRA ticket: > >>> https://issues.apache.org/jira/browse/IGNITE-5886 < > >>> https://issues.apache.org/jira/browse/IGNITE-5886> > >>> > >>> Please share your thoughts in JIRA or in this discussion. > >>> > >>> Akmal, who perfected his technical writer skills working for IBM, > >>> volunteered to take over this task. Akmal, please create an account in > >>> Ignite JIRA and share it with us. You’ll be able to assign the task on > >>> yourself afterwards. > >>> https://issues.apache.org/jira/projects/IGNITE < > >> https://issues.apache.org/ > >>> jira/projects/IGNITE> > >>> > >>> Moreover, once the guide is ready Prachi will use it as a basis for the > >>> new SQL screencast we need to produce. > >>> > >>> — > >>> Denis > >>> > >>> > >>> > >>> > >> > > |
Igor, thanks a lot. Appreciate this!
— Denis > On Aug 18, 2017, at 8:56 AM, Igor Sapego <[hidden email]> wrote: > > I've checked ODBC snippets and fixed all found issues. > > Best Regards, > Igor > > On Thu, Aug 17, 2017 at 11:16 PM, Denis Magda <[hidden email]> wrote: > >> Igor, >> >> Would you mind helping us to test the snippets? I do believe it will take >> you a couple of minutes since the environment is set up on your side. >> >> — >> Denis >> >>> On Aug 17, 2017, at 5:37 AM, Igor Sapego <[hidden email]> wrote: >>> >>> Akmal, >>> >>> I work on the ODBC driver and would be glad to help. You can send >>> mails with your requests to devlist and I will try to help as much as I >>> can. >>> >>> Best Regards, >>> Igor >>> >>> On Thu, Aug 17, 2017 at 3:28 PM, Akmal Chaudhri < >> [hidden email] >>>> wrote: >>> >>>> When I have the opportunity to test the ODBC code and ensure that it >>>> performs, I will add it to GH. At the moment, just snippets exist. If >>>> anyone can assist with this, I would appreciate it, as I have no >> experience >>>> with ODBC. I made some efforts to build the ODBC driver and have had >> some >>>> success on Windows and Linux, but have been unable to run any C++ code. >>>> >>>> On 16 August 2017 at 21:41, Denis Magda <[hidden email]> wrote: >>>> >>>>> Igniters, >>>>> >>>>> The SQL getting started guide is ready and published: >>>>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql >>>>> >>>>> Akmal thanks for your efforts and please apply the following minor >>>> changes: >>>>> * Add ODBC source files to your GitHub project. >>>>> * Add a flat SQL file (script) to the same project that will include >> all >>>>> the pure SQL statements used in the guide. >>>>> >>>>> Basing on this guide I’ve prepared and release a guide for DBeaver SQL >>>>> tool: >>>>> https://apacheignite-tools.readme.io/docs/dbeaver >>>>> >>>>> — >>>>> Denis >>>>> >>>>> On Aug 11, 2017, at 3:17 PM, Denis Magda <[hidden email]> wrote: >>>>> >>>>> Akmal, >>>>> >>>>> Good start! Please consider the following feedback: >>>>> >>>>> 1. Connectivity section. Emphasize that ignite-core.jar has to be >> copied >>>>> to the classpath of an app or tool and give a link to more advanced >> JDBC >>>>> Thin driver documentation if the one needs more details. Probably, >>>> similar >>>>> steps should be brought up for the ODBC once it’s ready. >>>>> >>>>> 2. Make the first letters of city and people tables uppercase: city -> >>>>> City, people -> People >>>>> >>>>> 3. Rename INSERT section to “Inserting Data”, SELECT to “Querying >> Data”, >>>>> UPDATE -> “Modifying Data”, DELETE to “Removing Data” or to better >>>>> alternatives. >>>>> >>>>> 4. Show how to insert at least 2 cities and 5 people in the INSERT >>>> section. >>>>> >>>>> — >>>>> Denis >>>>> >>>>> On Aug 11, 2017, at 10:42 AM, Akmal Chaudhri < >>>> [hidden email]> >>>>> wrote: >>>>> >>>>> Denis, All >>>>> >>>>> I have made some progress with the documentation: >>>>> >>>>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql < >>>>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql> >>>>> >>>>> ODBC connectivity and examples are missing, but should be completed >> very >>>>> soon. >>>>> >>>>> Community feedback welcome. >>>>> >>>>> Thanks. >>>>> >>>>> On 31 July 2017 at 19:02, Denis Magda <[hidden email] < >>>>> mailto:[hidden email] <[hidden email]>>> wrote: >>>>> Igniters, >>>>> >>>>> There is a lot of SQL related documentation available for Ignite. >>>> However, >>>>> the one can get lost in it when he/she does her first steps on a >> learning >>>>> path. It’s time to simplify these are first steps with a clear and >>>>> straightforward getting started guide. I’ve put the requirements into >>>> this >>>>> JIRA ticket: >>>>> https://issues.apache.org/jira/browse/IGNITE-5886 < >>>>> https://issues.apache.org/jira/browse/IGNITE-5886> >>>>> >>>>> Please share your thoughts in JIRA or in this discussion. >>>>> >>>>> Akmal, who perfected his technical writer skills working for IBM, >>>>> volunteered to take over this task. Akmal, please create an account in >>>>> Ignite JIRA and share it with us. You’ll be able to assign the task on >>>>> yourself afterwards. >>>>> https://issues.apache.org/jira/projects/IGNITE < >>>> https://issues.apache.org/ >>>>> jira/projects/IGNITE> >>>>> >>>>> Moreover, once the guide is ready Prachi will use it as a basis for the >>>>> new SQL screencast we need to produce. >>>>> >>>>> — >>>>> Denis >>>>> >>>>> >>>>> >>>>> >>>> >> >> |
Hi Igor,
The getting started guide is missing an example oh how to create a Person table (under ODBC tab). https://apacheignite.readme.io/docs/getting-started-sql#section-create-tables I am trying to put one on the website. Does the following look ok? // Create table based on PARTITIONED template with one backup SQLCHAR query[] = "CREATE TABLE Person ( " "id LONG, name VARCHAR, city_id LONG " "PRIMARY KEY (id, city_id)) " "WITH \"backups=1, affinityKey=city_id\""; SQLSMALLINT queryLen = static_cast<SQLSMALLINT>(sizeof(query)); SQLRETURN ret = SQLExecDirect(stmt, query, queryLen); On Fri, Aug 18, 2017 at 12:09 PM, Denis Magda <[hidden email]> wrote: > Igor, thanks a lot. Appreciate this! > > — > Denis > > > On Aug 18, 2017, at 8:56 AM, Igor Sapego <[hidden email]> wrote: > > > > I've checked ODBC snippets and fixed all found issues. > > > > Best Regards, > > Igor > > > > On Thu, Aug 17, 2017 at 11:16 PM, Denis Magda <[hidden email]> wrote: > > > >> Igor, > >> > >> Would you mind helping us to test the snippets? I do believe it will > take > >> you a couple of minutes since the environment is set up on your side. > >> > >> — > >> Denis > >> > >>> On Aug 17, 2017, at 5:37 AM, Igor Sapego <[hidden email]> wrote: > >>> > >>> Akmal, > >>> > >>> I work on the ODBC driver and would be glad to help. You can send > >>> mails with your requests to devlist and I will try to help as much as I > >>> can. > >>> > >>> Best Regards, > >>> Igor > >>> > >>> On Thu, Aug 17, 2017 at 3:28 PM, Akmal Chaudhri < > >> [hidden email] > >>>> wrote: > >>> > >>>> When I have the opportunity to test the ODBC code and ensure that it > >>>> performs, I will add it to GH. At the moment, just snippets exist. If > >>>> anyone can assist with this, I would appreciate it, as I have no > >> experience > >>>> with ODBC. I made some efforts to build the ODBC driver and have had > >> some > >>>> success on Windows and Linux, but have been unable to run any C++ > code. > >>>> > >>>> On 16 August 2017 at 21:41, Denis Magda <[hidden email]> wrote: > >>>> > >>>>> Igniters, > >>>>> > >>>>> The SQL getting started guide is ready and published: > >>>>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql > >>>>> > >>>>> Akmal thanks for your efforts and please apply the following minor > >>>> changes: > >>>>> * Add ODBC source files to your GitHub project. > >>>>> * Add a flat SQL file (script) to the same project that will include > >> all > >>>>> the pure SQL statements used in the guide. > >>>>> > >>>>> Basing on this guide I’ve prepared and release a guide for DBeaver > SQL > >>>>> tool: > >>>>> https://apacheignite-tools.readme.io/docs/dbeaver > >>>>> > >>>>> — > >>>>> Denis > >>>>> > >>>>> On Aug 11, 2017, at 3:17 PM, Denis Magda <[hidden email]> wrote: > >>>>> > >>>>> Akmal, > >>>>> > >>>>> Good start! Please consider the following feedback: > >>>>> > >>>>> 1. Connectivity section. Emphasize that ignite-core.jar has to be > >> copied > >>>>> to the classpath of an app or tool and give a link to more advanced > >> JDBC > >>>>> Thin driver documentation if the one needs more details. Probably, > >>>> similar > >>>>> steps should be brought up for the ODBC once it’s ready. > >>>>> > >>>>> 2. Make the first letters of city and people tables uppercase: city > -> > >>>>> City, people -> People > >>>>> > >>>>> 3. Rename INSERT section to “Inserting Data”, SELECT to “Querying > >> Data”, > >>>>> UPDATE -> “Modifying Data”, DELETE to “Removing Data” or to better > >>>>> alternatives. > >>>>> > >>>>> 4. Show how to insert at least 2 cities and 5 people in the INSERT > >>>> section. > >>>>> > >>>>> — > >>>>> Denis > >>>>> > >>>>> On Aug 11, 2017, at 10:42 AM, Akmal Chaudhri < > >>>> [hidden email]> > >>>>> wrote: > >>>>> > >>>>> Denis, All > >>>>> > >>>>> I have made some progress with the documentation: > >>>>> > >>>>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql < > >>>>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql> > >>>>> > >>>>> ODBC connectivity and examples are missing, but should be completed > >> very > >>>>> soon. > >>>>> > >>>>> Community feedback welcome. > >>>>> > >>>>> Thanks. > >>>>> > >>>>> On 31 July 2017 at 19:02, Denis Magda <[hidden email] < > >>>>> mailto:[hidden email] <[hidden email]>>> wrote: > >>>>> Igniters, > >>>>> > >>>>> There is a lot of SQL related documentation available for Ignite. > >>>> However, > >>>>> the one can get lost in it when he/she does her first steps on a > >> learning > >>>>> path. It’s time to simplify these are first steps with a clear and > >>>>> straightforward getting started guide. I’ve put the requirements into > >>>> this > >>>>> JIRA ticket: > >>>>> https://issues.apache.org/jira/browse/IGNITE-5886 < > >>>>> https://issues.apache.org/jira/browse/IGNITE-5886> > >>>>> > >>>>> Please share your thoughts in JIRA or in this discussion. > >>>>> > >>>>> Akmal, who perfected his technical writer skills working for IBM, > >>>>> volunteered to take over this task. Akmal, please create an account > in > >>>>> Ignite JIRA and share it with us. You’ll be able to assign the task > on > >>>>> yourself afterwards. > >>>>> https://issues.apache.org/jira/projects/IGNITE < > >>>> https://issues.apache.org/ > >>>>> jira/projects/IGNITE> > >>>>> > >>>>> Moreover, once the guide is ready Prachi will use it as a basis for > the > >>>>> new SQL screencast we need to produce. > >>>>> > >>>>> — > >>>>> Denis > >>>>> > >>>>> > >>>>> > >>>>> > >>>> > >> > >> > > |
Prachi,
Yeah, looks good. I've added creation of "Person" table to documentation, so take a look please. Best Regards, Igor On Fri, Aug 18, 2017 at 10:29 PM, Prachi Garg <[hidden email]> wrote: > Hi Igor, > > The getting started guide is missing an example oh how to create a Person > table (under ODBC tab). > https://apacheignite.readme.io/docs/getting-started-sql# > section-create-tables > > I am trying to put one on the website. Does the following look ok? > > // Create table based on PARTITIONED template with one backup > SQLCHAR query[] = "CREATE TABLE Person ( " > "id LONG, name VARCHAR, city_id LONG " > "PRIMARY KEY (id, city_id)) " > "WITH \"backups=1, affinityKey=city_id\""; > SQLSMALLINT queryLen = static_cast<SQLSMALLINT>(sizeof(query)); > > SQLRETURN ret = SQLExecDirect(stmt, query, queryLen); > > > On Fri, Aug 18, 2017 at 12:09 PM, Denis Magda <[hidden email]> wrote: > > > Igor, thanks a lot. Appreciate this! > > > > — > > Denis > > > > > On Aug 18, 2017, at 8:56 AM, Igor Sapego <[hidden email]> wrote: > > > > > > I've checked ODBC snippets and fixed all found issues. > > > > > > Best Regards, > > > Igor > > > > > > On Thu, Aug 17, 2017 at 11:16 PM, Denis Magda <[hidden email]> > wrote: > > > > > >> Igor, > > >> > > >> Would you mind helping us to test the snippets? I do believe it will > > take > > >> you a couple of minutes since the environment is set up on your side. > > >> > > >> — > > >> Denis > > >> > > >>> On Aug 17, 2017, at 5:37 AM, Igor Sapego <[hidden email]> wrote: > > >>> > > >>> Akmal, > > >>> > > >>> I work on the ODBC driver and would be glad to help. You can send > > >>> mails with your requests to devlist and I will try to help as much > as I > > >>> can. > > >>> > > >>> Best Regards, > > >>> Igor > > >>> > > >>> On Thu, Aug 17, 2017 at 3:28 PM, Akmal Chaudhri < > > >> [hidden email] > > >>>> wrote: > > >>> > > >>>> When I have the opportunity to test the ODBC code and ensure that it > > >>>> performs, I will add it to GH. At the moment, just snippets exist. > If > > >>>> anyone can assist with this, I would appreciate it, as I have no > > >> experience > > >>>> with ODBC. I made some efforts to build the ODBC driver and have had > > >> some > > >>>> success on Windows and Linux, but have been unable to run any C++ > > code. > > >>>> > > >>>> On 16 August 2017 at 21:41, Denis Magda <[hidden email]> wrote: > > >>>> > > >>>>> Igniters, > > >>>>> > > >>>>> The SQL getting started guide is ready and published: > > >>>>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql > > >>>>> > > >>>>> Akmal thanks for your efforts and please apply the following minor > > >>>> changes: > > >>>>> * Add ODBC source files to your GitHub project. > > >>>>> * Add a flat SQL file (script) to the same project that will > include > > >> all > > >>>>> the pure SQL statements used in the guide. > > >>>>> > > >>>>> Basing on this guide I’ve prepared and release a guide for DBeaver > > SQL > > >>>>> tool: > > >>>>> https://apacheignite-tools.readme.io/docs/dbeaver > > >>>>> > > >>>>> — > > >>>>> Denis > > >>>>> > > >>>>> On Aug 11, 2017, at 3:17 PM, Denis Magda <[hidden email]> > wrote: > > >>>>> > > >>>>> Akmal, > > >>>>> > > >>>>> Good start! Please consider the following feedback: > > >>>>> > > >>>>> 1. Connectivity section. Emphasize that ignite-core.jar has to be > > >> copied > > >>>>> to the classpath of an app or tool and give a link to more advanced > > >> JDBC > > >>>>> Thin driver documentation if the one needs more details. Probably, > > >>>> similar > > >>>>> steps should be brought up for the ODBC once it’s ready. > > >>>>> > > >>>>> 2. Make the first letters of city and people tables uppercase: city > > -> > > >>>>> City, people -> People > > >>>>> > > >>>>> 3. Rename INSERT section to “Inserting Data”, SELECT to “Querying > > >> Data”, > > >>>>> UPDATE -> “Modifying Data”, DELETE to “Removing Data” or to better > > >>>>> alternatives. > > >>>>> > > >>>>> 4. Show how to insert at least 2 cities and 5 people in the INSERT > > >>>> section. > > >>>>> > > >>>>> — > > >>>>> Denis > > >>>>> > > >>>>> On Aug 11, 2017, at 10:42 AM, Akmal Chaudhri < > > >>>> [hidden email]> > > >>>>> wrote: > > >>>>> > > >>>>> Denis, All > > >>>>> > > >>>>> I have made some progress with the documentation: > > >>>>> > > >>>>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql < > > >>>>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql> > > >>>>> > > >>>>> ODBC connectivity and examples are missing, but should be completed > > >> very > > >>>>> soon. > > >>>>> > > >>>>> Community feedback welcome. > > >>>>> > > >>>>> Thanks. > > >>>>> > > >>>>> On 31 July 2017 at 19:02, Denis Magda <[hidden email] < > > >>>>> mailto:[hidden email] <[hidden email]>>> wrote: > > >>>>> Igniters, > > >>>>> > > >>>>> There is a lot of SQL related documentation available for Ignite. > > >>>> However, > > >>>>> the one can get lost in it when he/she does her first steps on a > > >> learning > > >>>>> path. It’s time to simplify these are first steps with a clear and > > >>>>> straightforward getting started guide. I’ve put the requirements > into > > >>>> this > > >>>>> JIRA ticket: > > >>>>> https://issues.apache.org/jira/browse/IGNITE-5886 < > > >>>>> https://issues.apache.org/jira/browse/IGNITE-5886> > > >>>>> > > >>>>> Please share your thoughts in JIRA or in this discussion. > > >>>>> > > >>>>> Akmal, who perfected his technical writer skills working for IBM, > > >>>>> volunteered to take over this task. Akmal, please create an account > > in > > >>>>> Ignite JIRA and share it with us. You’ll be able to assign the task > > on > > >>>>> yourself afterwards. > > >>>>> https://issues.apache.org/jira/projects/IGNITE < > > >>>> https://issues.apache.org/ > > >>>>> jira/projects/IGNITE> > > >>>>> > > >>>>> Moreover, once the guide is ready Prachi will use it as a basis for > > the > > >>>>> new SQL screencast we need to produce. > > >>>>> > > >>>>> — > > >>>>> Denis > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>> > > >> > > >> > > > > > |
Igor, Pavel
On the website[1], I have added SQL, JDBC, ODBC, and Java API examples for DDL, DML and queries . I could not find DDL examples for .NET and C++ in the documentation. Please add the missing code snippets for .NET and C++ APIs taking SQL syntax from the Java API example. [1] https://ignite.apache.org/features/sql.html On Mon, Aug 21, 2017 at 3:28 AM, Igor Sapego <[hidden email]> wrote: > Prachi, > > Yeah, looks good. I've added creation of "Person" table to documentation, > so take a look please. > > Best Regards, > Igor > > On Fri, Aug 18, 2017 at 10:29 PM, Prachi Garg <[hidden email]> wrote: > > > Hi Igor, > > > > The getting started guide is missing an example oh how to create a Person > > table (under ODBC tab). > > https://apacheignite.readme.io/docs/getting-started-sql# > > section-create-tables > > > > I am trying to put one on the website. Does the following look ok? > > > > // Create table based on PARTITIONED template with one backup > > SQLCHAR query[] = "CREATE TABLE Person ( " > > "id LONG, name VARCHAR, city_id LONG " > > "PRIMARY KEY (id, city_id)) " > > "WITH \"backups=1, affinityKey=city_id\""; > > SQLSMALLINT queryLen = static_cast<SQLSMALLINT>(sizeof(query)); > > > > SQLRETURN ret = SQLExecDirect(stmt, query, queryLen); > > > > > > On Fri, Aug 18, 2017 at 12:09 PM, Denis Magda <[hidden email]> wrote: > > > > > Igor, thanks a lot. Appreciate this! > > > > > > — > > > Denis > > > > > > > On Aug 18, 2017, at 8:56 AM, Igor Sapego <[hidden email]> wrote: > > > > > > > > I've checked ODBC snippets and fixed all found issues. > > > > > > > > Best Regards, > > > > Igor > > > > > > > > On Thu, Aug 17, 2017 at 11:16 PM, Denis Magda <[hidden email]> > > wrote: > > > > > > > >> Igor, > > > >> > > > >> Would you mind helping us to test the snippets? I do believe it will > > > take > > > >> you a couple of minutes since the environment is set up on your > side. > > > >> > > > >> — > > > >> Denis > > > >> > > > >>> On Aug 17, 2017, at 5:37 AM, Igor Sapego <[hidden email]> > wrote: > > > >>> > > > >>> Akmal, > > > >>> > > > >>> I work on the ODBC driver and would be glad to help. You can send > > > >>> mails with your requests to devlist and I will try to help as much > > as I > > > >>> can. > > > >>> > > > >>> Best Regards, > > > >>> Igor > > > >>> > > > >>> On Thu, Aug 17, 2017 at 3:28 PM, Akmal Chaudhri < > > > >> [hidden email] > > > >>>> wrote: > > > >>> > > > >>>> When I have the opportunity to test the ODBC code and ensure that > it > > > >>>> performs, I will add it to GH. At the moment, just snippets exist. > > If > > > >>>> anyone can assist with this, I would appreciate it, as I have no > > > >> experience > > > >>>> with ODBC. I made some efforts to build the ODBC driver and have > had > > > >> some > > > >>>> success on Windows and Linux, but have been unable to run any C++ > > > code. > > > >>>> > > > >>>> On 16 August 2017 at 21:41, Denis Magda <[hidden email]> > wrote: > > > >>>> > > > >>>>> Igniters, > > > >>>>> > > > >>>>> The SQL getting started guide is ready and published: > > > >>>>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql > > > >>>>> > > > >>>>> Akmal thanks for your efforts and please apply the following > minor > > > >>>> changes: > > > >>>>> * Add ODBC source files to your GitHub project. > > > >>>>> * Add a flat SQL file (script) to the same project that will > > include > > > >> all > > > >>>>> the pure SQL statements used in the guide. > > > >>>>> > > > >>>>> Basing on this guide I’ve prepared and release a guide for > DBeaver > > > SQL > > > >>>>> tool: > > > >>>>> https://apacheignite-tools.readme.io/docs/dbeaver > > > >>>>> > > > >>>>> — > > > >>>>> Denis > > > >>>>> > > > >>>>> On Aug 11, 2017, at 3:17 PM, Denis Magda <[hidden email]> > > wrote: > > > >>>>> > > > >>>>> Akmal, > > > >>>>> > > > >>>>> Good start! Please consider the following feedback: > > > >>>>> > > > >>>>> 1. Connectivity section. Emphasize that ignite-core.jar has to be > > > >> copied > > > >>>>> to the classpath of an app or tool and give a link to more > advanced > > > >> JDBC > > > >>>>> Thin driver documentation if the one needs more details. > Probably, > > > >>>> similar > > > >>>>> steps should be brought up for the ODBC once it’s ready. > > > >>>>> > > > >>>>> 2. Make the first letters of city and people tables uppercase: > city > > > -> > > > >>>>> City, people -> People > > > >>>>> > > > >>>>> 3. Rename INSERT section to “Inserting Data”, SELECT to “Querying > > > >> Data”, > > > >>>>> UPDATE -> “Modifying Data”, DELETE to “Removing Data” or to > better > > > >>>>> alternatives. > > > >>>>> > > > >>>>> 4. Show how to insert at least 2 cities and 5 people in the > INSERT > > > >>>> section. > > > >>>>> > > > >>>>> — > > > >>>>> Denis > > > >>>>> > > > >>>>> On Aug 11, 2017, at 10:42 AM, Akmal Chaudhri < > > > >>>> [hidden email]> > > > >>>>> wrote: > > > >>>>> > > > >>>>> Denis, All > > > >>>>> > > > >>>>> I have made some progress with the documentation: > > > >>>>> > > > >>>>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql < > > > >>>>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql> > > > >>>>> > > > >>>>> ODBC connectivity and examples are missing, but should be > completed > > > >> very > > > >>>>> soon. > > > >>>>> > > > >>>>> Community feedback welcome. > > > >>>>> > > > >>>>> Thanks. > > > >>>>> > > > >>>>> On 31 July 2017 at 19:02, Denis Magda <[hidden email] < > > > >>>>> mailto:[hidden email] <[hidden email]>>> wrote: > > > >>>>> Igniters, > > > >>>>> > > > >>>>> There is a lot of SQL related documentation available for Ignite. > > > >>>> However, > > > >>>>> the one can get lost in it when he/she does her first steps on a > > > >> learning > > > >>>>> path. It’s time to simplify these are first steps with a clear > and > > > >>>>> straightforward getting started guide. I’ve put the requirements > > into > > > >>>> this > > > >>>>> JIRA ticket: > > > >>>>> https://issues.apache.org/jira/browse/IGNITE-5886 < > > > >>>>> https://issues.apache.org/jira/browse/IGNITE-5886> > > > >>>>> > > > >>>>> Please share your thoughts in JIRA or in this discussion. > > > >>>>> > > > >>>>> Akmal, who perfected his technical writer skills working for IBM, > > > >>>>> volunteered to take over this task. Akmal, please create an > account > > > in > > > >>>>> Ignite JIRA and share it with us. You’ll be able to assign the > task > > > on > > > >>>>> yourself afterwards. > > > >>>>> https://issues.apache.org/jira/projects/IGNITE < > > > >>>> https://issues.apache.org/ > > > >>>>> jira/projects/IGNITE> > > > >>>>> > > > >>>>> Moreover, once the guide is ready Prachi will use it as a basis > for > > > the > > > >>>>> new SQL screencast we need to produce. > > > >>>>> > > > >>>>> — > > > >>>>> Denis > > > >>>>> > > > >>>>> > > > >>>>> > > > >>>>> > > > >>>> > > > >> > > > >> > > > > > > > > > |
I looked briefly and I couldn't find any explanation on "template" at all -
the only unique caveat apart from standard SQL. Is this on purpose? -- Nikita Ivanov On Mon, Aug 21, 2017 at 9:36 AM, Prachi Garg <[hidden email]> wrote: > Igor, Pavel > > On the website[1], I have added SQL, JDBC, ODBC, and Java API examples for > DDL, > DML and queries . I could not find DDL examples for .NET and C++ in the > documentation. Please add the missing code snippets for .NET and C++ APIs > taking SQL syntax from the Java API example. > > [1] https://ignite.apache.org/features/sql.html > > On Mon, Aug 21, 2017 at 3:28 AM, Igor Sapego <[hidden email]> wrote: > > > Prachi, > > > > Yeah, looks good. I've added creation of "Person" table to documentation, > > so take a look please. > > > > Best Regards, > > Igor > > > > On Fri, Aug 18, 2017 at 10:29 PM, Prachi Garg <[hidden email]> > wrote: > > > > > Hi Igor, > > > > > > The getting started guide is missing an example oh how to create a > Person > > > table (under ODBC tab). > > > https://apacheignite.readme.io/docs/getting-started-sql# > > > section-create-tables > > > > > > I am trying to put one on the website. Does the following look ok? > > > > > > // Create table based on PARTITIONED template with one backup > > > SQLCHAR query[] = "CREATE TABLE Person ( " > > > "id LONG, name VARCHAR, city_id LONG " > > > "PRIMARY KEY (id, city_id)) " > > > "WITH \"backups=1, affinityKey=city_id\""; > > > SQLSMALLINT queryLen = static_cast<SQLSMALLINT>(sizeof(query)); > > > > > > SQLRETURN ret = SQLExecDirect(stmt, query, queryLen); > > > > > > > > > On Fri, Aug 18, 2017 at 12:09 PM, Denis Magda <[hidden email]> > wrote: > > > > > > > Igor, thanks a lot. Appreciate this! > > > > > > > > — > > > > Denis > > > > > > > > > On Aug 18, 2017, at 8:56 AM, Igor Sapego <[hidden email]> > wrote: > > > > > > > > > > I've checked ODBC snippets and fixed all found issues. > > > > > > > > > > Best Regards, > > > > > Igor > > > > > > > > > > On Thu, Aug 17, 2017 at 11:16 PM, Denis Magda <[hidden email]> > > > wrote: > > > > > > > > > >> Igor, > > > > >> > > > > >> Would you mind helping us to test the snippets? I do believe it > will > > > > take > > > > >> you a couple of minutes since the environment is set up on your > > side. > > > > >> > > > > >> — > > > > >> Denis > > > > >> > > > > >>> On Aug 17, 2017, at 5:37 AM, Igor Sapego <[hidden email]> > > wrote: > > > > >>> > > > > >>> Akmal, > > > > >>> > > > > >>> I work on the ODBC driver and would be glad to help. You can send > > > > >>> mails with your requests to devlist and I will try to help as > much > > > as I > > > > >>> can. > > > > >>> > > > > >>> Best Regards, > > > > >>> Igor > > > > >>> > > > > >>> On Thu, Aug 17, 2017 at 3:28 PM, Akmal Chaudhri < > > > > >> [hidden email] > > > > >>>> wrote: > > > > >>> > > > > >>>> When I have the opportunity to test the ODBC code and ensure > that > > it > > > > >>>> performs, I will add it to GH. At the moment, just snippets > exist. > > > If > > > > >>>> anyone can assist with this, I would appreciate it, as I have no > > > > >> experience > > > > >>>> with ODBC. I made some efforts to build the ODBC driver and have > > had > > > > >> some > > > > >>>> success on Windows and Linux, but have been unable to run any > C++ > > > > code. > > > > >>>> > > > > >>>> On 16 August 2017 at 21:41, Denis Magda <[hidden email]> > > wrote: > > > > >>>> > > > > >>>>> Igniters, > > > > >>>>> > > > > >>>>> The SQL getting started guide is ready and published: > > > > >>>>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql > > > > >>>>> > > > > >>>>> Akmal thanks for your efforts and please apply the following > > minor > > > > >>>> changes: > > > > >>>>> * Add ODBC source files to your GitHub project. > > > > >>>>> * Add a flat SQL file (script) to the same project that will > > > include > > > > >> all > > > > >>>>> the pure SQL statements used in the guide. > > > > >>>>> > > > > >>>>> Basing on this guide I’ve prepared and release a guide for > > DBeaver > > > > SQL > > > > >>>>> tool: > > > > >>>>> https://apacheignite-tools.readme.io/docs/dbeaver > > > > >>>>> > > > > >>>>> — > > > > >>>>> Denis > > > > >>>>> > > > > >>>>> On Aug 11, 2017, at 3:17 PM, Denis Magda <[hidden email]> > > > wrote: > > > > >>>>> > > > > >>>>> Akmal, > > > > >>>>> > > > > >>>>> Good start! Please consider the following feedback: > > > > >>>>> > > > > >>>>> 1. Connectivity section. Emphasize that ignite-core.jar has to > be > > > > >> copied > > > > >>>>> to the classpath of an app or tool and give a link to more > > advanced > > > > >> JDBC > > > > >>>>> Thin driver documentation if the one needs more details. > > Probably, > > > > >>>> similar > > > > >>>>> steps should be brought up for the ODBC once it’s ready. > > > > >>>>> > > > > >>>>> 2. Make the first letters of city and people tables uppercase: > > city > > > > -> > > > > >>>>> City, people -> People > > > > >>>>> > > > > >>>>> 3. Rename INSERT section to “Inserting Data”, SELECT to > “Querying > > > > >> Data”, > > > > >>>>> UPDATE -> “Modifying Data”, DELETE to “Removing Data” or to > > better > > > > >>>>> alternatives. > > > > >>>>> > > > > >>>>> 4. Show how to insert at least 2 cities and 5 people in the > > INSERT > > > > >>>> section. > > > > >>>>> > > > > >>>>> — > > > > >>>>> Denis > > > > >>>>> > > > > >>>>> On Aug 11, 2017, at 10:42 AM, Akmal Chaudhri < > > > > >>>> [hidden email]> > > > > >>>>> wrote: > > > > >>>>> > > > > >>>>> Denis, All > > > > >>>>> > > > > >>>>> I have made some progress with the documentation: > > > > >>>>> > > > > >>>>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql < > > > > >>>>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql> > > > > >>>>> > > > > >>>>> ODBC connectivity and examples are missing, but should be > > completed > > > > >> very > > > > >>>>> soon. > > > > >>>>> > > > > >>>>> Community feedback welcome. > > > > >>>>> > > > > >>>>> Thanks. > > > > >>>>> > > > > >>>>> On 31 July 2017 at 19:02, Denis Magda <[hidden email] < > > > > >>>>> mailto:[hidden email] <[hidden email]>>> wrote: > > > > >>>>> Igniters, > > > > >>>>> > > > > >>>>> There is a lot of SQL related documentation available for > Ignite. > > > > >>>> However, > > > > >>>>> the one can get lost in it when he/she does her first steps on > a > > > > >> learning > > > > >>>>> path. It’s time to simplify these are first steps with a clear > > and > > > > >>>>> straightforward getting started guide. I’ve put the > requirements > > > into > > > > >>>> this > > > > >>>>> JIRA ticket: > > > > >>>>> https://issues.apache.org/jira/browse/IGNITE-5886 < > > > > >>>>> https://issues.apache.org/jira/browse/IGNITE-5886> > > > > >>>>> > > > > >>>>> Please share your thoughts in JIRA or in this discussion. > > > > >>>>> > > > > >>>>> Akmal, who perfected his technical writer skills working for > IBM, > > > > >>>>> volunteered to take over this task. Akmal, please create an > > account > > > > in > > > > >>>>> Ignite JIRA and share it with us. You’ll be able to assign the > > task > > > > on > > > > >>>>> yourself afterwards. > > > > >>>>> https://issues.apache.org/jira/projects/IGNITE < > > > > >>>> https://issues.apache.org/ > > > > >>>>> jira/projects/IGNITE> > > > > >>>>> > > > > >>>>> Moreover, once the guide is ready Prachi will use it as a basis > > for > > > > the > > > > >>>>> new SQL screencast we need to produce. > > > > >>>>> > > > > >>>>> — > > > > >>>>> Denis > > > > >>>>> > > > > >>>>> > > > > >>>>> > > > > >>>>> > > > > >>>> > > > > >> > > > > >> > > > > > > > > > > > > > > |
Nikita,
Thanks for checking. No, this is not on purpose. Denis, do we have the template syntax documented anywhere? D. On Mon, Aug 21, 2017 at 9:42 AM, Nikita Ivanov <[hidden email]> wrote: > I looked briefly and I couldn't find any explanation on "template" at all - > the only unique caveat apart from standard SQL. Is this on purpose? > > -- > Nikita Ivanov > > > On Mon, Aug 21, 2017 at 9:36 AM, Prachi Garg <[hidden email]> wrote: > > > Igor, Pavel > > > > On the website[1], I have added SQL, JDBC, ODBC, and Java API examples > for > > DDL, > > DML and queries . I could not find DDL examples for .NET and C++ in the > > documentation. Please add the missing code snippets for .NET and C++ > APIs > > taking SQL syntax from the Java API example. > > > > [1] https://ignite.apache.org/features/sql.html > > > > On Mon, Aug 21, 2017 at 3:28 AM, Igor Sapego <[hidden email]> wrote: > > > > > Prachi, > > > > > > Yeah, looks good. I've added creation of "Person" table to > documentation, > > > so take a look please. > > > > > > Best Regards, > > > Igor > > > > > > On Fri, Aug 18, 2017 at 10:29 PM, Prachi Garg <[hidden email]> > > wrote: > > > > > > > Hi Igor, > > > > > > > > The getting started guide is missing an example oh how to create a > > Person > > > > table (under ODBC tab). > > > > https://apacheignite.readme.io/docs/getting-started-sql# > > > > section-create-tables > > > > > > > > I am trying to put one on the website. Does the following look ok? > > > > > > > > // Create table based on PARTITIONED template with one backup > > > > SQLCHAR query[] = "CREATE TABLE Person ( " > > > > "id LONG, name VARCHAR, city_id LONG " > > > > "PRIMARY KEY (id, city_id)) " > > > > "WITH \"backups=1, affinityKey=city_id\""; > > > > SQLSMALLINT queryLen = static_cast<SQLSMALLINT>(sizeof(query)); > > > > > > > > SQLRETURN ret = SQLExecDirect(stmt, query, queryLen); > > > > > > > > > > > > On Fri, Aug 18, 2017 at 12:09 PM, Denis Magda <[hidden email]> > > wrote: > > > > > > > > > Igor, thanks a lot. Appreciate this! > > > > > > > > > > — > > > > > Denis > > > > > > > > > > > On Aug 18, 2017, at 8:56 AM, Igor Sapego <[hidden email]> > > wrote: > > > > > > > > > > > > I've checked ODBC snippets and fixed all found issues. > > > > > > > > > > > > Best Regards, > > > > > > Igor > > > > > > > > > > > > On Thu, Aug 17, 2017 at 11:16 PM, Denis Magda <[hidden email] > > > > > > wrote: > > > > > > > > > > > >> Igor, > > > > > >> > > > > > >> Would you mind helping us to test the snippets? I do believe it > > will > > > > > take > > > > > >> you a couple of minutes since the environment is set up on your > > > side. > > > > > >> > > > > > >> — > > > > > >> Denis > > > > > >> > > > > > >>> On Aug 17, 2017, at 5:37 AM, Igor Sapego <[hidden email]> > > > wrote: > > > > > >>> > > > > > >>> Akmal, > > > > > >>> > > > > > >>> I work on the ODBC driver and would be glad to help. You can > send > > > > > >>> mails with your requests to devlist and I will try to help as > > much > > > > as I > > > > > >>> can. > > > > > >>> > > > > > >>> Best Regards, > > > > > >>> Igor > > > > > >>> > > > > > >>> On Thu, Aug 17, 2017 at 3:28 PM, Akmal Chaudhri < > > > > > >> [hidden email] > > > > > >>>> wrote: > > > > > >>> > > > > > >>>> When I have the opportunity to test the ODBC code and ensure > > that > > > it > > > > > >>>> performs, I will add it to GH. At the moment, just snippets > > exist. > > > > If > > > > > >>>> anyone can assist with this, I would appreciate it, as I have > no > > > > > >> experience > > > > > >>>> with ODBC. I made some efforts to build the ODBC driver and > have > > > had > > > > > >> some > > > > > >>>> success on Windows and Linux, but have been unable to run any > > C++ > > > > > code. > > > > > >>>> > > > > > >>>> On 16 August 2017 at 21:41, Denis Magda <[hidden email]> > > > wrote: > > > > > >>>> > > > > > >>>>> Igniters, > > > > > >>>>> > > > > > >>>>> The SQL getting started guide is ready and published: > > > > > >>>>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql > > > > > >>>>> > > > > > >>>>> Akmal thanks for your efforts and please apply the following > > > minor > > > > > >>>> changes: > > > > > >>>>> * Add ODBC source files to your GitHub project. > > > > > >>>>> * Add a flat SQL file (script) to the same project that will > > > > include > > > > > >> all > > > > > >>>>> the pure SQL statements used in the guide. > > > > > >>>>> > > > > > >>>>> Basing on this guide I’ve prepared and release a guide for > > > DBeaver > > > > > SQL > > > > > >>>>> tool: > > > > > >>>>> https://apacheignite-tools.readme.io/docs/dbeaver > > > > > >>>>> > > > > > >>>>> — > > > > > >>>>> Denis > > > > > >>>>> > > > > > >>>>> On Aug 11, 2017, at 3:17 PM, Denis Magda <[hidden email]> > > > > wrote: > > > > > >>>>> > > > > > >>>>> Akmal, > > > > > >>>>> > > > > > >>>>> Good start! Please consider the following feedback: > > > > > >>>>> > > > > > >>>>> 1. Connectivity section. Emphasize that ignite-core.jar has > to > > be > > > > > >> copied > > > > > >>>>> to the classpath of an app or tool and give a link to more > > > advanced > > > > > >> JDBC > > > > > >>>>> Thin driver documentation if the one needs more details. > > > Probably, > > > > > >>>> similar > > > > > >>>>> steps should be brought up for the ODBC once it’s ready. > > > > > >>>>> > > > > > >>>>> 2. Make the first letters of city and people tables > uppercase: > > > city > > > > > -> > > > > > >>>>> City, people -> People > > > > > >>>>> > > > > > >>>>> 3. Rename INSERT section to “Inserting Data”, SELECT to > > “Querying > > > > > >> Data”, > > > > > >>>>> UPDATE -> “Modifying Data”, DELETE to “Removing Data” or to > > > better > > > > > >>>>> alternatives. > > > > > >>>>> > > > > > >>>>> 4. Show how to insert at least 2 cities and 5 people in the > > > INSERT > > > > > >>>> section. > > > > > >>>>> > > > > > >>>>> — > > > > > >>>>> Denis > > > > > >>>>> > > > > > >>>>> On Aug 11, 2017, at 10:42 AM, Akmal Chaudhri < > > > > > >>>> [hidden email]> > > > > > >>>>> wrote: > > > > > >>>>> > > > > > >>>>> Denis, All > > > > > >>>>> > > > > > >>>>> I have made some progress with the documentation: > > > > > >>>>> > > > > > >>>>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql > < > > > > > >>>>> https://apacheignite.readme.io/v2.1/docs/getting-started-sql > > > > > > > >>>>> > > > > > >>>>> ODBC connectivity and examples are missing, but should be > > > completed > > > > > >> very > > > > > >>>>> soon. > > > > > >>>>> > > > > > >>>>> Community feedback welcome. > > > > > >>>>> > > > > > >>>>> Thanks. > > > > > >>>>> > > > > > >>>>> On 31 July 2017 at 19:02, Denis Magda <[hidden email] < > > > > > >>>>> mailto:[hidden email] <[hidden email]>>> wrote: > > > > > >>>>> Igniters, > > > > > >>>>> > > > > > >>>>> There is a lot of SQL related documentation available for > > Ignite. > > > > > >>>> However, > > > > > >>>>> the one can get lost in it when he/she does her first steps > on > > a > > > > > >> learning > > > > > >>>>> path. It’s time to simplify these are first steps with a > clear > > > and > > > > > >>>>> straightforward getting started guide. I’ve put the > > requirements > > > > into > > > > > >>>> this > > > > > >>>>> JIRA ticket: > > > > > >>>>> https://issues.apache.org/jira/browse/IGNITE-5886 < > > > > > >>>>> https://issues.apache.org/jira/browse/IGNITE-5886> > > > > > >>>>> > > > > > >>>>> Please share your thoughts in JIRA or in this discussion. > > > > > >>>>> > > > > > >>>>> Akmal, who perfected his technical writer skills working for > > IBM, > > > > > >>>>> volunteered to take over this task. Akmal, please create an > > > account > > > > > in > > > > > >>>>> Ignite JIRA and share it with us. You’ll be able to assign > the > > > task > > > > > on > > > > > >>>>> yourself afterwards. > > > > > >>>>> https://issues.apache.org/jira/projects/IGNITE < > > > > > >>>> https://issues.apache.org/ > > > > > >>>>> jira/projects/IGNITE> > > > > > >>>>> > > > > > >>>>> Moreover, once the guide is ready Prachi will use it as a > basis > > > for > > > > > the > > > > > >>>>> new SQL screencast we need to produce. > > > > > >>>>> > > > > > >>>>> — > > > > > >>>>> Denis > > > > > >>>>> > > > > > >>>>> > > > > > >>>>> > > > > > >>>>> > > > > > >>>> > > > > > >> > > > > > >> > > > > > > > > > > > > > > > > > > > > |
Template syntax is documented here -
https://apacheignite.readme.io/docs/distributed-ddl#section-extended-parameters I've added a brief explanation on the SQL page (on the website) as well. On Mon, Aug 21, 2017 at 4:40 PM, Dmitriy Setrakyan <[hidden email]> wrote: > Nikita, > > Thanks for checking. No, this is not on purpose. > > Denis, do we have the template syntax documented anywhere? > > D. > > On Mon, Aug 21, 2017 at 9:42 AM, Nikita Ivanov <[hidden email]> > wrote: > > > I looked briefly and I couldn't find any explanation on "template" at > all - > > the only unique caveat apart from standard SQL. Is this on purpose? > > > > -- > > Nikita Ivanov > > > > > > On Mon, Aug 21, 2017 at 9:36 AM, Prachi Garg <[hidden email]> wrote: > > > > > Igor, Pavel > > > > > > On the website[1], I have added SQL, JDBC, ODBC, and Java API examples > > for > > > DDL, > > > DML and queries . I could not find DDL examples for .NET and C++ in the > > > documentation. Please add the missing code snippets for .NET and C++ > > APIs > > > taking SQL syntax from the Java API example. > > > > > > [1] https://ignite.apache.org/features/sql.html > > > > > > On Mon, Aug 21, 2017 at 3:28 AM, Igor Sapego <[hidden email]> > wrote: > > > > > > > Prachi, > > > > > > > > Yeah, looks good. I've added creation of "Person" table to > > documentation, > > > > so take a look please. > > > > > > > > Best Regards, > > > > Igor > > > > > > > > On Fri, Aug 18, 2017 at 10:29 PM, Prachi Garg <[hidden email]> > > > wrote: > > > > > > > > > Hi Igor, > > > > > > > > > > The getting started guide is missing an example oh how to create a > > > Person > > > > > table (under ODBC tab). > > > > > https://apacheignite.readme.io/docs/getting-started-sql# > > > > > section-create-tables > > > > > > > > > > I am trying to put one on the website. Does the following look ok? > > > > > > > > > > // Create table based on PARTITIONED template with one backup > > > > > SQLCHAR query[] = "CREATE TABLE Person ( " > > > > > "id LONG, name VARCHAR, city_id LONG " > > > > > "PRIMARY KEY (id, city_id)) " > > > > > "WITH \"backups=1, affinityKey=city_id\""; > > > > > SQLSMALLINT queryLen = static_cast<SQLSMALLINT>(sizeof(query)); > > > > > > > > > > SQLRETURN ret = SQLExecDirect(stmt, query, queryLen); > > > > > > > > > > > > > > > On Fri, Aug 18, 2017 at 12:09 PM, Denis Magda <[hidden email]> > > > wrote: > > > > > > > > > > > Igor, thanks a lot. Appreciate this! > > > > > > > > > > > > — > > > > > > Denis > > > > > > > > > > > > > On Aug 18, 2017, at 8:56 AM, Igor Sapego <[hidden email]> > > > wrote: > > > > > > > > > > > > > > I've checked ODBC snippets and fixed all found issues. > > > > > > > > > > > > > > Best Regards, > > > > > > > Igor > > > > > > > > > > > > > > On Thu, Aug 17, 2017 at 11:16 PM, Denis Magda < > [hidden email] > > > > > > > > wrote: > > > > > > > > > > > > > >> Igor, > > > > > > >> > > > > > > >> Would you mind helping us to test the snippets? I do believe > it > > > will > > > > > > take > > > > > > >> you a couple of minutes since the environment is set up on > your > > > > side. > > > > > > >> > > > > > > >> — > > > > > > >> Denis > > > > > > >> > > > > > > >>> On Aug 17, 2017, at 5:37 AM, Igor Sapego <[hidden email] > > > > > > wrote: > > > > > > >>> > > > > > > >>> Akmal, > > > > > > >>> > > > > > > >>> I work on the ODBC driver and would be glad to help. You can > > send > > > > > > >>> mails with your requests to devlist and I will try to help as > > > much > > > > > as I > > > > > > >>> can. > > > > > > >>> > > > > > > >>> Best Regards, > > > > > > >>> Igor > > > > > > >>> > > > > > > >>> On Thu, Aug 17, 2017 at 3:28 PM, Akmal Chaudhri < > > > > > > >> [hidden email] > > > > > > >>>> wrote: > > > > > > >>> > > > > > > >>>> When I have the opportunity to test the ODBC code and ensure > > > that > > > > it > > > > > > >>>> performs, I will add it to GH. At the moment, just snippets > > > exist. > > > > > If > > > > > > >>>> anyone can assist with this, I would appreciate it, as I > have > > no > > > > > > >> experience > > > > > > >>>> with ODBC. I made some efforts to build the ODBC driver and > > have > > > > had > > > > > > >> some > > > > > > >>>> success on Windows and Linux, but have been unable to run > any > > > C++ > > > > > > code. > > > > > > >>>> > > > > > > >>>> On 16 August 2017 at 21:41, Denis Magda <[hidden email]> > > > > wrote: > > > > > > >>>> > > > > > > >>>>> Igniters, > > > > > > >>>>> > > > > > > >>>>> The SQL getting started guide is ready and published: > > > > > > >>>>> https://apacheignite.readme.io/v2.1/docs/getting-started- > sql > > > > > > >>>>> > > > > > > >>>>> Akmal thanks for your efforts and please apply the > following > > > > minor > > > > > > >>>> changes: > > > > > > >>>>> * Add ODBC source files to your GitHub project. > > > > > > >>>>> * Add a flat SQL file (script) to the same project that > will > > > > > include > > > > > > >> all > > > > > > >>>>> the pure SQL statements used in the guide. > > > > > > >>>>> > > > > > > >>>>> Basing on this guide I’ve prepared and release a guide for > > > > DBeaver > > > > > > SQL > > > > > > >>>>> tool: > > > > > > >>>>> https://apacheignite-tools.readme.io/docs/dbeaver > > > > > > >>>>> > > > > > > >>>>> — > > > > > > >>>>> Denis > > > > > > >>>>> > > > > > > >>>>> On Aug 11, 2017, at 3:17 PM, Denis Magda < > [hidden email]> > > > > > wrote: > > > > > > >>>>> > > > > > > >>>>> Akmal, > > > > > > >>>>> > > > > > > >>>>> Good start! Please consider the following feedback: > > > > > > >>>>> > > > > > > >>>>> 1. Connectivity section. Emphasize that ignite-core.jar has > > to > > > be > > > > > > >> copied > > > > > > >>>>> to the classpath of an app or tool and give a link to more > > > > advanced > > > > > > >> JDBC > > > > > > >>>>> Thin driver documentation if the one needs more details. > > > > Probably, > > > > > > >>>> similar > > > > > > >>>>> steps should be brought up for the ODBC once it’s ready. > > > > > > >>>>> > > > > > > >>>>> 2. Make the first letters of city and people tables > > uppercase: > > > > city > > > > > > -> > > > > > > >>>>> City, people -> People > > > > > > >>>>> > > > > > > >>>>> 3. Rename INSERT section to “Inserting Data”, SELECT to > > > “Querying > > > > > > >> Data”, > > > > > > >>>>> UPDATE -> “Modifying Data”, DELETE to “Removing Data” or to > > > > better > > > > > > >>>>> alternatives. > > > > > > >>>>> > > > > > > >>>>> 4. Show how to insert at least 2 cities and 5 people in the > > > > INSERT > > > > > > >>>> section. > > > > > > >>>>> > > > > > > >>>>> — > > > > > > >>>>> Denis > > > > > > >>>>> > > > > > > >>>>> On Aug 11, 2017, at 10:42 AM, Akmal Chaudhri < > > > > > > >>>> [hidden email]> > > > > > > >>>>> wrote: > > > > > > >>>>> > > > > > > >>>>> Denis, All > > > > > > >>>>> > > > > > > >>>>> I have made some progress with the documentation: > > > > > > >>>>> > > > > > > >>>>> https://apacheignite.readme.io/v2.1/docs/getting-started- > sql > > < > > > > > > >>>>> https://apacheignite.readme.io/v2.1/docs/getting-started- > sql > > > > > > > > > >>>>> > > > > > > >>>>> ODBC connectivity and examples are missing, but should be > > > > completed > > > > > > >> very > > > > > > >>>>> soon. > > > > > > >>>>> > > > > > > >>>>> Community feedback welcome. > > > > > > >>>>> > > > > > > >>>>> Thanks. > > > > > > >>>>> > > > > > > >>>>> On 31 July 2017 at 19:02, Denis Magda <[hidden email] < > > > > > > >>>>> mailto:[hidden email] <[hidden email]>>> wrote: > > > > > > >>>>> Igniters, > > > > > > >>>>> > > > > > > >>>>> There is a lot of SQL related documentation available for > > > Ignite. > > > > > > >>>> However, > > > > > > >>>>> the one can get lost in it when he/she does her first steps > > on > > > a > > > > > > >> learning > > > > > > >>>>> path. It’s time to simplify these are first steps with a > > clear > > > > and > > > > > > >>>>> straightforward getting started guide. I’ve put the > > > requirements > > > > > into > > > > > > >>>> this > > > > > > >>>>> JIRA ticket: > > > > > > >>>>> https://issues.apache.org/jira/browse/IGNITE-5886 < > > > > > > >>>>> https://issues.apache.org/jira/browse/IGNITE-5886> > > > > > > >>>>> > > > > > > >>>>> Please share your thoughts in JIRA or in this discussion. > > > > > > >>>>> > > > > > > >>>>> Akmal, who perfected his technical writer skills working > for > > > IBM, > > > > > > >>>>> volunteered to take over this task. Akmal, please create an > > > > account > > > > > > in > > > > > > >>>>> Ignite JIRA and share it with us. You’ll be able to assign > > the > > > > task > > > > > > on > > > > > > >>>>> yourself afterwards. > > > > > > >>>>> https://issues.apache.org/jira/projects/IGNITE < > > > > > > >>>> https://issues.apache.org/ > > > > > > >>>>> jira/projects/IGNITE> > > > > > > >>>>> > > > > > > >>>>> Moreover, once the guide is ready Prachi will use it as a > > basis > > > > for > > > > > > the > > > > > > >>>>> new SQL screencast we need to produce. > > > > > > >>>>> > > > > > > >>>>> — > > > > > > >>>>> Denis > > > > > > >>>>> > > > > > > >>>>> > > > > > > >>>>> > > > > > > >>>>> > > > > > > >>>> > > > > > > >> > > > > > > >> > > > > > > > > > > > > > > > > > > > > > > > > > > > |
Prachi, is there an example for a template file? Is there an example of how
a template should be registered? Is there an example of how other extended parameters should be configured, i.e. a sample CREATE TABLE command? On Mon, Aug 21, 2017 at 5:15 PM, Prachi Garg <[hidden email]> wrote: > Template syntax is documented here - > https://apacheignite.readme.io/docs/distributed-ddl# > section-extended-parameters > > I've added a brief explanation on the SQL page (on the website) as well. > > On Mon, Aug 21, 2017 at 4:40 PM, Dmitriy Setrakyan <[hidden email]> wrote: > > > Nikita, > > > > Thanks for checking. No, this is not on purpose. > > > > Denis, do we have the template syntax documented anywhere? > > > > D. > > > > On Mon, Aug 21, 2017 at 9:42 AM, Nikita Ivanov <[hidden email]> > > wrote: > > > > > I looked briefly and I couldn't find any explanation on "template" at > > all - > > > the only unique caveat apart from standard SQL. Is this on purpose? > > > > > > -- > > > Nikita Ivanov > > > > > > > > > On Mon, Aug 21, 2017 at 9:36 AM, Prachi Garg <[hidden email]> > wrote: > > > > > > > Igor, Pavel > > > > > > > > On the website[1], I have added SQL, JDBC, ODBC, and Java API > examples > > > for > > > > DDL, > > > > DML and queries . I could not find DDL examples for .NET and C++ in > the > > > > documentation. Please add the missing code snippets for .NET and C++ > > > APIs > > > > taking SQL syntax from the Java API example. > > > > > > > > [1] https://ignite.apache.org/features/sql.html > > > > > > > > On Mon, Aug 21, 2017 at 3:28 AM, Igor Sapego <[hidden email]> > > wrote: > > > > > > > > > Prachi, > > > > > > > > > > Yeah, looks good. I've added creation of "Person" table to > > > documentation, > > > > > so take a look please. > > > > > > > > > > Best Regards, > > > > > Igor > > > > > > > > > > On Fri, Aug 18, 2017 at 10:29 PM, Prachi Garg <[hidden email]> > > > > wrote: > > > > > > > > > > > Hi Igor, > > > > > > > > > > > > The getting started guide is missing an example oh how to create > a > > > > Person > > > > > > table (under ODBC tab). > > > > > > https://apacheignite.readme.io/docs/getting-started-sql# > > > > > > section-create-tables > > > > > > > > > > > > I am trying to put one on the website. Does the following look > ok? > > > > > > > > > > > > // Create table based on PARTITIONED template with one backup > > > > > > SQLCHAR query[] = "CREATE TABLE Person ( " > > > > > > "id LONG, name VARCHAR, city_id LONG " > > > > > > "PRIMARY KEY (id, city_id)) " > > > > > > "WITH \"backups=1, affinityKey=city_id\""; > > > > > > SQLSMALLINT queryLen = static_cast<SQLSMALLINT>(sizeof(query)); > > > > > > > > > > > > SQLRETURN ret = SQLExecDirect(stmt, query, queryLen); > > > > > > > > > > > > > > > > > > On Fri, Aug 18, 2017 at 12:09 PM, Denis Magda <[hidden email] > > > > > > wrote: > > > > > > > > > > > > > Igor, thanks a lot. Appreciate this! > > > > > > > > > > > > > > — > > > > > > > Denis > > > > > > > > > > > > > > > On Aug 18, 2017, at 8:56 AM, Igor Sapego <[hidden email] > > > > > > wrote: > > > > > > > > > > > > > > > > I've checked ODBC snippets and fixed all found issues. > > > > > > > > > > > > > > > > Best Regards, > > > > > > > > Igor > > > > > > > > > > > > > > > > On Thu, Aug 17, 2017 at 11:16 PM, Denis Magda < > > [hidden email] > > > > > > > > > > wrote: > > > > > > > > > > > > > > > >> Igor, > > > > > > > >> > > > > > > > >> Would you mind helping us to test the snippets? I do believe > > it > > > > will > > > > > > > take > > > > > > > >> you a couple of minutes since the environment is set up on > > your > > > > > side. > > > > > > > >> > > > > > > > >> — > > > > > > > >> Denis > > > > > > > >> > > > > > > > >>> On Aug 17, 2017, at 5:37 AM, Igor Sapego < > [hidden email] > > > > > > > > wrote: > > > > > > > >>> > > > > > > > >>> Akmal, > > > > > > > >>> > > > > > > > >>> I work on the ODBC driver and would be glad to help. You > can > > > send > > > > > > > >>> mails with your requests to devlist and I will try to help > as > > > > much > > > > > > as I > > > > > > > >>> can. > > > > > > > >>> > > > > > > > >>> Best Regards, > > > > > > > >>> Igor > > > > > > > >>> > > > > > > > >>> On Thu, Aug 17, 2017 at 3:28 PM, Akmal Chaudhri < > > > > > > > >> [hidden email] > > > > > > > >>>> wrote: > > > > > > > >>> > > > > > > > >>>> When I have the opportunity to test the ODBC code and > ensure > > > > that > > > > > it > > > > > > > >>>> performs, I will add it to GH. At the moment, just > snippets > > > > exist. > > > > > > If > > > > > > > >>>> anyone can assist with this, I would appreciate it, as I > > have > > > no > > > > > > > >> experience > > > > > > > >>>> with ODBC. I made some efforts to build the ODBC driver > and > > > have > > > > > had > > > > > > > >> some > > > > > > > >>>> success on Windows and Linux, but have been unable to run > > any > > > > C++ > > > > > > > code. > > > > > > > >>>> > > > > > > > >>>> On 16 August 2017 at 21:41, Denis Magda < > [hidden email]> > > > > > wrote: > > > > > > > >>>> > > > > > > > >>>>> Igniters, > > > > > > > >>>>> > > > > > > > >>>>> The SQL getting started guide is ready and published: > > > > > > > >>>>> https://apacheignite.readme. > io/v2.1/docs/getting-started- > > sql > > > > > > > >>>>> > > > > > > > >>>>> Akmal thanks for your efforts and please apply the > > following > > > > > minor > > > > > > > >>>> changes: > > > > > > > >>>>> * Add ODBC source files to your GitHub project. > > > > > > > >>>>> * Add a flat SQL file (script) to the same project that > > will > > > > > > include > > > > > > > >> all > > > > > > > >>>>> the pure SQL statements used in the guide. > > > > > > > >>>>> > > > > > > > >>>>> Basing on this guide I’ve prepared and release a guide > for > > > > > DBeaver > > > > > > > SQL > > > > > > > >>>>> tool: > > > > > > > >>>>> https://apacheignite-tools.readme.io/docs/dbeaver > > > > > > > >>>>> > > > > > > > >>>>> — > > > > > > > >>>>> Denis > > > > > > > >>>>> > > > > > > > >>>>> On Aug 11, 2017, at 3:17 PM, Denis Magda < > > [hidden email]> > > > > > > wrote: > > > > > > > >>>>> > > > > > > > >>>>> Akmal, > > > > > > > >>>>> > > > > > > > >>>>> Good start! Please consider the following feedback: > > > > > > > >>>>> > > > > > > > >>>>> 1. Connectivity section. Emphasize that ignite-core.jar > has > > > to > > > > be > > > > > > > >> copied > > > > > > > >>>>> to the classpath of an app or tool and give a link to > more > > > > > advanced > > > > > > > >> JDBC > > > > > > > >>>>> Thin driver documentation if the one needs more details. > > > > > Probably, > > > > > > > >>>> similar > > > > > > > >>>>> steps should be brought up for the ODBC once it’s ready. > > > > > > > >>>>> > > > > > > > >>>>> 2. Make the first letters of city and people tables > > > uppercase: > > > > > city > > > > > > > -> > > > > > > > >>>>> City, people -> People > > > > > > > >>>>> > > > > > > > >>>>> 3. Rename INSERT section to “Inserting Data”, SELECT to > > > > “Querying > > > > > > > >> Data”, > > > > > > > >>>>> UPDATE -> “Modifying Data”, DELETE to “Removing Data” or > to > > > > > better > > > > > > > >>>>> alternatives. > > > > > > > >>>>> > > > > > > > >>>>> 4. Show how to insert at least 2 cities and 5 people in > the > > > > > INSERT > > > > > > > >>>> section. > > > > > > > >>>>> > > > > > > > >>>>> — > > > > > > > >>>>> Denis > > > > > > > >>>>> > > > > > > > >>>>> On Aug 11, 2017, at 10:42 AM, Akmal Chaudhri < > > > > > > > >>>> [hidden email]> > > > > > > > >>>>> wrote: > > > > > > > >>>>> > > > > > > > >>>>> Denis, All > > > > > > > >>>>> > > > > > > > >>>>> I have made some progress with the documentation: > > > > > > > >>>>> > > > > > > > >>>>> https://apacheignite.readme. > io/v2.1/docs/getting-started- > > sql > > > < > > > > > > > >>>>> https://apacheignite.readme. > io/v2.1/docs/getting-started- > > sql > > > > > > > > > > > >>>>> > > > > > > > >>>>> ODBC connectivity and examples are missing, but should be > > > > > completed > > > > > > > >> very > > > > > > > >>>>> soon. > > > > > > > >>>>> > > > > > > > >>>>> Community feedback welcome. > > > > > > > >>>>> > > > > > > > >>>>> Thanks. > > > > > > > >>>>> > > > > > > > >>>>> On 31 July 2017 at 19:02, Denis Magda <[hidden email] > < > > > > > > > >>>>> mailto:[hidden email] <[hidden email]>>> wrote: > > > > > > > >>>>> Igniters, > > > > > > > >>>>> > > > > > > > >>>>> There is a lot of SQL related documentation available for > > > > Ignite. > > > > > > > >>>> However, > > > > > > > >>>>> the one can get lost in it when he/she does her first > steps > > > on > > > > a > > > > > > > >> learning > > > > > > > >>>>> path. It’s time to simplify these are first steps with a > > > clear > > > > > and > > > > > > > >>>>> straightforward getting started guide. I’ve put the > > > > requirements > > > > > > into > > > > > > > >>>> this > > > > > > > >>>>> JIRA ticket: > > > > > > > >>>>> https://issues.apache.org/jira/browse/IGNITE-5886 < > > > > > > > >>>>> https://issues.apache.org/jira/browse/IGNITE-5886> > > > > > > > >>>>> > > > > > > > >>>>> Please share your thoughts in JIRA or in this discussion. > > > > > > > >>>>> > > > > > > > >>>>> Akmal, who perfected his technical writer skills working > > for > > > > IBM, > > > > > > > >>>>> volunteered to take over this task. Akmal, please create > an > > > > > account > > > > > > > in > > > > > > > >>>>> Ignite JIRA and share it with us. You’ll be able to > assign > > > the > > > > > task > > > > > > > on > > > > > > > >>>>> yourself afterwards. > > > > > > > >>>>> https://issues.apache.org/jira/projects/IGNITE < > > > > > > > >>>> https://issues.apache.org/ > > > > > > > >>>>> jira/projects/IGNITE> > > > > > > > >>>>> > > > > > > > >>>>> Moreover, once the guide is ready Prachi will use it as a > > > basis > > > > > for > > > > > > > the > > > > > > > >>>>> new SQL screencast we need to produce. > > > > > > > >>>>> > > > > > > > >>>>> — > > > > > > > >>>>> Denis > > > > > > > >>>>> > > > > > > > >>>>> > > > > > > > >>>>> > > > > > > > >>>>> > > > > > > > >>>> > > > > > > > >> > > > > > > > >> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > |
https://apacheignite.readme.io/docs/distributed-ddl#section-create-table
has examples for template and other extended parameters. The Extended Parameters section explains how to register a template. On Mon, Aug 21, 2017 at 5:19 PM, Dmitriy Setrakyan <[hidden email]> wrote: > Prachi, is there an example for a template file? Is there an example of how > a template should be registered? Is there an example of how other extended > parameters should be configured, i.e. a sample CREATE TABLE command? > > On Mon, Aug 21, 2017 at 5:15 PM, Prachi Garg <[hidden email]> wrote: > > > Template syntax is documented here - > > https://apacheignite.readme.io/docs/distributed-ddl# > > section-extended-parameters > > > > I've added a brief explanation on the SQL page (on the website) as well. > > > > On Mon, Aug 21, 2017 at 4:40 PM, Dmitriy Setrakyan <[hidden email]> > wrote: > > > > > Nikita, > > > > > > Thanks for checking. No, this is not on purpose. > > > > > > Denis, do we have the template syntax documented anywhere? > > > > > > D. > > > > > > On Mon, Aug 21, 2017 at 9:42 AM, Nikita Ivanov <[hidden email]> > > > wrote: > > > > > > > I looked briefly and I couldn't find any explanation on "template" at > > > all - > > > > the only unique caveat apart from standard SQL. Is this on purpose? > > > > > > > > -- > > > > Nikita Ivanov > > > > > > > > > > > > On Mon, Aug 21, 2017 at 9:36 AM, Prachi Garg <[hidden email]> > > wrote: > > > > > > > > > Igor, Pavel > > > > > > > > > > On the website[1], I have added SQL, JDBC, ODBC, and Java API > > examples > > > > for > > > > > DDL, > > > > > DML and queries . I could not find DDL examples for .NET and C++ in > > the > > > > > documentation. Please add the missing code snippets for .NET and > C++ > > > > APIs > > > > > taking SQL syntax from the Java API example. > > > > > > > > > > [1] https://ignite.apache.org/features/sql.html > > > > > > > > > > On Mon, Aug 21, 2017 at 3:28 AM, Igor Sapego <[hidden email]> > > > wrote: > > > > > > > > > > > Prachi, > > > > > > > > > > > > Yeah, looks good. I've added creation of "Person" table to > > > > documentation, > > > > > > so take a look please. > > > > > > > > > > > > Best Regards, > > > > > > Igor > > > > > > > > > > > > On Fri, Aug 18, 2017 at 10:29 PM, Prachi Garg < > [hidden email]> > > > > > wrote: > > > > > > > > > > > > > Hi Igor, > > > > > > > > > > > > > > The getting started guide is missing an example oh how to > create > > a > > > > > Person > > > > > > > table (under ODBC tab). > > > > > > > https://apacheignite.readme.io/docs/getting-started-sql# > > > > > > > section-create-tables > > > > > > > > > > > > > > I am trying to put one on the website. Does the following look > > ok? > > > > > > > > > > > > > > // Create table based on PARTITIONED template with one backup > > > > > > > SQLCHAR query[] = "CREATE TABLE Person ( " > > > > > > > "id LONG, name VARCHAR, city_id LONG " > > > > > > > "PRIMARY KEY (id, city_id)) " > > > > > > > "WITH \"backups=1, affinityKey=city_id\""; > > > > > > > SQLSMALLINT queryLen = static_cast<SQLSMALLINT>( > sizeof(query)); > > > > > > > > > > > > > > SQLRETURN ret = SQLExecDirect(stmt, query, queryLen); > > > > > > > > > > > > > > > > > > > > > On Fri, Aug 18, 2017 at 12:09 PM, Denis Magda < > [hidden email] > > > > > > > > wrote: > > > > > > > > > > > > > > > Igor, thanks a lot. Appreciate this! > > > > > > > > > > > > > > > > — > > > > > > > > Denis > > > > > > > > > > > > > > > > > On Aug 18, 2017, at 8:56 AM, Igor Sapego < > [hidden email] > > > > > > > > wrote: > > > > > > > > > > > > > > > > > > I've checked ODBC snippets and fixed all found issues. > > > > > > > > > > > > > > > > > > Best Regards, > > > > > > > > > Igor > > > > > > > > > > > > > > > > > > On Thu, Aug 17, 2017 at 11:16 PM, Denis Magda < > > > [hidden email] > > > > > > > > > > > > wrote: > > > > > > > > > > > > > > > > > >> Igor, > > > > > > > > >> > > > > > > > > >> Would you mind helping us to test the snippets? I do > believe > > > it > > > > > will > > > > > > > > take > > > > > > > > >> you a couple of minutes since the environment is set up on > > > your > > > > > > side. > > > > > > > > >> > > > > > > > > >> — > > > > > > > > >> Denis > > > > > > > > >> > > > > > > > > >>> On Aug 17, 2017, at 5:37 AM, Igor Sapego < > > [hidden email] > > > > > > > > > > wrote: > > > > > > > > >>> > > > > > > > > >>> Akmal, > > > > > > > > >>> > > > > > > > > >>> I work on the ODBC driver and would be glad to help. You > > can > > > > send > > > > > > > > >>> mails with your requests to devlist and I will try to > help > > as > > > > > much > > > > > > > as I > > > > > > > > >>> can. > > > > > > > > >>> > > > > > > > > >>> Best Regards, > > > > > > > > >>> Igor > > > > > > > > >>> > > > > > > > > >>> On Thu, Aug 17, 2017 at 3:28 PM, Akmal Chaudhri < > > > > > > > > >> [hidden email] > > > > > > > > >>>> wrote: > > > > > > > > >>> > > > > > > > > >>>> When I have the opportunity to test the ODBC code and > > ensure > > > > > that > > > > > > it > > > > > > > > >>>> performs, I will add it to GH. At the moment, just > > snippets > > > > > exist. > > > > > > > If > > > > > > > > >>>> anyone can assist with this, I would appreciate it, as I > > > have > > > > no > > > > > > > > >> experience > > > > > > > > >>>> with ODBC. I made some efforts to build the ODBC driver > > and > > > > have > > > > > > had > > > > > > > > >> some > > > > > > > > >>>> success on Windows and Linux, but have been unable to > run > > > any > > > > > C++ > > > > > > > > code. > > > > > > > > >>>> > > > > > > > > >>>> On 16 August 2017 at 21:41, Denis Magda < > > [hidden email]> > > > > > > wrote: > > > > > > > > >>>> > > > > > > > > >>>>> Igniters, > > > > > > > > >>>>> > > > > > > > > >>>>> The SQL getting started guide is ready and published: > > > > > > > > >>>>> https://apacheignite.readme. > > io/v2.1/docs/getting-started- > > > sql > > > > > > > > >>>>> > > > > > > > > >>>>> Akmal thanks for your efforts and please apply the > > > following > > > > > > minor > > > > > > > > >>>> changes: > > > > > > > > >>>>> * Add ODBC source files to your GitHub project. > > > > > > > > >>>>> * Add a flat SQL file (script) to the same project that > > > will > > > > > > > include > > > > > > > > >> all > > > > > > > > >>>>> the pure SQL statements used in the guide. > > > > > > > > >>>>> > > > > > > > > >>>>> Basing on this guide I’ve prepared and release a guide > > for > > > > > > DBeaver > > > > > > > > SQL > > > > > > > > >>>>> tool: > > > > > > > > >>>>> https://apacheignite-tools.readme.io/docs/dbeaver > > > > > > > > >>>>> > > > > > > > > >>>>> — > > > > > > > > >>>>> Denis > > > > > > > > >>>>> > > > > > > > > >>>>> On Aug 11, 2017, at 3:17 PM, Denis Magda < > > > [hidden email]> > > > > > > > wrote: > > > > > > > > >>>>> > > > > > > > > >>>>> Akmal, > > > > > > > > >>>>> > > > > > > > > >>>>> Good start! Please consider the following feedback: > > > > > > > > >>>>> > > > > > > > > >>>>> 1. Connectivity section. Emphasize that ignite-core.jar > > has > > > > to > > > > > be > > > > > > > > >> copied > > > > > > > > >>>>> to the classpath of an app or tool and give a link to > > more > > > > > > advanced > > > > > > > > >> JDBC > > > > > > > > >>>>> Thin driver documentation if the one needs more > details. > > > > > > Probably, > > > > > > > > >>>> similar > > > > > > > > >>>>> steps should be brought up for the ODBC once it’s > ready. > > > > > > > > >>>>> > > > > > > > > >>>>> 2. Make the first letters of city and people tables > > > > uppercase: > > > > > > city > > > > > > > > -> > > > > > > > > >>>>> City, people -> People > > > > > > > > >>>>> > > > > > > > > >>>>> 3. Rename INSERT section to “Inserting Data”, SELECT to > > > > > “Querying > > > > > > > > >> Data”, > > > > > > > > >>>>> UPDATE -> “Modifying Data”, DELETE to “Removing Data” > or > > to > > > > > > better > > > > > > > > >>>>> alternatives. > > > > > > > > >>>>> > > > > > > > > >>>>> 4. Show how to insert at least 2 cities and 5 people in > > the > > > > > > INSERT > > > > > > > > >>>> section. > > > > > > > > >>>>> > > > > > > > > >>>>> — > > > > > > > > >>>>> Denis > > > > > > > > >>>>> > > > > > > > > >>>>> On Aug 11, 2017, at 10:42 AM, Akmal Chaudhri < > > > > > > > > >>>> [hidden email]> > > > > > > > > >>>>> wrote: > > > > > > > > >>>>> > > > > > > > > >>>>> Denis, All > > > > > > > > >>>>> > > > > > > > > >>>>> I have made some progress with the documentation: > > > > > > > > >>>>> > > > > > > > > >>>>> https://apacheignite.readme. > > io/v2.1/docs/getting-started- > > > sql > > > > < > > > > > > > > >>>>> https://apacheignite.readme. > > io/v2.1/docs/getting-started- > > > sql > > > > > > > > > > > > > >>>>> > > > > > > > > >>>>> ODBC connectivity and examples are missing, but should > be > > > > > > completed > > > > > > > > >> very > > > > > > > > >>>>> soon. > > > > > > > > >>>>> > > > > > > > > >>>>> Community feedback welcome. > > > > > > > > >>>>> > > > > > > > > >>>>> Thanks. > > > > > > > > >>>>> > > > > > > > > >>>>> On 31 July 2017 at 19:02, Denis Magda < > [hidden email] > > < > > > > > > > > >>>>> mailto:[hidden email] <[hidden email]>>> wrote: > > > > > > > > >>>>> Igniters, > > > > > > > > >>>>> > > > > > > > > >>>>> There is a lot of SQL related documentation available > for > > > > > Ignite. > > > > > > > > >>>> However, > > > > > > > > >>>>> the one can get lost in it when he/she does her first > > steps > > > > on > > > > > a > > > > > > > > >> learning > > > > > > > > >>>>> path. It’s time to simplify these are first steps with > a > > > > clear > > > > > > and > > > > > > > > >>>>> straightforward getting started guide. I’ve put the > > > > > requirements > > > > > > > into > > > > > > > > >>>> this > > > > > > > > >>>>> JIRA ticket: > > > > > > > > >>>>> https://issues.apache.org/jira/browse/IGNITE-5886 < > > > > > > > > >>>>> https://issues.apache.org/jira/browse/IGNITE-5886> > > > > > > > > >>>>> > > > > > > > > >>>>> Please share your thoughts in JIRA or in this > discussion. > > > > > > > > >>>>> > > > > > > > > >>>>> Akmal, who perfected his technical writer skills > working > > > for > > > > > IBM, > > > > > > > > >>>>> volunteered to take over this task. Akmal, please > create > > an > > > > > > account > > > > > > > > in > > > > > > > > >>>>> Ignite JIRA and share it with us. You’ll be able to > > assign > > > > the > > > > > > task > > > > > > > > on > > > > > > > > >>>>> yourself afterwards. > > > > > > > > >>>>> https://issues.apache.org/jira/projects/IGNITE < > > > > > > > > >>>> https://issues.apache.org/ > > > > > > > > >>>>> jira/projects/IGNITE> > > > > > > > > >>>>> > > > > > > > > >>>>> Moreover, once the guide is ready Prachi will use it > as a > > > > basis > > > > > > for > > > > > > > > the > > > > > > > > >>>>> new SQL screencast we need to produce. > > > > > > > > >>>>> > > > > > > > > >>>>> — > > > > > > > > >>>>> Denis > > > > > > > > >>>>> > > > > > > > > >>>>> > > > > > > > > >>>>> > > > > > > > > >>>>> > > > > > > > > >>>> > > > > > > > > >> > > > > > > > > >> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > |
Thanks, Prachi! Looks complete, not sure how I missed it the first time.
On Mon, Aug 21, 2017 at 5:52 PM, Prachi Garg <[hidden email]> wrote: > https://apacheignite.readme.io/docs/distributed-ddl#section-create-table > has examples for template and other extended parameters. The Extended > Parameters section explains how to register a template. > > On Mon, Aug 21, 2017 at 5:19 PM, Dmitriy Setrakyan <[hidden email]> wrote: > > > Prachi, is there an example for a template file? Is there an example of > how > > a template should be registered? Is there an example of how other > extended > > parameters should be configured, i.e. a sample CREATE TABLE command? > > > > On Mon, Aug 21, 2017 at 5:15 PM, Prachi Garg <[hidden email]> wrote: > > > > > Template syntax is documented here - > > > https://apacheignite.readme.io/docs/distributed-ddl# > > > section-extended-parameters > > > > > > I've added a brief explanation on the SQL page (on the website) as > well. > > > > > > On Mon, Aug 21, 2017 at 4:40 PM, Dmitriy Setrakyan <[hidden email]> > > wrote: > > > > > > > Nikita, > > > > > > > > Thanks for checking. No, this is not on purpose. > > > > > > > > Denis, do we have the template syntax documented anywhere? > > > > > > > > D. > > > > > > > > On Mon, Aug 21, 2017 at 9:42 AM, Nikita Ivanov <[hidden email]> > > > > wrote: > > > > > > > > > I looked briefly and I couldn't find any explanation on "template" > at > > > > all - > > > > > the only unique caveat apart from standard SQL. Is this on purpose? > > > > > > > > > > -- > > > > > Nikita Ivanov > > > > > > > > > > > > > > > On Mon, Aug 21, 2017 at 9:36 AM, Prachi Garg <[hidden email]> > > > wrote: > > > > > > > > > > > Igor, Pavel > > > > > > > > > > > > On the website[1], I have added SQL, JDBC, ODBC, and Java API > > > examples > > > > > for > > > > > > DDL, > > > > > > DML and queries . I could not find DDL examples for .NET and C++ > in > > > the > > > > > > documentation. Please add the missing code snippets for .NET and > > C++ > > > > > APIs > > > > > > taking SQL syntax from the Java API example. > > > > > > > > > > > > [1] https://ignite.apache.org/features/sql.html > > > > > > > > > > > > On Mon, Aug 21, 2017 at 3:28 AM, Igor Sapego <[hidden email] > > > > > > wrote: > > > > > > > > > > > > > Prachi, > > > > > > > > > > > > > > Yeah, looks good. I've added creation of "Person" table to > > > > > documentation, > > > > > > > so take a look please. > > > > > > > > > > > > > > Best Regards, > > > > > > > Igor > > > > > > > > > > > > > > On Fri, Aug 18, 2017 at 10:29 PM, Prachi Garg < > > [hidden email]> > > > > > > wrote: > > > > > > > > > > > > > > > Hi Igor, > > > > > > > > > > > > > > > > The getting started guide is missing an example oh how to > > create > > > a > > > > > > Person > > > > > > > > table (under ODBC tab). > > > > > > > > https://apacheignite.readme.io/docs/getting-started-sql# > > > > > > > > section-create-tables > > > > > > > > > > > > > > > > I am trying to put one on the website. Does the following > look > > > ok? > > > > > > > > > > > > > > > > // Create table based on PARTITIONED template with one backup > > > > > > > > SQLCHAR query[] = "CREATE TABLE Person ( " > > > > > > > > "id LONG, name VARCHAR, city_id LONG " > > > > > > > > "PRIMARY KEY (id, city_id)) " > > > > > > > > "WITH \"backups=1, affinityKey=city_id\""; > > > > > > > > SQLSMALLINT queryLen = static_cast<SQLSMALLINT>( > > sizeof(query)); > > > > > > > > > > > > > > > > SQLRETURN ret = SQLExecDirect(stmt, query, queryLen); > > > > > > > > > > > > > > > > > > > > > > > > On Fri, Aug 18, 2017 at 12:09 PM, Denis Magda < > > [hidden email] > > > > > > > > > > wrote: > > > > > > > > > > > > > > > > > Igor, thanks a lot. Appreciate this! > > > > > > > > > > > > > > > > > > — > > > > > > > > > Denis > > > > > > > > > > > > > > > > > > > On Aug 18, 2017, at 8:56 AM, Igor Sapego < > > [hidden email] > > > > > > > > > > wrote: > > > > > > > > > > > > > > > > > > > > I've checked ODBC snippets and fixed all found issues. > > > > > > > > > > > > > > > > > > > > Best Regards, > > > > > > > > > > Igor > > > > > > > > > > > > > > > > > > > > On Thu, Aug 17, 2017 at 11:16 PM, Denis Magda < > > > > [hidden email] > > > > > > > > > > > > > > wrote: > > > > > > > > > > > > > > > > > > > >> Igor, > > > > > > > > > >> > > > > > > > > > >> Would you mind helping us to test the snippets? I do > > believe > > > > it > > > > > > will > > > > > > > > > take > > > > > > > > > >> you a couple of minutes since the environment is set up > on > > > > your > > > > > > > side. > > > > > > > > > >> > > > > > > > > > >> — > > > > > > > > > >> Denis > > > > > > > > > >> > > > > > > > > > >>> On Aug 17, 2017, at 5:37 AM, Igor Sapego < > > > [hidden email] > > > > > > > > > > > > wrote: > > > > > > > > > >>> > > > > > > > > > >>> Akmal, > > > > > > > > > >>> > > > > > > > > > >>> I work on the ODBC driver and would be glad to help. > You > > > can > > > > > send > > > > > > > > > >>> mails with your requests to devlist and I will try to > > help > > > as > > > > > > much > > > > > > > > as I > > > > > > > > > >>> can. > > > > > > > > > >>> > > > > > > > > > >>> Best Regards, > > > > > > > > > >>> Igor > > > > > > > > > >>> > > > > > > > > > >>> On Thu, Aug 17, 2017 at 3:28 PM, Akmal Chaudhri < > > > > > > > > > >> [hidden email] > > > > > > > > > >>>> wrote: > > > > > > > > > >>> > > > > > > > > > >>>> When I have the opportunity to test the ODBC code and > > > ensure > > > > > > that > > > > > > > it > > > > > > > > > >>>> performs, I will add it to GH. At the moment, just > > > snippets > > > > > > exist. > > > > > > > > If > > > > > > > > > >>>> anyone can assist with this, I would appreciate it, > as I > > > > have > > > > > no > > > > > > > > > >> experience > > > > > > > > > >>>> with ODBC. I made some efforts to build the ODBC > driver > > > and > > > > > have > > > > > > > had > > > > > > > > > >> some > > > > > > > > > >>>> success on Windows and Linux, but have been unable to > > run > > > > any > > > > > > C++ > > > > > > > > > code. > > > > > > > > > >>>> > > > > > > > > > >>>> On 16 August 2017 at 21:41, Denis Magda < > > > [hidden email]> > > > > > > > wrote: > > > > > > > > > >>>> > > > > > > > > > >>>>> Igniters, > > > > > > > > > >>>>> > > > > > > > > > >>>>> The SQL getting started guide is ready and published: > > > > > > > > > >>>>> https://apacheignite.readme. > > > io/v2.1/docs/getting-started- > > > > sql > > > > > > > > > >>>>> > > > > > > > > > >>>>> Akmal thanks for your efforts and please apply the > > > > following > > > > > > > minor > > > > > > > > > >>>> changes: > > > > > > > > > >>>>> * Add ODBC source files to your GitHub project. > > > > > > > > > >>>>> * Add a flat SQL file (script) to the same project > that > > > > will > > > > > > > > include > > > > > > > > > >> all > > > > > > > > > >>>>> the pure SQL statements used in the guide. > > > > > > > > > >>>>> > > > > > > > > > >>>>> Basing on this guide I’ve prepared and release a > guide > > > for > > > > > > > DBeaver > > > > > > > > > SQL > > > > > > > > > >>>>> tool: > > > > > > > > > >>>>> https://apacheignite-tools.readme.io/docs/dbeaver > > > > > > > > > >>>>> > > > > > > > > > >>>>> — > > > > > > > > > >>>>> Denis > > > > > > > > > >>>>> > > > > > > > > > >>>>> On Aug 11, 2017, at 3:17 PM, Denis Magda < > > > > [hidden email]> > > > > > > > > wrote: > > > > > > > > > >>>>> > > > > > > > > > >>>>> Akmal, > > > > > > > > > >>>>> > > > > > > > > > >>>>> Good start! Please consider the following feedback: > > > > > > > > > >>>>> > > > > > > > > > >>>>> 1. Connectivity section. Emphasize that > ignite-core.jar > > > has > > > > > to > > > > > > be > > > > > > > > > >> copied > > > > > > > > > >>>>> to the classpath of an app or tool and give a link to > > > more > > > > > > > advanced > > > > > > > > > >> JDBC > > > > > > > > > >>>>> Thin driver documentation if the one needs more > > details. > > > > > > > Probably, > > > > > > > > > >>>> similar > > > > > > > > > >>>>> steps should be brought up for the ODBC once it’s > > ready. > > > > > > > > > >>>>> > > > > > > > > > >>>>> 2. Make the first letters of city and people tables > > > > > uppercase: > > > > > > > city > > > > > > > > > -> > > > > > > > > > >>>>> City, people -> People > > > > > > > > > >>>>> > > > > > > > > > >>>>> 3. Rename INSERT section to “Inserting Data”, SELECT > to > > > > > > “Querying > > > > > > > > > >> Data”, > > > > > > > > > >>>>> UPDATE -> “Modifying Data”, DELETE to “Removing Data” > > or > > > to > > > > > > > better > > > > > > > > > >>>>> alternatives. > > > > > > > > > >>>>> > > > > > > > > > >>>>> 4. Show how to insert at least 2 cities and 5 people > in > > > the > > > > > > > INSERT > > > > > > > > > >>>> section. > > > > > > > > > >>>>> > > > > > > > > > >>>>> — > > > > > > > > > >>>>> Denis > > > > > > > > > >>>>> > > > > > > > > > >>>>> On Aug 11, 2017, at 10:42 AM, Akmal Chaudhri < > > > > > > > > > >>>> [hidden email]> > > > > > > > > > >>>>> wrote: > > > > > > > > > >>>>> > > > > > > > > > >>>>> Denis, All > > > > > > > > > >>>>> > > > > > > > > > >>>>> I have made some progress with the documentation: > > > > > > > > > >>>>> > > > > > > > > > >>>>> https://apacheignite.readme. > > > io/v2.1/docs/getting-started- > > > > sql > > > > > < > > > > > > > > > >>>>> https://apacheignite.readme. > > > io/v2.1/docs/getting-started- > > > > sql > > > > > > > > > > > > > > > >>>>> > > > > > > > > > >>>>> ODBC connectivity and examples are missing, but > should > > be > > > > > > > completed > > > > > > > > > >> very > > > > > > > > > >>>>> soon. > > > > > > > > > >>>>> > > > > > > > > > >>>>> Community feedback welcome. > > > > > > > > > >>>>> > > > > > > > > > >>>>> Thanks. > > > > > > > > > >>>>> > > > > > > > > > >>>>> On 31 July 2017 at 19:02, Denis Magda < > > [hidden email] > > > < > > > > > > > > > >>>>> mailto:[hidden email] <[hidden email]>>> > wrote: > > > > > > > > > >>>>> Igniters, > > > > > > > > > >>>>> > > > > > > > > > >>>>> There is a lot of SQL related documentation available > > for > > > > > > Ignite. > > > > > > > > > >>>> However, > > > > > > > > > >>>>> the one can get lost in it when he/she does her first > > > steps > > > > > on > > > > > > a > > > > > > > > > >> learning > > > > > > > > > >>>>> path. It’s time to simplify these are first steps > with > > a > > > > > clear > > > > > > > and > > > > > > > > > >>>>> straightforward getting started guide. I’ve put the > > > > > > requirements > > > > > > > > into > > > > > > > > > >>>> this > > > > > > > > > >>>>> JIRA ticket: > > > > > > > > > >>>>> https://issues.apache.org/jira/browse/IGNITE-5886 < > > > > > > > > > >>>>> https://issues.apache.org/jira/browse/IGNITE-5886> > > > > > > > > > >>>>> > > > > > > > > > >>>>> Please share your thoughts in JIRA or in this > > discussion. > > > > > > > > > >>>>> > > > > > > > > > >>>>> Akmal, who perfected his technical writer skills > > working > > > > for > > > > > > IBM, > > > > > > > > > >>>>> volunteered to take over this task. Akmal, please > > create > > > an > > > > > > > account > > > > > > > > > in > > > > > > > > > >>>>> Ignite JIRA and share it with us. You’ll be able to > > > assign > > > > > the > > > > > > > task > > > > > > > > > on > > > > > > > > > >>>>> yourself afterwards. > > > > > > > > > >>>>> https://issues.apache.org/jira/projects/IGNITE < > > > > > > > > > >>>> https://issues.apache.org/ > > > > > > > > > >>>>> jira/projects/IGNITE> > > > > > > > > > >>>>> > > > > > > > > > >>>>> Moreover, once the guide is ready Prachi will use it > > as a > > > > > basis > > > > > > > for > > > > > > > > > the > > > > > > > > > >>>>> new SQL screencast we need to produce. > > > > > > > > > >>>>> > > > > > > > > > >>>>> — > > > > > > > > > >>>>> Denis > > > > > > > > > >>>>> > > > > > > > > > >>>>> > > > > > > > > > >>>>> > > > > > > > > > >>>>> > > > > > > > > > >>>> > > > > > > > > > >> > > > > > > > > > >> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > |
Free forum by Nabble | Edit this page |