ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Prachi Garg <pg...@gridgain.com>
Subject Re: SQL Getting Started Guide
Date Tue, 22 Aug 2017 00:52:25 GMT
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 <pgarg@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 <nivanov30@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 <pgarg@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 <isapego@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 <
> 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