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 <nivano...@gmail.com> 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 <pg...@gridgain.com> 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 <isap...@apache.org> 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 <pg...@gridgain.com> > > 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 <dma...@apache.org> > > wrote: > > > > > > > > > Igor, thanks a lot. Appreciate this! > > > > > > > > > > — > > > > > Denis > > > > > > > > > > > On Aug 18, 2017, at 8:56 AM, Igor Sapego <isap...@apache.org> > > 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 <dma...@apache.org > > > > > > 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 <isap...@apache.org> > > > 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 < > > > > > >> akmal.chaud...@gridgain.com > > > > > >>>> 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 <dma...@apache.org> > > > 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 <dma...@apache.org> > > > > 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 < > > > > > >>>> akmal.chaud...@gridgain.com> > > > > > >>>>> 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 <dma...@apache.org < > > > > > >>>>> mailto:dma...@apache.org <dma...@apache.org>>> 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 > > > > > >>>>> > > > > > >>>>> > > > > > >>>>> > > > > > >>>>> > > > > > >>>> > > > > > >> > > > > > >> > > > > > > > > > > > > > > > > > > > >