ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dmitriy Setrakyan...@gridgain.com>
Subject Re: SQL Getting Started Guide
Date Mon, 21 Aug 2017 23:40:09 GMT
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