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