ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Igor Sapego <isap...@apache.org>
Subject Re: SQL Getting Started Guide
Date Mon, 21 Aug 2017 10:28:42 GMT
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 <pgarg@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 <dmagda@apache.org> wrote:
>
> > Igor, thanks a lot. Appreciate this!
> >
> > —
> > Denis
> >
> > > On Aug 18, 2017, at 8:56 AM, Igor Sapego <isapego@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 <dmagda@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 <isapego@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.chaudhri@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 <dmagda@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 <dmagda@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.chaudhri@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 <dmagda@apache.org
<
> > >>>>> mailto:dmagda@apache.org <dmagda@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
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>
> > >>
> > >>
> >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message