Thanks, Prachi! Looks complete, not sure how I missed it the first time. On Mon, Aug 21, 2017 at 5:52 PM, Prachi Garg <pg...@gridgain.com> 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 <d...@gridgain.com> 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 <pg...@gridgain.com> 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 <d...@gridgain.com> > > 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 <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 > > > > > > > > > >>>>> > > > > > > > > > >>>>> > > > > > > > > > >>>>> > > > > > > > > > >>>>> > > > > > > > > > >>>> > > > > > > > > > >> > > > > > > > > > >> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
