You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ignite.apache.org by Serge Puchnin <se...@gmail.com> on 2017/08/29 09:38:34 UTC
sql documentation
Hi !
As I can see, there is some room for documentation improvement.
As a sample of documentation, I've prepared a description of "CREATE INDEX"
statement.
What’s your opinion?
What can be improved?
What should be added?
Thanks a lot!
---
Serge
Re: sql documentation
Posted by Sergey Kozlov <sk...@gridgain.com>.
I would suggest to change second "SQL" topic to following
SQL statement syntax
- DML
- SELECT ...
- DDL
- CREATE TABLE
- DROP TABLE
- ALTER TABLE
- CREATE INDEX
....
- ANSI 99 compliance
On Tue, Sep 12, 2017 at 6:26 PM, Serge Puchnin <se...@gmail.com>
wrote:
> I've added a page for SQL language, create index statement and Upper
> function as an example for the new format:
>
> https://apacheignite-sql.readme.io/v2.1/docs/create-index
>
>
>
> For me, it'd be OK to add a separate page for each SQL statement.
>
>
> BR,
>
> Serge
>
> On Sat, 9 Sep 2017 at 02:19, Denis Magda <dm...@apache.org> wrote:
>
> > Please check you inbox.
> >
> > —
> > Denis
> >
> > > On Sep 8, 2017, at 3:38 PM, Dmitriy Setrakyan <ds...@apache.org>
> > wrote:
> > >
> > > Denis,
> > >
> > > Can you please add me as an admin to that site?
> > >
> > > D.
> > >
> > > On Fri, Sep 8, 2017 at 3:23 PM, Denis Magda <dm...@apache.org> wrote:
> > >
> > >> Igniter (especially those who are willing to work on the new SQL doc),
> > >>
> > >> The doc for SQL capabilities has been set up. Copy pasted all the SQL
> > >> materials we have there:
> > >> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.
> > >> readme.io/docs>
> > >>
> > >> Sergey P., feel free to start reworking the doc according to the new
> > >> proposed format. Don’t hesitate removing outdating or misleading
> > content.
> > >> If you’re uncertain about something just send us a message here.
> > >>
> > >> Presently the doc is not indexed by searching engines. Let’s finish it
> > >> first and announce afterwards.
> > >>
> > >> —
> > >> Denis
> > >>
> > >>> On Aug 30, 2017, at 5:43 PM, Dmitriy Setrakyan <
> dsetrakyan@apache.org>
> > >> wrote:
> > >>>
> > >>> On Wed, Aug 30, 2017 at 10:04 PM, Denis Magda <dm...@apache.org>
> > wrote:
> > >>>
> > >>>> Serge,
> > >>>>
> > >>>> Undoubtedly, I like this format. I’ve created a new documentation
> > domain
> > >>>> for all our SQL capabilities:
> > >>>> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.
> > >>>> readme.io/docs>
> > >>>>
> > >>>> Once I get an open source license for it we can start moving the
> > >> existing
> > >>>> docs and create the new there.
> > >>>>
> > >>>
> > >>> Sounds good. We should make sure that we do not "move" the
> > documentation,
> > >>> we should "copy" it. Otherwise we will get 404 errors in google.
> > >>>
> > >>>
> > >>>>
> > >>>> —
> > >>>> Denis
> > >>>>
> > >>>>> On Aug 30, 2017, at 4:38 AM, Serge Puchnin n <
> > sergey.puchnin@gmail.com
> > >>>
> > >>>> wrote:
> > >>>>>
> > >>>>> Sorry for inconvenience!
> > >>>>> there is a link for a sample:
> > >>>>> https://drive.google.com/open?id=0B-s4Ivq-
> > >> lrPobzZ4c2Y1X1ZLcWhGenE4TllVM3
> > >>>> VlODhtT2Iw
> > >>>>>
> > >>>>> Serge
> > >>>>>
> > >>>>>> On 29 Aug 2017, at 19:30, Denis Magda <dm...@apache.org> wrote:
> > >>>>>>
> > >>>>>> Serge,
> > >>>>>>
> > >>>>>> The attachment is missing. Try to share it via google drive or
> other
> > >>>> storage.
> > >>>>>>
> > >>>>>> —
> > >>>>>> Denis
> > >>>>>>
> > >>>>>>> On Aug 29, 2017, at 2:38 AM, Serge Puchnin <
> > sergey.puchnin@gmail.com
> > >>>
> > >>>> wrote:
> > >>>>>>>
> > >>>>>>> Hi !
> > >>>>>>>
> > >>>>>>> As I can see, there is some room for documentation improvement.
> > >>>>>>> As a sample of documentation, I've prepared a description of
> > "CREATE
> > >>>> INDEX" statement.
> > >>>>>>>
> > >>>>>>> What’s your opinion?
> > >>>>>>> What can be improved?
> > >>>>>>> What should be added?
> > >>>>>>>
> > >>>>>>> Thanks a lot!
> > >>>>>>>
> > >>>>>>> ---
> > >>>>>>> Serge
> > >>>>>>
> > >>>>
> > >>>>
> > >>
> > >>
> >
> >
>
--
Sergey Kozlov
GridGain Systems
www.gridgain.com
Re: sql documentation
Posted by Denis Magda <dm...@apache.org>.
Pavel,
There will be a single SQL related page in Java, .NET and C++ docs that will refer to these new docs. Plus SQL will appear in the header of every readme.io domain.
I’ll take care of this when we will be releasing all 2.3 docs. Here is a ticket to track all the things to be done with SQL:
https://issues.apache.org/jira/browse/IGNITE-6685
—
Denis
> On Oct 20, 2017, at 1:51 AM, Pavel Tupitsyn <pt...@apache.org> wrote:
>
>> that all the SQL related pages will be hidden
>
> Denis, please make sure to update all references to these pages.
> It should be obvious from Java/.NET/C++ docs that SQL features are present
> and did not disappear from the docs.
>
> Consider scenario:
> As a user, I go to apacheignite-net.readme.io <http://apacheignite-net.readme.io/> and search for SQL and LINQ
> (in the search bar). Do I find anything?
>
> Thanks,
> Pavel
>
> On Fri, Oct 20, 2017 at 8:09 AM, Denis Magda <dmagda@gridgain.com <ma...@gridgain.com>> wrote:
>
>> On Thursday, October 19, 2017, Dmitriy Setrakyan <ds...@apache.org>
>> wrote:
>>
>>> Denis,
>>>
>>> Awesome work and great contribution!
>>>
>>> A minor comment. Does SELECT belong under DML?
>>
>>
>> Thanks for feedback!
>>
>> It turned out that yes, SELECT belongs to DML. Personally, I deciphered ‘M’
>> as ‘modification’ before while in fact it stands for ‘manipulation’.
>>
>> Some proof links:
>> https://en.m.wikipedia.org/wiki/Data_manipulation_language
>> http://www.h2database.com/html/grammar.html
>>
>> Denis
>>
>>>
>>> D.
>>>
>>>
>>> On Thu, Oct 19, 2017 at 6:36 PM, Denis Magda <dmagda@apache.org
>>> <javascript:;>> wrote:
>>>
>>>> Igniters,
>>>>
>>>> I’m glad to share that the new SQL doc is ready for proof read:
>>>> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.readme.io/docs>
>>>>
>>>> Main sections:
>>>> - Overview - SQL capabilities outline and getting started guide.
>>>> - SQL Reference - SQL itself with all the commands and operations.
>>>> - Architecture - insights on how SQL engine works and some of its
>>> features.
>>>> - JDBC
>>>> - ODBC
>>>> - Tools and Analytics - tools to work with Ignite as with SQL database.
>>>> - Java Dev Guide - Java specific features
>>>> - .NET Dev Guide - .NET specific features
>>>> - C++ Dev Guide - C++ specific features
>>>>
>>>> Note, that all the SQL related pages will be hidden (consider removed)
>> on
>>>> Java, .NET and C++ readme.io <http://readme.io/> sites in 2.3. All the SQL related
>>>> capabilities have to be documented on this new specific doc.
>>>>
>>>> Here is we’re tracking minor documentation tasks to close before the
>>>> release:
>>>> https://issues.apache.org/jira/browse/IGNITE-6685 <https://issues.apache.org/jira/browse/IGNITE-6685>
>>>>
>>>> Many thanks to Sergey Puchnin for the help with SQL reference
>>>> documentation!
>>>>
>>>> —
>>>> Denis
>>>>
>>>>
>>>>> On Sep 14, 2017, at 5:00 AM, Serge Puchnin <sergey.puchnin@gmail.com <ma...@gmail.com>
>>> <javascript:;>>
>>>> wrote:
>>>>>
>>>>> Denis,
>>>>> Thanks a lot for the link.
>>>>> It's very helpful to split "function part" to more specific like
>>>> 'string',
>>>>> 'numeric', etc.
>>>>>
>>>>> the main reason to separate "Java Developer" as an independent part
>>>> because
>>>>> it's about a mix between Java and SQL code.
>>>>> It's about classes, methods, annotation, GC, etc.
>>>>> It doesn't fully belong to the SQL specification but IMHO should be
>> in
>>>> SQL
>>>>> category.
>>>>>
>>>>> BR,
>>>>> Serge
>>>>>
>>>>> On Wed, 13 Sep 2017 at 22:39, Denis Magda <dmagda@apache.org <ma...@apache.org>
>>> <javascript:;>> wrote:
>>>>>
>>>>>> Serge,
>>>>>>
>>>>>> I like the proposed format. It reminds me the one chosen by MemSQL
>>> which
>>>>>> is crystal clear:
>>>>>> https://docs.memsql.com/sql-reference/v5.8/sql-reference-overview/ <https://docs.memsql.com/sql-reference/v5.8/sql-reference-overview/>
>>>>>>
>>>>>> Not 100% sure about “Java Developer Guides” section. Let me
>>> contemplate
>>>> a
>>>>>> bit and propose other solutions.
>>>>>>
>>>>>> —
>>>>>> Denis
>>>>>>
>>>>>> On Sep 13, 2017, at 3:41 AM, Serge Puchnin <
>> sergey.puchnin@gmail.com <ma...@gmail.com>
>>> <javascript:;>>
>>>>>> wrote:
>>>>>>
>>>>>> I have done some reorganizing for the SQL documentation.
>>>>>> Thanks a lot for the review and proof read.
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Wed, 13 Sep 2017 at 01:22, Dmitriy Setrakyan <
>>> dsetrakyan@apache.org <ma...@apache.org> <javascript:;>>
>>>>>> wrote:
>>>>>>
>>>>>>> Thanks Sergey, I think we should add SQL Syntax section on the
>> left.
>>>> Also,
>>>>>>> please let us know when we can proof read it. I would like to fix
>>> some
>>>>>>> phrasing on the page.
>>>>>>>
>>>>>>> On Tue, Sep 12, 2017 at 8:26 AM, Serge Puchnin <
>>>> sergey.puchnin@gmail.com <ma...@gmail.com> <javascript:;>>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> I've added a page for SQL language, create index statement and
>> Upper
>>>>>>>> function as an example for the new format:
>>>>>>>>
>>>>>>>> https://apacheignite-sql.readme.io/v2.1/docs/create-index <https://apacheignite-sql.readme.io/v2.1/docs/create-index>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> For me, it'd be OK to add a separate page for each SQL statement.
>>>>>>>>
>>>>>>>>
>>>>>>>> BR,
>>>>>>>>
>>>>>>>> Serge
>>>>>>>>
>>>>>>>> On Sat, 9 Sep 2017 at 02:19, Denis Magda <dmagda@apache.org <ma...@apache.org>
>>> <javascript:;>> wrote:
>>>>>>>>
>>>>>>>>> Please check you inbox.
>>>>>>>>>
>>>>>>>>> —
>>>>>>>>> Denis
>>>>>>>>>
>>>>>>>>>> On Sep 8, 2017, at 3:38 PM, Dmitriy Setrakyan <
>>>>>>> dsetrakyan@apache.org <ma...@apache.org> <javascript:;>>
>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>> Denis,
>>>>>>>>>>
>>>>>>>>>> Can you please add me as an admin to that site?
>>>>>>>>>>
>>>>>>>>>> D.
>>>>>>>>>>
>>>>>>>>>> On Fri, Sep 8, 2017 at 3:23 PM, Denis Magda <dmagda@apache.org <ma...@apache.org>
>>> <javascript:;>>
>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>> Igniter (especially those who are willing to work on the new
>> SQL
>>>>>>> doc),
>>>>>>>>>>>
>>>>>>>>>>> The doc for SQL capabilities has been set up. Copy pasted all
>> the
>>>>>>> SQL
>>>>>>>>>>> materials we have there:
>>>>>>>>>>> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.readme.io/docs> <
>>> https://apacheignite-sql <https://apacheignite-sql/>.
>>>>>>>>>>> readme.io/docs <http://readme.io/docs>>
>>>>>>>>>>>
>>>>>>>>>>> Sergey P., feel free to start reworking the doc according to
>> the
>>>>>>> new
>>>>>>>>>>> proposed format. Don’t hesitate removing outdating or
>> misleading
>>>>>>>>> content.
>>>>>>>>>>> If you’re uncertain about something just send us a message
>> here.
>>>>>>>>>>>
>>>>>>>>>>> Presently the doc is not indexed by searching engines. Let’s
>>>>>>> finish it
>>>>>>>>>>> first and announce afterwards.
>>>>>>>>>>>
>>>>>>>>>>> —
>>>>>>>>>>> Denis
>>>>>>>>>>>
>>>>>>>>>>>> On Aug 30, 2017, at 5:43 PM, Dmitriy Setrakyan <
>>>>>>>> dsetrakyan@apache.org <ma...@apache.org> <javascript:;>>
>>>>>>>>>>> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>> On Wed, Aug 30, 2017 at 10:04 PM, Denis Magda <
>>> dmagda@apache.org <ma...@apache.org> <javascript:;>>
>>>>>>>>> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>> Serge,
>>>>>>>>>>>>>
>>>>>>>>>>>>> Undoubtedly, I like this format. I’ve created a new
>>> documentation
>>>>>>>>> domain
>>>>>>>>>>>>> for all our SQL capabilities:
>>>>>>>>>>>>> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.readme.io/docs> <
>>>>>>> https://apacheignite-sql <https://apacheignite-sql/>.
>>>>>>>>>>>>> readme.io/docs <http://readme.io/docs>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> Once I get an open source license for it we can start moving
>>> the
>>>>>>>>>>> existing
>>>>>>>>>>>>> docs and create the new there.
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> Sounds good. We should make sure that we do not "move" the
>>>>>>>>> documentation,
>>>>>>>>>>>> we should "copy" it. Otherwise we will get 404 errors in
>> google.
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> —
>>>>>>>>>>>>> Denis
>>>>>>>>>>>>>
>>>>>>>>>>>>>> On Aug 30, 2017, at 4:38 AM, Serge Puchnin n <
>>>>>>>>> sergey.puchnin@gmail.com <ma...@gmail.com> <javascript:;>
>>>>>>>>>>>>
>>>>>>>>>>>>> wrote:
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Sorry for inconvenience!
>>>>>>>>>>>>>> there is a link for a sample:
>>>>>>>>>>>>>> https://drive.google.com/open?id=0B-s4Ivq- <https://drive.google.com/open?id=0B-s4Ivq->
>>>>>>>>>>> lrPobzZ4c2Y1X1ZLcWhGenE4TllVM3
>>>>>>>>>>>>> VlODhtT2Iw
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Serge
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> On 29 Aug 2017, at 19:30, Denis Magda <dmagda@apache.org <ma...@apache.org>
>>> <javascript:;>>
>>>>>>> wrote:
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> Serge,
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> The attachment is missing. Try to share it via google drive
>>> or
>>>>>>>> other
>>>>>>>>>>>>> storage.
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> —
>>>>>>>>>>>>>>> Denis
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> On Aug 29, 2017, at 2:38 AM, Serge Puchnin <
>>>>>>>>> sergey.puchnin@gmail.com <ma...@gmail.com> <javascript:;>
>>>>>>>>>>>>
>>>>>>>>>>>>> wrote:
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> Hi !
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> As I can see, there is some room for documentation
>>>>>>> improvement.
>>>>>>>>>>>>>>>> As a sample of documentation, I've prepared a description
>> of
>>>>>>>>> "CREATE
>>>>>>>>>>>>> INDEX" statement.
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> What’s your opinion?
>>>>>>>>>>>>>>>> What can be improved?
>>>>>>>>>>>>>>>> What should be added?
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> Thanks a lot!
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> ---
>>>>>>>>>>>>>>>> Serge
Re: sql documentation
Posted by Pavel Tupitsyn <pt...@apache.org>.
> that all the SQL related pages will be hidden
Denis, please make sure to update all references to these pages.
It should be obvious from Java/.NET/C++ docs that SQL features are present
and did not disappear from the docs.
Consider scenario:
As a user, I go to apacheignite-net.readme.io and search for SQL and LINQ
(in the search bar). Do I find anything?
Thanks,
Pavel
On Fri, Oct 20, 2017 at 8:09 AM, Denis Magda <dm...@gridgain.com> wrote:
> On Thursday, October 19, 2017, Dmitriy Setrakyan <ds...@apache.org>
> wrote:
>
> > Denis,
> >
> > Awesome work and great contribution!
> >
> > A minor comment. Does SELECT belong under DML?
>
>
> Thanks for feedback!
>
> It turned out that yes, SELECT belongs to DML. Personally, I deciphered ‘M’
> as ‘modification’ before while in fact it stands for ‘manipulation’.
>
> Some proof links:
> https://en.m.wikipedia.org/wiki/Data_manipulation_language
> http://www.h2database.com/html/grammar.html
>
> Denis
>
> >
> > D.
> >
> >
> > On Thu, Oct 19, 2017 at 6:36 PM, Denis Magda <dmagda@apache.org
> > <javascript:;>> wrote:
> >
> > > Igniters,
> > >
> > > I’m glad to share that the new SQL doc is ready for proof read:
> > > https://apacheignite-sql.readme.io/docs
> > >
> > > Main sections:
> > > - Overview - SQL capabilities outline and getting started guide.
> > > - SQL Reference - SQL itself with all the commands and operations.
> > > - Architecture - insights on how SQL engine works and some of its
> > features.
> > > - JDBC
> > > - ODBC
> > > - Tools and Analytics - tools to work with Ignite as with SQL database.
> > > - Java Dev Guide - Java specific features
> > > - .NET Dev Guide - .NET specific features
> > > - C++ Dev Guide - C++ specific features
> > >
> > > Note, that all the SQL related pages will be hidden (consider removed)
> on
> > > Java, .NET and C++ readme.io sites in 2.3. All the SQL related
> > > capabilities have to be documented on this new specific doc.
> > >
> > > Here is we’re tracking minor documentation tasks to close before the
> > > release:
> > > https://issues.apache.org/jira/browse/IGNITE-6685
> > >
> > > Many thanks to Sergey Puchnin for the help with SQL reference
> > > documentation!
> > >
> > > —
> > > Denis
> > >
> > >
> > > > On Sep 14, 2017, at 5:00 AM, Serge Puchnin <sergey.puchnin@gmail.com
> > <javascript:;>>
> > > wrote:
> > > >
> > > > Denis,
> > > > Thanks a lot for the link.
> > > > It's very helpful to split "function part" to more specific like
> > > 'string',
> > > > 'numeric', etc.
> > > >
> > > > the main reason to separate "Java Developer" as an independent part
> > > because
> > > > it's about a mix between Java and SQL code.
> > > > It's about classes, methods, annotation, GC, etc.
> > > > It doesn't fully belong to the SQL specification but IMHO should be
> in
> > > SQL
> > > > category.
> > > >
> > > > BR,
> > > > Serge
> > > >
> > > > On Wed, 13 Sep 2017 at 22:39, Denis Magda <dmagda@apache.org
> > <javascript:;>> wrote:
> > > >
> > > >> Serge,
> > > >>
> > > >> I like the proposed format. It reminds me the one chosen by MemSQL
> > which
> > > >> is crystal clear:
> > > >> https://docs.memsql.com/sql-reference/v5.8/sql-reference-overview/
> > > >>
> > > >> Not 100% sure about “Java Developer Guides” section. Let me
> > contemplate
> > > a
> > > >> bit and propose other solutions.
> > > >>
> > > >> —
> > > >> Denis
> > > >>
> > > >> On Sep 13, 2017, at 3:41 AM, Serge Puchnin <
> sergey.puchnin@gmail.com
> > <javascript:;>>
> > > >> wrote:
> > > >>
> > > >> I have done some reorganizing for the SQL documentation.
> > > >> Thanks a lot for the review and proof read.
> > > >>
> > > >>
> > > >>
> > > >> On Wed, 13 Sep 2017 at 01:22, Dmitriy Setrakyan <
> > dsetrakyan@apache.org <javascript:;>>
> > > >> wrote:
> > > >>
> > > >>> Thanks Sergey, I think we should add SQL Syntax section on the
> left.
> > > Also,
> > > >>> please let us know when we can proof read it. I would like to fix
> > some
> > > >>> phrasing on the page.
> > > >>>
> > > >>> On Tue, Sep 12, 2017 at 8:26 AM, Serge Puchnin <
> > > sergey.puchnin@gmail.com <javascript:;>>
> > > >>> wrote:
> > > >>>
> > > >>>> I've added a page for SQL language, create index statement and
> Upper
> > > >>>> function as an example for the new format:
> > > >>>>
> > > >>>> https://apacheignite-sql.readme.io/v2.1/docs/create-index
> > > >>>>
> > > >>>>
> > > >>>>
> > > >>>> For me, it'd be OK to add a separate page for each SQL statement.
> > > >>>>
> > > >>>>
> > > >>>> BR,
> > > >>>>
> > > >>>> Serge
> > > >>>>
> > > >>>> On Sat, 9 Sep 2017 at 02:19, Denis Magda <dmagda@apache.org
> > <javascript:;>> wrote:
> > > >>>>
> > > >>>>> Please check you inbox.
> > > >>>>>
> > > >>>>> —
> > > >>>>> Denis
> > > >>>>>
> > > >>>>>> On Sep 8, 2017, at 3:38 PM, Dmitriy Setrakyan <
> > > >>> dsetrakyan@apache.org <javascript:;>>
> > > >>>>> wrote:
> > > >>>>>>
> > > >>>>>> Denis,
> > > >>>>>>
> > > >>>>>> Can you please add me as an admin to that site?
> > > >>>>>>
> > > >>>>>> D.
> > > >>>>>>
> > > >>>>>> On Fri, Sep 8, 2017 at 3:23 PM, Denis Magda <dmagda@apache.org
> > <javascript:;>>
> > > >>> wrote:
> > > >>>>>>
> > > >>>>>>> Igniter (especially those who are willing to work on the new
> SQL
> > > >>> doc),
> > > >>>>>>>
> > > >>>>>>> The doc for SQL capabilities has been set up. Copy pasted all
> the
> > > >>> SQL
> > > >>>>>>> materials we have there:
> > > >>>>>>> https://apacheignite-sql.readme.io/docs <
> > https://apacheignite-sql.
> > > >>>>>>> readme.io/docs>
> > > >>>>>>>
> > > >>>>>>> Sergey P., feel free to start reworking the doc according to
> the
> > > >>> new
> > > >>>>>>> proposed format. Don’t hesitate removing outdating or
> misleading
> > > >>>>> content.
> > > >>>>>>> If you’re uncertain about something just send us a message
> here.
> > > >>>>>>>
> > > >>>>>>> Presently the doc is not indexed by searching engines. Let’s
> > > >>> finish it
> > > >>>>>>> first and announce afterwards.
> > > >>>>>>>
> > > >>>>>>> —
> > > >>>>>>> Denis
> > > >>>>>>>
> > > >>>>>>>> On Aug 30, 2017, at 5:43 PM, Dmitriy Setrakyan <
> > > >>>> dsetrakyan@apache.org <javascript:;>>
> > > >>>>>>> wrote:
> > > >>>>>>>>
> > > >>>>>>>> On Wed, Aug 30, 2017 at 10:04 PM, Denis Magda <
> > dmagda@apache.org <javascript:;>>
> > > >>>>> wrote:
> > > >>>>>>>>
> > > >>>>>>>>> Serge,
> > > >>>>>>>>>
> > > >>>>>>>>> Undoubtedly, I like this format. I’ve created a new
> > documentation
> > > >>>>> domain
> > > >>>>>>>>> for all our SQL capabilities:
> > > >>>>>>>>> https://apacheignite-sql.readme.io/docs <
> > > >>> https://apacheignite-sql.
> > > >>>>>>>>> readme.io/docs>
> > > >>>>>>>>>
> > > >>>>>>>>> Once I get an open source license for it we can start moving
> > the
> > > >>>>>>> existing
> > > >>>>>>>>> docs and create the new there.
> > > >>>>>>>>>
> > > >>>>>>>>
> > > >>>>>>>> Sounds good. We should make sure that we do not "move" the
> > > >>>>> documentation,
> > > >>>>>>>> we should "copy" it. Otherwise we will get 404 errors in
> google.
> > > >>>>>>>>
> > > >>>>>>>>
> > > >>>>>>>>>
> > > >>>>>>>>> —
> > > >>>>>>>>> Denis
> > > >>>>>>>>>
> > > >>>>>>>>>> On Aug 30, 2017, at 4:38 AM, Serge Puchnin n <
> > > >>>>> sergey.puchnin@gmail.com <javascript:;>
> > > >>>>>>>>
> > > >>>>>>>>> wrote:
> > > >>>>>>>>>>
> > > >>>>>>>>>> Sorry for inconvenience!
> > > >>>>>>>>>> there is a link for a sample:
> > > >>>>>>>>>> https://drive.google.com/open?id=0B-s4Ivq-
> > > >>>>>>> lrPobzZ4c2Y1X1ZLcWhGenE4TllVM3
> > > >>>>>>>>> VlODhtT2Iw
> > > >>>>>>>>>>
> > > >>>>>>>>>> Serge
> > > >>>>>>>>>>
> > > >>>>>>>>>>> On 29 Aug 2017, at 19:30, Denis Magda <dmagda@apache.org
> > <javascript:;>>
> > > >>> wrote:
> > > >>>>>>>>>>>
> > > >>>>>>>>>>> Serge,
> > > >>>>>>>>>>>
> > > >>>>>>>>>>> The attachment is missing. Try to share it via google drive
> > or
> > > >>>> other
> > > >>>>>>>>> storage.
> > > >>>>>>>>>>>
> > > >>>>>>>>>>> —
> > > >>>>>>>>>>> Denis
> > > >>>>>>>>>>>
> > > >>>>>>>>>>>> On Aug 29, 2017, at 2:38 AM, Serge Puchnin <
> > > >>>>> sergey.puchnin@gmail.com <javascript:;>
> > > >>>>>>>>
> > > >>>>>>>>> wrote:
> > > >>>>>>>>>>>>
> > > >>>>>>>>>>>> Hi !
> > > >>>>>>>>>>>>
> > > >>>>>>>>>>>> As I can see, there is some room for documentation
> > > >>> improvement.
> > > >>>>>>>>>>>> As a sample of documentation, I've prepared a description
> of
> > > >>>>> "CREATE
> > > >>>>>>>>> INDEX" statement.
> > > >>>>>>>>>>>>
> > > >>>>>>>>>>>> What’s your opinion?
> > > >>>>>>>>>>>> What can be improved?
> > > >>>>>>>>>>>> What should be added?
> > > >>>>>>>>>>>>
> > > >>>>>>>>>>>> Thanks a lot!
> > > >>>>>>>>>>>>
> > > >>>>>>>>>>>> ---
> > > >>>>>>>>>>>> Serge
> > > >>>>>>>>>>>
> > > >>>>>>>>>
> > > >>>>>>>>>
> > > >>>>>>>
> > > >>>>>>>
> > > >>>>>
> > > >>>>>
> > > >>>>
> > > >>>
> > > >>
> > > >>
> > >
> > >
> >
>
Re: sql documentation
Posted by Denis Magda <dm...@gridgain.com>.
On Thursday, October 19, 2017, Dmitriy Setrakyan <ds...@apache.org>
wrote:
> Denis,
>
> Awesome work and great contribution!
>
> A minor comment. Does SELECT belong under DML?
Thanks for feedback!
It turned out that yes, SELECT belongs to DML. Personally, I deciphered ‘M’
as ‘modification’ before while in fact it stands for ‘manipulation’.
Some proof links:
https://en.m.wikipedia.org/wiki/Data_manipulation_language
http://www.h2database.com/html/grammar.html
Denis
>
> D.
>
>
> On Thu, Oct 19, 2017 at 6:36 PM, Denis Magda <dmagda@apache.org
> <javascript:;>> wrote:
>
> > Igniters,
> >
> > I’m glad to share that the new SQL doc is ready for proof read:
> > https://apacheignite-sql.readme.io/docs
> >
> > Main sections:
> > - Overview - SQL capabilities outline and getting started guide.
> > - SQL Reference - SQL itself with all the commands and operations.
> > - Architecture - insights on how SQL engine works and some of its
> features.
> > - JDBC
> > - ODBC
> > - Tools and Analytics - tools to work with Ignite as with SQL database.
> > - Java Dev Guide - Java specific features
> > - .NET Dev Guide - .NET specific features
> > - C++ Dev Guide - C++ specific features
> >
> > Note, that all the SQL related pages will be hidden (consider removed) on
> > Java, .NET and C++ readme.io sites in 2.3. All the SQL related
> > capabilities have to be documented on this new specific doc.
> >
> > Here is we’re tracking minor documentation tasks to close before the
> > release:
> > https://issues.apache.org/jira/browse/IGNITE-6685
> >
> > Many thanks to Sergey Puchnin for the help with SQL reference
> > documentation!
> >
> > —
> > Denis
> >
> >
> > > On Sep 14, 2017, at 5:00 AM, Serge Puchnin <sergey.puchnin@gmail.com
> <javascript:;>>
> > wrote:
> > >
> > > Denis,
> > > Thanks a lot for the link.
> > > It's very helpful to split "function part" to more specific like
> > 'string',
> > > 'numeric', etc.
> > >
> > > the main reason to separate "Java Developer" as an independent part
> > because
> > > it's about a mix between Java and SQL code.
> > > It's about classes, methods, annotation, GC, etc.
> > > It doesn't fully belong to the SQL specification but IMHO should be in
> > SQL
> > > category.
> > >
> > > BR,
> > > Serge
> > >
> > > On Wed, 13 Sep 2017 at 22:39, Denis Magda <dmagda@apache.org
> <javascript:;>> wrote:
> > >
> > >> Serge,
> > >>
> > >> I like the proposed format. It reminds me the one chosen by MemSQL
> which
> > >> is crystal clear:
> > >> https://docs.memsql.com/sql-reference/v5.8/sql-reference-overview/
> > >>
> > >> Not 100% sure about “Java Developer Guides” section. Let me
> contemplate
> > a
> > >> bit and propose other solutions.
> > >>
> > >> —
> > >> Denis
> > >>
> > >> On Sep 13, 2017, at 3:41 AM, Serge Puchnin <sergey.puchnin@gmail.com
> <javascript:;>>
> > >> wrote:
> > >>
> > >> I have done some reorganizing for the SQL documentation.
> > >> Thanks a lot for the review and proof read.
> > >>
> > >>
> > >>
> > >> On Wed, 13 Sep 2017 at 01:22, Dmitriy Setrakyan <
> dsetrakyan@apache.org <javascript:;>>
> > >> wrote:
> > >>
> > >>> Thanks Sergey, I think we should add SQL Syntax section on the left.
> > Also,
> > >>> please let us know when we can proof read it. I would like to fix
> some
> > >>> phrasing on the page.
> > >>>
> > >>> On Tue, Sep 12, 2017 at 8:26 AM, Serge Puchnin <
> > sergey.puchnin@gmail.com <javascript:;>>
> > >>> wrote:
> > >>>
> > >>>> I've added a page for SQL language, create index statement and Upper
> > >>>> function as an example for the new format:
> > >>>>
> > >>>> https://apacheignite-sql.readme.io/v2.1/docs/create-index
> > >>>>
> > >>>>
> > >>>>
> > >>>> For me, it'd be OK to add a separate page for each SQL statement.
> > >>>>
> > >>>>
> > >>>> BR,
> > >>>>
> > >>>> Serge
> > >>>>
> > >>>> On Sat, 9 Sep 2017 at 02:19, Denis Magda <dmagda@apache.org
> <javascript:;>> wrote:
> > >>>>
> > >>>>> Please check you inbox.
> > >>>>>
> > >>>>> —
> > >>>>> Denis
> > >>>>>
> > >>>>>> On Sep 8, 2017, at 3:38 PM, Dmitriy Setrakyan <
> > >>> dsetrakyan@apache.org <javascript:;>>
> > >>>>> wrote:
> > >>>>>>
> > >>>>>> Denis,
> > >>>>>>
> > >>>>>> Can you please add me as an admin to that site?
> > >>>>>>
> > >>>>>> D.
> > >>>>>>
> > >>>>>> On Fri, Sep 8, 2017 at 3:23 PM, Denis Magda <dmagda@apache.org
> <javascript:;>>
> > >>> wrote:
> > >>>>>>
> > >>>>>>> Igniter (especially those who are willing to work on the new SQL
> > >>> doc),
> > >>>>>>>
> > >>>>>>> The doc for SQL capabilities has been set up. Copy pasted all the
> > >>> SQL
> > >>>>>>> materials we have there:
> > >>>>>>> https://apacheignite-sql.readme.io/docs <
> https://apacheignite-sql.
> > >>>>>>> readme.io/docs>
> > >>>>>>>
> > >>>>>>> Sergey P., feel free to start reworking the doc according to the
> > >>> new
> > >>>>>>> proposed format. Don’t hesitate removing outdating or misleading
> > >>>>> content.
> > >>>>>>> If you’re uncertain about something just send us a message here.
> > >>>>>>>
> > >>>>>>> Presently the doc is not indexed by searching engines. Let’s
> > >>> finish it
> > >>>>>>> first and announce afterwards.
> > >>>>>>>
> > >>>>>>> —
> > >>>>>>> Denis
> > >>>>>>>
> > >>>>>>>> On Aug 30, 2017, at 5:43 PM, Dmitriy Setrakyan <
> > >>>> dsetrakyan@apache.org <javascript:;>>
> > >>>>>>> wrote:
> > >>>>>>>>
> > >>>>>>>> On Wed, Aug 30, 2017 at 10:04 PM, Denis Magda <
> dmagda@apache.org <javascript:;>>
> > >>>>> wrote:
> > >>>>>>>>
> > >>>>>>>>> Serge,
> > >>>>>>>>>
> > >>>>>>>>> Undoubtedly, I like this format. I’ve created a new
> documentation
> > >>>>> domain
> > >>>>>>>>> for all our SQL capabilities:
> > >>>>>>>>> https://apacheignite-sql.readme.io/docs <
> > >>> https://apacheignite-sql.
> > >>>>>>>>> readme.io/docs>
> > >>>>>>>>>
> > >>>>>>>>> Once I get an open source license for it we can start moving
> the
> > >>>>>>> existing
> > >>>>>>>>> docs and create the new there.
> > >>>>>>>>>
> > >>>>>>>>
> > >>>>>>>> Sounds good. We should make sure that we do not "move" the
> > >>>>> documentation,
> > >>>>>>>> we should "copy" it. Otherwise we will get 404 errors in google.
> > >>>>>>>>
> > >>>>>>>>
> > >>>>>>>>>
> > >>>>>>>>> —
> > >>>>>>>>> Denis
> > >>>>>>>>>
> > >>>>>>>>>> On Aug 30, 2017, at 4:38 AM, Serge Puchnin n <
> > >>>>> sergey.puchnin@gmail.com <javascript:;>
> > >>>>>>>>
> > >>>>>>>>> wrote:
> > >>>>>>>>>>
> > >>>>>>>>>> Sorry for inconvenience!
> > >>>>>>>>>> there is a link for a sample:
> > >>>>>>>>>> https://drive.google.com/open?id=0B-s4Ivq-
> > >>>>>>> lrPobzZ4c2Y1X1ZLcWhGenE4TllVM3
> > >>>>>>>>> VlODhtT2Iw
> > >>>>>>>>>>
> > >>>>>>>>>> Serge
> > >>>>>>>>>>
> > >>>>>>>>>>> On 29 Aug 2017, at 19:30, Denis Magda <dmagda@apache.org
> <javascript:;>>
> > >>> wrote:
> > >>>>>>>>>>>
> > >>>>>>>>>>> Serge,
> > >>>>>>>>>>>
> > >>>>>>>>>>> The attachment is missing. Try to share it via google drive
> or
> > >>>> other
> > >>>>>>>>> storage.
> > >>>>>>>>>>>
> > >>>>>>>>>>> —
> > >>>>>>>>>>> Denis
> > >>>>>>>>>>>
> > >>>>>>>>>>>> On Aug 29, 2017, at 2:38 AM, Serge Puchnin <
> > >>>>> sergey.puchnin@gmail.com <javascript:;>
> > >>>>>>>>
> > >>>>>>>>> wrote:
> > >>>>>>>>>>>>
> > >>>>>>>>>>>> Hi !
> > >>>>>>>>>>>>
> > >>>>>>>>>>>> As I can see, there is some room for documentation
> > >>> improvement.
> > >>>>>>>>>>>> As a sample of documentation, I've prepared a description of
> > >>>>> "CREATE
> > >>>>>>>>> INDEX" statement.
> > >>>>>>>>>>>>
> > >>>>>>>>>>>> What’s your opinion?
> > >>>>>>>>>>>> What can be improved?
> > >>>>>>>>>>>> What should be added?
> > >>>>>>>>>>>>
> > >>>>>>>>>>>> Thanks a lot!
> > >>>>>>>>>>>>
> > >>>>>>>>>>>> ---
> > >>>>>>>>>>>> Serge
> > >>>>>>>>>>>
> > >>>>>>>>>
> > >>>>>>>>>
> > >>>>>>>
> > >>>>>>>
> > >>>>>
> > >>>>>
> > >>>>
> > >>>
> > >>
> > >>
> >
> >
>
Re: sql documentation
Posted by Dmitriy Setrakyan <ds...@apache.org>.
Denis,
Awesome work and great contribution!
A minor comment. Does SELECT belong under DML?
D.
On Thu, Oct 19, 2017 at 6:36 PM, Denis Magda <dm...@apache.org> wrote:
> Igniters,
>
> I’m glad to share that the new SQL doc is ready for proof read:
> https://apacheignite-sql.readme.io/docs
>
> Main sections:
> - Overview - SQL capabilities outline and getting started guide.
> - SQL Reference - SQL itself with all the commands and operations.
> - Architecture - insights on how SQL engine works and some of its features.
> - JDBC
> - ODBC
> - Tools and Analytics - tools to work with Ignite as with SQL database.
> - Java Dev Guide - Java specific features
> - .NET Dev Guide - .NET specific features
> - C++ Dev Guide - C++ specific features
>
> Note, that all the SQL related pages will be hidden (consider removed) on
> Java, .NET and C++ readme.io sites in 2.3. All the SQL related
> capabilities have to be documented on this new specific doc.
>
> Here is we’re tracking minor documentation tasks to close before the
> release:
> https://issues.apache.org/jira/browse/IGNITE-6685
>
> Many thanks to Sergey Puchnin for the help with SQL reference
> documentation!
>
> —
> Denis
>
>
> > On Sep 14, 2017, at 5:00 AM, Serge Puchnin <se...@gmail.com>
> wrote:
> >
> > Denis,
> > Thanks a lot for the link.
> > It's very helpful to split "function part" to more specific like
> 'string',
> > 'numeric', etc.
> >
> > the main reason to separate "Java Developer" as an independent part
> because
> > it's about a mix between Java and SQL code.
> > It's about classes, methods, annotation, GC, etc.
> > It doesn't fully belong to the SQL specification but IMHO should be in
> SQL
> > category.
> >
> > BR,
> > Serge
> >
> > On Wed, 13 Sep 2017 at 22:39, Denis Magda <dm...@apache.org> wrote:
> >
> >> Serge,
> >>
> >> I like the proposed format. It reminds me the one chosen by MemSQL which
> >> is crystal clear:
> >> https://docs.memsql.com/sql-reference/v5.8/sql-reference-overview/
> >>
> >> Not 100% sure about “Java Developer Guides” section. Let me contemplate
> a
> >> bit and propose other solutions.
> >>
> >> —
> >> Denis
> >>
> >> On Sep 13, 2017, at 3:41 AM, Serge Puchnin <se...@gmail.com>
> >> wrote:
> >>
> >> I have done some reorganizing for the SQL documentation.
> >> Thanks a lot for the review and proof read.
> >>
> >>
> >>
> >> On Wed, 13 Sep 2017 at 01:22, Dmitriy Setrakyan <ds...@apache.org>
> >> wrote:
> >>
> >>> Thanks Sergey, I think we should add SQL Syntax section on the left.
> Also,
> >>> please let us know when we can proof read it. I would like to fix some
> >>> phrasing on the page.
> >>>
> >>> On Tue, Sep 12, 2017 at 8:26 AM, Serge Puchnin <
> sergey.puchnin@gmail.com>
> >>> wrote:
> >>>
> >>>> I've added a page for SQL language, create index statement and Upper
> >>>> function as an example for the new format:
> >>>>
> >>>> https://apacheignite-sql.readme.io/v2.1/docs/create-index
> >>>>
> >>>>
> >>>>
> >>>> For me, it'd be OK to add a separate page for each SQL statement.
> >>>>
> >>>>
> >>>> BR,
> >>>>
> >>>> Serge
> >>>>
> >>>> On Sat, 9 Sep 2017 at 02:19, Denis Magda <dm...@apache.org> wrote:
> >>>>
> >>>>> Please check you inbox.
> >>>>>
> >>>>> —
> >>>>> Denis
> >>>>>
> >>>>>> On Sep 8, 2017, at 3:38 PM, Dmitriy Setrakyan <
> >>> dsetrakyan@apache.org>
> >>>>> wrote:
> >>>>>>
> >>>>>> Denis,
> >>>>>>
> >>>>>> Can you please add me as an admin to that site?
> >>>>>>
> >>>>>> D.
> >>>>>>
> >>>>>> On Fri, Sep 8, 2017 at 3:23 PM, Denis Magda <dm...@apache.org>
> >>> wrote:
> >>>>>>
> >>>>>>> Igniter (especially those who are willing to work on the new SQL
> >>> doc),
> >>>>>>>
> >>>>>>> The doc for SQL capabilities has been set up. Copy pasted all the
> >>> SQL
> >>>>>>> materials we have there:
> >>>>>>> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.
> >>>>>>> readme.io/docs>
> >>>>>>>
> >>>>>>> Sergey P., feel free to start reworking the doc according to the
> >>> new
> >>>>>>> proposed format. Don’t hesitate removing outdating or misleading
> >>>>> content.
> >>>>>>> If you’re uncertain about something just send us a message here.
> >>>>>>>
> >>>>>>> Presently the doc is not indexed by searching engines. Let’s
> >>> finish it
> >>>>>>> first and announce afterwards.
> >>>>>>>
> >>>>>>> —
> >>>>>>> Denis
> >>>>>>>
> >>>>>>>> On Aug 30, 2017, at 5:43 PM, Dmitriy Setrakyan <
> >>>> dsetrakyan@apache.org>
> >>>>>>> wrote:
> >>>>>>>>
> >>>>>>>> On Wed, Aug 30, 2017 at 10:04 PM, Denis Magda <dm...@apache.org>
> >>>>> wrote:
> >>>>>>>>
> >>>>>>>>> Serge,
> >>>>>>>>>
> >>>>>>>>> Undoubtedly, I like this format. I’ve created a new documentation
> >>>>> domain
> >>>>>>>>> for all our SQL capabilities:
> >>>>>>>>> https://apacheignite-sql.readme.io/docs <
> >>> https://apacheignite-sql.
> >>>>>>>>> readme.io/docs>
> >>>>>>>>>
> >>>>>>>>> Once I get an open source license for it we can start moving the
> >>>>>>> existing
> >>>>>>>>> docs and create the new there.
> >>>>>>>>>
> >>>>>>>>
> >>>>>>>> Sounds good. We should make sure that we do not "move" the
> >>>>> documentation,
> >>>>>>>> we should "copy" it. Otherwise we will get 404 errors in google.
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>>
> >>>>>>>>> —
> >>>>>>>>> Denis
> >>>>>>>>>
> >>>>>>>>>> On Aug 30, 2017, at 4:38 AM, Serge Puchnin n <
> >>>>> sergey.puchnin@gmail.com
> >>>>>>>>
> >>>>>>>>> wrote:
> >>>>>>>>>>
> >>>>>>>>>> Sorry for inconvenience!
> >>>>>>>>>> there is a link for a sample:
> >>>>>>>>>> https://drive.google.com/open?id=0B-s4Ivq-
> >>>>>>> lrPobzZ4c2Y1X1ZLcWhGenE4TllVM3
> >>>>>>>>> VlODhtT2Iw
> >>>>>>>>>>
> >>>>>>>>>> Serge
> >>>>>>>>>>
> >>>>>>>>>>> On 29 Aug 2017, at 19:30, Denis Magda <dm...@apache.org>
> >>> wrote:
> >>>>>>>>>>>
> >>>>>>>>>>> Serge,
> >>>>>>>>>>>
> >>>>>>>>>>> The attachment is missing. Try to share it via google drive or
> >>>> other
> >>>>>>>>> storage.
> >>>>>>>>>>>
> >>>>>>>>>>> —
> >>>>>>>>>>> Denis
> >>>>>>>>>>>
> >>>>>>>>>>>> On Aug 29, 2017, at 2:38 AM, Serge Puchnin <
> >>>>> sergey.puchnin@gmail.com
> >>>>>>>>
> >>>>>>>>> wrote:
> >>>>>>>>>>>>
> >>>>>>>>>>>> Hi !
> >>>>>>>>>>>>
> >>>>>>>>>>>> As I can see, there is some room for documentation
> >>> improvement.
> >>>>>>>>>>>> As a sample of documentation, I've prepared a description of
> >>>>> "CREATE
> >>>>>>>>> INDEX" statement.
> >>>>>>>>>>>>
> >>>>>>>>>>>> What’s your opinion?
> >>>>>>>>>>>> What can be improved?
> >>>>>>>>>>>> What should be added?
> >>>>>>>>>>>>
> >>>>>>>>>>>> Thanks a lot!
> >>>>>>>>>>>>
> >>>>>>>>>>>> ---
> >>>>>>>>>>>> Serge
> >>>>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>
> >>>>>
> >>>>
> >>>
> >>
> >>
>
>
Re: sql documentation
Posted by Denis Magda <dm...@apache.org>.
Igniters,
I’m glad to share that the new SQL doc is ready for proof read:
https://apacheignite-sql.readme.io/docs
Main sections:
- Overview - SQL capabilities outline and getting started guide.
- SQL Reference - SQL itself with all the commands and operations.
- Architecture - insights on how SQL engine works and some of its features.
- JDBC
- ODBC
- Tools and Analytics - tools to work with Ignite as with SQL database.
- Java Dev Guide - Java specific features
- .NET Dev Guide - .NET specific features
- C++ Dev Guide - C++ specific features
Note, that all the SQL related pages will be hidden (consider removed) on Java, .NET and C++ readme.io sites in 2.3. All the SQL related capabilities have to be documented on this new specific doc.
Here is we’re tracking minor documentation tasks to close before the release:
https://issues.apache.org/jira/browse/IGNITE-6685
Many thanks to Sergey Puchnin for the help with SQL reference documentation!
—
Denis
> On Sep 14, 2017, at 5:00 AM, Serge Puchnin <se...@gmail.com> wrote:
>
> Denis,
> Thanks a lot for the link.
> It's very helpful to split "function part" to more specific like 'string',
> 'numeric', etc.
>
> the main reason to separate "Java Developer" as an independent part because
> it's about a mix between Java and SQL code.
> It's about classes, methods, annotation, GC, etc.
> It doesn't fully belong to the SQL specification but IMHO should be in SQL
> category.
>
> BR,
> Serge
>
> On Wed, 13 Sep 2017 at 22:39, Denis Magda <dm...@apache.org> wrote:
>
>> Serge,
>>
>> I like the proposed format. It reminds me the one chosen by MemSQL which
>> is crystal clear:
>> https://docs.memsql.com/sql-reference/v5.8/sql-reference-overview/
>>
>> Not 100% sure about “Java Developer Guides” section. Let me contemplate a
>> bit and propose other solutions.
>>
>> —
>> Denis
>>
>> On Sep 13, 2017, at 3:41 AM, Serge Puchnin <se...@gmail.com>
>> wrote:
>>
>> I have done some reorganizing for the SQL documentation.
>> Thanks a lot for the review and proof read.
>>
>>
>>
>> On Wed, 13 Sep 2017 at 01:22, Dmitriy Setrakyan <ds...@apache.org>
>> wrote:
>>
>>> Thanks Sergey, I think we should add SQL Syntax section on the left. Also,
>>> please let us know when we can proof read it. I would like to fix some
>>> phrasing on the page.
>>>
>>> On Tue, Sep 12, 2017 at 8:26 AM, Serge Puchnin <se...@gmail.com>
>>> wrote:
>>>
>>>> I've added a page for SQL language, create index statement and Upper
>>>> function as an example for the new format:
>>>>
>>>> https://apacheignite-sql.readme.io/v2.1/docs/create-index
>>>>
>>>>
>>>>
>>>> For me, it'd be OK to add a separate page for each SQL statement.
>>>>
>>>>
>>>> BR,
>>>>
>>>> Serge
>>>>
>>>> On Sat, 9 Sep 2017 at 02:19, Denis Magda <dm...@apache.org> wrote:
>>>>
>>>>> Please check you inbox.
>>>>>
>>>>> —
>>>>> Denis
>>>>>
>>>>>> On Sep 8, 2017, at 3:38 PM, Dmitriy Setrakyan <
>>> dsetrakyan@apache.org>
>>>>> wrote:
>>>>>>
>>>>>> Denis,
>>>>>>
>>>>>> Can you please add me as an admin to that site?
>>>>>>
>>>>>> D.
>>>>>>
>>>>>> On Fri, Sep 8, 2017 at 3:23 PM, Denis Magda <dm...@apache.org>
>>> wrote:
>>>>>>
>>>>>>> Igniter (especially those who are willing to work on the new SQL
>>> doc),
>>>>>>>
>>>>>>> The doc for SQL capabilities has been set up. Copy pasted all the
>>> SQL
>>>>>>> materials we have there:
>>>>>>> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.
>>>>>>> readme.io/docs>
>>>>>>>
>>>>>>> Sergey P., feel free to start reworking the doc according to the
>>> new
>>>>>>> proposed format. Don’t hesitate removing outdating or misleading
>>>>> content.
>>>>>>> If you’re uncertain about something just send us a message here.
>>>>>>>
>>>>>>> Presently the doc is not indexed by searching engines. Let’s
>>> finish it
>>>>>>> first and announce afterwards.
>>>>>>>
>>>>>>> —
>>>>>>> Denis
>>>>>>>
>>>>>>>> On Aug 30, 2017, at 5:43 PM, Dmitriy Setrakyan <
>>>> dsetrakyan@apache.org>
>>>>>>> wrote:
>>>>>>>>
>>>>>>>> On Wed, Aug 30, 2017 at 10:04 PM, Denis Magda <dm...@apache.org>
>>>>> wrote:
>>>>>>>>
>>>>>>>>> Serge,
>>>>>>>>>
>>>>>>>>> Undoubtedly, I like this format. I’ve created a new documentation
>>>>> domain
>>>>>>>>> for all our SQL capabilities:
>>>>>>>>> https://apacheignite-sql.readme.io/docs <
>>> https://apacheignite-sql.
>>>>>>>>> readme.io/docs>
>>>>>>>>>
>>>>>>>>> Once I get an open source license for it we can start moving the
>>>>>>> existing
>>>>>>>>> docs and create the new there.
>>>>>>>>>
>>>>>>>>
>>>>>>>> Sounds good. We should make sure that we do not "move" the
>>>>> documentation,
>>>>>>>> we should "copy" it. Otherwise we will get 404 errors in google.
>>>>>>>>
>>>>>>>>
>>>>>>>>>
>>>>>>>>> —
>>>>>>>>> Denis
>>>>>>>>>
>>>>>>>>>> On Aug 30, 2017, at 4:38 AM, Serge Puchnin n <
>>>>> sergey.puchnin@gmail.com
>>>>>>>>
>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>> Sorry for inconvenience!
>>>>>>>>>> there is a link for a sample:
>>>>>>>>>> https://drive.google.com/open?id=0B-s4Ivq-
>>>>>>> lrPobzZ4c2Y1X1ZLcWhGenE4TllVM3
>>>>>>>>> VlODhtT2Iw
>>>>>>>>>>
>>>>>>>>>> Serge
>>>>>>>>>>
>>>>>>>>>>> On 29 Aug 2017, at 19:30, Denis Magda <dm...@apache.org>
>>> wrote:
>>>>>>>>>>>
>>>>>>>>>>> Serge,
>>>>>>>>>>>
>>>>>>>>>>> The attachment is missing. Try to share it via google drive or
>>>> other
>>>>>>>>> storage.
>>>>>>>>>>>
>>>>>>>>>>> —
>>>>>>>>>>> Denis
>>>>>>>>>>>
>>>>>>>>>>>> On Aug 29, 2017, at 2:38 AM, Serge Puchnin <
>>>>> sergey.puchnin@gmail.com
>>>>>>>>
>>>>>>>>> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>> Hi !
>>>>>>>>>>>>
>>>>>>>>>>>> As I can see, there is some room for documentation
>>> improvement.
>>>>>>>>>>>> As a sample of documentation, I've prepared a description of
>>>>> "CREATE
>>>>>>>>> INDEX" statement.
>>>>>>>>>>>>
>>>>>>>>>>>> What’s your opinion?
>>>>>>>>>>>> What can be improved?
>>>>>>>>>>>> What should be added?
>>>>>>>>>>>>
>>>>>>>>>>>> Thanks a lot!
>>>>>>>>>>>>
>>>>>>>>>>>> ---
>>>>>>>>>>>> Serge
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>>
Re: sql documentation
Posted by Serge Puchnin <se...@gmail.com>.
Denis,
Thanks a lot for the link.
It's very helpful to split "function part" to more specific like 'string',
'numeric', etc.
the main reason to separate "Java Developer" as an independent part because
it's about a mix between Java and SQL code.
It's about classes, methods, annotation, GC, etc.
It doesn't fully belong to the SQL specification but IMHO should be in SQL
category.
BR,
Serge
On Wed, 13 Sep 2017 at 22:39, Denis Magda <dm...@apache.org> wrote:
> Serge,
>
> I like the proposed format. It reminds me the one chosen by MemSQL which
> is crystal clear:
> https://docs.memsql.com/sql-reference/v5.8/sql-reference-overview/
>
> Not 100% sure about “Java Developer Guides” section. Let me contemplate a
> bit and propose other solutions.
>
> —
> Denis
>
> On Sep 13, 2017, at 3:41 AM, Serge Puchnin <se...@gmail.com>
> wrote:
>
> I have done some reorganizing for the SQL documentation.
> Thanks a lot for the review and proof read.
>
>
>
> On Wed, 13 Sep 2017 at 01:22, Dmitriy Setrakyan <ds...@apache.org>
> wrote:
>
>> Thanks Sergey, I think we should add SQL Syntax section on the left. Also,
>> please let us know when we can proof read it. I would like to fix some
>> phrasing on the page.
>>
>> On Tue, Sep 12, 2017 at 8:26 AM, Serge Puchnin <se...@gmail.com>
>> wrote:
>>
>> > I've added a page for SQL language, create index statement and Upper
>> > function as an example for the new format:
>> >
>> > https://apacheignite-sql.readme.io/v2.1/docs/create-index
>> >
>> >
>> >
>> > For me, it'd be OK to add a separate page for each SQL statement.
>> >
>> >
>> > BR,
>> >
>> > Serge
>> >
>> > On Sat, 9 Sep 2017 at 02:19, Denis Magda <dm...@apache.org> wrote:
>> >
>> > > Please check you inbox.
>> > >
>> > > —
>> > > Denis
>> > >
>> > > > On Sep 8, 2017, at 3:38 PM, Dmitriy Setrakyan <
>> dsetrakyan@apache.org>
>> > > wrote:
>> > > >
>> > > > Denis,
>> > > >
>> > > > Can you please add me as an admin to that site?
>> > > >
>> > > > D.
>> > > >
>> > > > On Fri, Sep 8, 2017 at 3:23 PM, Denis Magda <dm...@apache.org>
>> wrote:
>> > > >
>> > > >> Igniter (especially those who are willing to work on the new SQL
>> doc),
>> > > >>
>> > > >> The doc for SQL capabilities has been set up. Copy pasted all the
>> SQL
>> > > >> materials we have there:
>> > > >> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.
>> > > >> readme.io/docs>
>> > > >>
>> > > >> Sergey P., feel free to start reworking the doc according to the
>> new
>> > > >> proposed format. Don’t hesitate removing outdating or misleading
>> > > content.
>> > > >> If you’re uncertain about something just send us a message here.
>> > > >>
>> > > >> Presently the doc is not indexed by searching engines. Let’s
>> finish it
>> > > >> first and announce afterwards.
>> > > >>
>> > > >> —
>> > > >> Denis
>> > > >>
>> > > >>> On Aug 30, 2017, at 5:43 PM, Dmitriy Setrakyan <
>> > dsetrakyan@apache.org>
>> > > >> wrote:
>> > > >>>
>> > > >>> On Wed, Aug 30, 2017 at 10:04 PM, Denis Magda <dm...@apache.org>
>> > > wrote:
>> > > >>>
>> > > >>>> Serge,
>> > > >>>>
>> > > >>>> Undoubtedly, I like this format. I’ve created a new documentation
>> > > domain
>> > > >>>> for all our SQL capabilities:
>> > > >>>> https://apacheignite-sql.readme.io/docs <
>> https://apacheignite-sql.
>> > > >>>> readme.io/docs>
>> > > >>>>
>> > > >>>> Once I get an open source license for it we can start moving the
>> > > >> existing
>> > > >>>> docs and create the new there.
>> > > >>>>
>> > > >>>
>> > > >>> Sounds good. We should make sure that we do not "move" the
>> > > documentation,
>> > > >>> we should "copy" it. Otherwise we will get 404 errors in google.
>> > > >>>
>> > > >>>
>> > > >>>>
>> > > >>>> —
>> > > >>>> Denis
>> > > >>>>
>> > > >>>>> On Aug 30, 2017, at 4:38 AM, Serge Puchnin n <
>> > > sergey.puchnin@gmail.com
>> > > >>>
>> > > >>>> wrote:
>> > > >>>>>
>> > > >>>>> Sorry for inconvenience!
>> > > >>>>> there is a link for a sample:
>> > > >>>>> https://drive.google.com/open?id=0B-s4Ivq-
>> > > >> lrPobzZ4c2Y1X1ZLcWhGenE4TllVM3
>> > > >>>> VlODhtT2Iw
>> > > >>>>>
>> > > >>>>> Serge
>> > > >>>>>
>> > > >>>>>> On 29 Aug 2017, at 19:30, Denis Magda <dm...@apache.org>
>> wrote:
>> > > >>>>>>
>> > > >>>>>> Serge,
>> > > >>>>>>
>> > > >>>>>> The attachment is missing. Try to share it via google drive or
>> > other
>> > > >>>> storage.
>> > > >>>>>>
>> > > >>>>>> —
>> > > >>>>>> Denis
>> > > >>>>>>
>> > > >>>>>>> On Aug 29, 2017, at 2:38 AM, Serge Puchnin <
>> > > sergey.puchnin@gmail.com
>> > > >>>
>> > > >>>> wrote:
>> > > >>>>>>>
>> > > >>>>>>> Hi !
>> > > >>>>>>>
>> > > >>>>>>> As I can see, there is some room for documentation
>> improvement.
>> > > >>>>>>> As a sample of documentation, I've prepared a description of
>> > > "CREATE
>> > > >>>> INDEX" statement.
>> > > >>>>>>>
>> > > >>>>>>> What’s your opinion?
>> > > >>>>>>> What can be improved?
>> > > >>>>>>> What should be added?
>> > > >>>>>>>
>> > > >>>>>>> Thanks a lot!
>> > > >>>>>>>
>> > > >>>>>>> ---
>> > > >>>>>>> Serge
>> > > >>>>>>
>> > > >>>>
>> > > >>>>
>> > > >>
>> > > >>
>> > >
>> > >
>> >
>>
>
>
Re: sql documentation
Posted by Denis Magda <dm...@apache.org>.
Serge,
I like the proposed format. It reminds me the one chosen by MemSQL which is crystal clear:
https://docs.memsql.com/sql-reference/v5.8/sql-reference-overview/
Not 100% sure about “Java Developer Guides” section. Let me contemplate a bit and propose other solutions.
—
Denis
> On Sep 13, 2017, at 3:41 AM, Serge Puchnin <se...@gmail.com> wrote:
>
> I have done some reorganizing for the SQL documentation.
> Thanks a lot for the review and proof read.
>
>
>
> On Wed, 13 Sep 2017 at 01:22, Dmitriy Setrakyan <dsetrakyan@apache.org <ma...@apache.org>> wrote:
> Thanks Sergey, I think we should add SQL Syntax section on the left. Also,
> please let us know when we can proof read it. I would like to fix some
> phrasing on the page.
>
> On Tue, Sep 12, 2017 at 8:26 AM, Serge Puchnin <sergey.puchnin@gmail.com <ma...@gmail.com>>
> wrote:
>
> > I've added a page for SQL language, create index statement and Upper
> > function as an example for the new format:
> >
> > https://apacheignite-sql.readme.io/v2.1/docs/create-index <https://apacheignite-sql.readme.io/v2.1/docs/create-index>
> >
> >
> >
> > For me, it'd be OK to add a separate page for each SQL statement.
> >
> >
> > BR,
> >
> > Serge
> >
> > On Sat, 9 Sep 2017 at 02:19, Denis Magda <dmagda@apache.org <ma...@apache.org>> wrote:
> >
> > > Please check you inbox.
> > >
> > > —
> > > Denis
> > >
> > > > On Sep 8, 2017, at 3:38 PM, Dmitriy Setrakyan <dsetrakyan@apache.org <ma...@apache.org>>
> > > wrote:
> > > >
> > > > Denis,
> > > >
> > > > Can you please add me as an admin to that site?
> > > >
> > > > D.
> > > >
> > > > On Fri, Sep 8, 2017 at 3:23 PM, Denis Magda <dmagda@apache.org <ma...@apache.org>> wrote:
> > > >
> > > >> Igniter (especially those who are willing to work on the new SQL doc),
> > > >>
> > > >> The doc for SQL capabilities has been set up. Copy pasted all the SQL
> > > >> materials we have there:
> > > >> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.readme.io/docs> <https://apacheignite-sql <https://apacheignite-sql/>.
> > > >> readme.io/docs <http://readme.io/docs>>
> > > >>
> > > >> Sergey P., feel free to start reworking the doc according to the new
> > > >> proposed format. Don’t hesitate removing outdating or misleading
> > > content.
> > > >> If you’re uncertain about something just send us a message here.
> > > >>
> > > >> Presently the doc is not indexed by searching engines. Let’s finish it
> > > >> first and announce afterwards.
> > > >>
> > > >> —
> > > >> Denis
> > > >>
> > > >>> On Aug 30, 2017, at 5:43 PM, Dmitriy Setrakyan <
> > dsetrakyan@apache.org <ma...@apache.org>>
> > > >> wrote:
> > > >>>
> > > >>> On Wed, Aug 30, 2017 at 10:04 PM, Denis Magda <dmagda@apache.org <ma...@apache.org>>
> > > wrote:
> > > >>>
> > > >>>> Serge,
> > > >>>>
> > > >>>> Undoubtedly, I like this format. I’ve created a new documentation
> > > domain
> > > >>>> for all our SQL capabilities:
> > > >>>> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.readme.io/docs> <https://apacheignite-sql <https://apacheignite-sql/>.
> > > >>>> readme.io/docs <http://readme.io/docs>>
> > > >>>>
> > > >>>> Once I get an open source license for it we can start moving the
> > > >> existing
> > > >>>> docs and create the new there.
> > > >>>>
> > > >>>
> > > >>> Sounds good. We should make sure that we do not "move" the
> > > documentation,
> > > >>> we should "copy" it. Otherwise we will get 404 errors in google.
> > > >>>
> > > >>>
> > > >>>>
> > > >>>> —
> > > >>>> Denis
> > > >>>>
> > > >>>>> On Aug 30, 2017, at 4:38 AM, Serge Puchnin n <
> > > sergey.puchnin@gmail.com <ma...@gmail.com>
> > > >>>
> > > >>>> wrote:
> > > >>>>>
> > > >>>>> Sorry for inconvenience!
> > > >>>>> there is a link for a sample:
> > > >>>>> https://drive.google.com/open?id=0B-s4Ivq- <https://drive.google.com/open?id=0B-s4Ivq->
> > > >> lrPobzZ4c2Y1X1ZLcWhGenE4TllVM3
> > > >>>> VlODhtT2Iw
> > > >>>>>
> > > >>>>> Serge
> > > >>>>>
> > > >>>>>> On 29 Aug 2017, at 19:30, Denis Magda <dmagda@apache.org <ma...@apache.org>> wrote:
> > > >>>>>>
> > > >>>>>> Serge,
> > > >>>>>>
> > > >>>>>> The attachment is missing. Try to share it via google drive or
> > other
> > > >>>> storage.
> > > >>>>>>
> > > >>>>>> —
> > > >>>>>> Denis
> > > >>>>>>
> > > >>>>>>> On Aug 29, 2017, at 2:38 AM, Serge Puchnin <
> > > sergey.puchnin@gmail.com <ma...@gmail.com>
> > > >>>
> > > >>>> wrote:
> > > >>>>>>>
> > > >>>>>>> Hi !
> > > >>>>>>>
> > > >>>>>>> As I can see, there is some room for documentation improvement.
> > > >>>>>>> As a sample of documentation, I've prepared a description of
> > > "CREATE
> > > >>>> INDEX" statement.
> > > >>>>>>>
> > > >>>>>>> What’s your opinion?
> > > >>>>>>> What can be improved?
> > > >>>>>>> What should be added?
> > > >>>>>>>
> > > >>>>>>> Thanks a lot!
> > > >>>>>>>
> > > >>>>>>> ---
> > > >>>>>>> Serge
> > > >>>>>>
> > > >>>>
> > > >>>>
> > > >>
> > > >>
> > >
> > >
> >
Re: sql documentation
Posted by Serge Puchnin <se...@gmail.com>.
I have done some reorganizing for the SQL documentation.
Thanks a lot for the review and proof read.
On Wed, 13 Sep 2017 at 01:22, Dmitriy Setrakyan <ds...@apache.org>
wrote:
> Thanks Sergey, I think we should add SQL Syntax section on the left. Also,
> please let us know when we can proof read it. I would like to fix some
> phrasing on the page.
>
> On Tue, Sep 12, 2017 at 8:26 AM, Serge Puchnin <se...@gmail.com>
> wrote:
>
> > I've added a page for SQL language, create index statement and Upper
> > function as an example for the new format:
> >
> > https://apacheignite-sql.readme.io/v2.1/docs/create-index
> >
> >
> >
> > For me, it'd be OK to add a separate page for each SQL statement.
> >
> >
> > BR,
> >
> > Serge
> >
> > On Sat, 9 Sep 2017 at 02:19, Denis Magda <dm...@apache.org> wrote:
> >
> > > Please check you inbox.
> > >
> > > —
> > > Denis
> > >
> > > > On Sep 8, 2017, at 3:38 PM, Dmitriy Setrakyan <dsetrakyan@apache.org
> >
> > > wrote:
> > > >
> > > > Denis,
> > > >
> > > > Can you please add me as an admin to that site?
> > > >
> > > > D.
> > > >
> > > > On Fri, Sep 8, 2017 at 3:23 PM, Denis Magda <dm...@apache.org>
> wrote:
> > > >
> > > >> Igniter (especially those who are willing to work on the new SQL
> doc),
> > > >>
> > > >> The doc for SQL capabilities has been set up. Copy pasted all the
> SQL
> > > >> materials we have there:
> > > >> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.
> > > >> readme.io/docs>
> > > >>
> > > >> Sergey P., feel free to start reworking the doc according to the new
> > > >> proposed format. Don’t hesitate removing outdating or misleading
> > > content.
> > > >> If you’re uncertain about something just send us a message here.
> > > >>
> > > >> Presently the doc is not indexed by searching engines. Let’s finish
> it
> > > >> first and announce afterwards.
> > > >>
> > > >> —
> > > >> Denis
> > > >>
> > > >>> On Aug 30, 2017, at 5:43 PM, Dmitriy Setrakyan <
> > dsetrakyan@apache.org>
> > > >> wrote:
> > > >>>
> > > >>> On Wed, Aug 30, 2017 at 10:04 PM, Denis Magda <dm...@apache.org>
> > > wrote:
> > > >>>
> > > >>>> Serge,
> > > >>>>
> > > >>>> Undoubtedly, I like this format. I’ve created a new documentation
> > > domain
> > > >>>> for all our SQL capabilities:
> > > >>>> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql
> .
> > > >>>> readme.io/docs>
> > > >>>>
> > > >>>> Once I get an open source license for it we can start moving the
> > > >> existing
> > > >>>> docs and create the new there.
> > > >>>>
> > > >>>
> > > >>> Sounds good. We should make sure that we do not "move" the
> > > documentation,
> > > >>> we should "copy" it. Otherwise we will get 404 errors in google.
> > > >>>
> > > >>>
> > > >>>>
> > > >>>> —
> > > >>>> Denis
> > > >>>>
> > > >>>>> On Aug 30, 2017, at 4:38 AM, Serge Puchnin n <
> > > sergey.puchnin@gmail.com
> > > >>>
> > > >>>> wrote:
> > > >>>>>
> > > >>>>> Sorry for inconvenience!
> > > >>>>> there is a link for a sample:
> > > >>>>> https://drive.google.com/open?id=0B-s4Ivq-
> > > >> lrPobzZ4c2Y1X1ZLcWhGenE4TllVM3
> > > >>>> VlODhtT2Iw
> > > >>>>>
> > > >>>>> Serge
> > > >>>>>
> > > >>>>>> On 29 Aug 2017, at 19:30, Denis Magda <dm...@apache.org>
> wrote:
> > > >>>>>>
> > > >>>>>> Serge,
> > > >>>>>>
> > > >>>>>> The attachment is missing. Try to share it via google drive or
> > other
> > > >>>> storage.
> > > >>>>>>
> > > >>>>>> —
> > > >>>>>> Denis
> > > >>>>>>
> > > >>>>>>> On Aug 29, 2017, at 2:38 AM, Serge Puchnin <
> > > sergey.puchnin@gmail.com
> > > >>>
> > > >>>> wrote:
> > > >>>>>>>
> > > >>>>>>> Hi !
> > > >>>>>>>
> > > >>>>>>> As I can see, there is some room for documentation improvement.
> > > >>>>>>> As a sample of documentation, I've prepared a description of
> > > "CREATE
> > > >>>> INDEX" statement.
> > > >>>>>>>
> > > >>>>>>> What’s your opinion?
> > > >>>>>>> What can be improved?
> > > >>>>>>> What should be added?
> > > >>>>>>>
> > > >>>>>>> Thanks a lot!
> > > >>>>>>>
> > > >>>>>>> ---
> > > >>>>>>> Serge
> > > >>>>>>
> > > >>>>
> > > >>>>
> > > >>
> > > >>
> > >
> > >
> >
>
Re: sql documentation
Posted by Dmitriy Setrakyan <ds...@apache.org>.
Thanks Sergey, I think we should add SQL Syntax section on the left. Also,
please let us know when we can proof read it. I would like to fix some
phrasing on the page.
On Tue, Sep 12, 2017 at 8:26 AM, Serge Puchnin <se...@gmail.com>
wrote:
> I've added a page for SQL language, create index statement and Upper
> function as an example for the new format:
>
> https://apacheignite-sql.readme.io/v2.1/docs/create-index
>
>
>
> For me, it'd be OK to add a separate page for each SQL statement.
>
>
> BR,
>
> Serge
>
> On Sat, 9 Sep 2017 at 02:19, Denis Magda <dm...@apache.org> wrote:
>
> > Please check you inbox.
> >
> > —
> > Denis
> >
> > > On Sep 8, 2017, at 3:38 PM, Dmitriy Setrakyan <ds...@apache.org>
> > wrote:
> > >
> > > Denis,
> > >
> > > Can you please add me as an admin to that site?
> > >
> > > D.
> > >
> > > On Fri, Sep 8, 2017 at 3:23 PM, Denis Magda <dm...@apache.org> wrote:
> > >
> > >> Igniter (especially those who are willing to work on the new SQL doc),
> > >>
> > >> The doc for SQL capabilities has been set up. Copy pasted all the SQL
> > >> materials we have there:
> > >> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.
> > >> readme.io/docs>
> > >>
> > >> Sergey P., feel free to start reworking the doc according to the new
> > >> proposed format. Don’t hesitate removing outdating or misleading
> > content.
> > >> If you’re uncertain about something just send us a message here.
> > >>
> > >> Presently the doc is not indexed by searching engines. Let’s finish it
> > >> first and announce afterwards.
> > >>
> > >> —
> > >> Denis
> > >>
> > >>> On Aug 30, 2017, at 5:43 PM, Dmitriy Setrakyan <
> dsetrakyan@apache.org>
> > >> wrote:
> > >>>
> > >>> On Wed, Aug 30, 2017 at 10:04 PM, Denis Magda <dm...@apache.org>
> > wrote:
> > >>>
> > >>>> Serge,
> > >>>>
> > >>>> Undoubtedly, I like this format. I’ve created a new documentation
> > domain
> > >>>> for all our SQL capabilities:
> > >>>> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.
> > >>>> readme.io/docs>
> > >>>>
> > >>>> Once I get an open source license for it we can start moving the
> > >> existing
> > >>>> docs and create the new there.
> > >>>>
> > >>>
> > >>> Sounds good. We should make sure that we do not "move" the
> > documentation,
> > >>> we should "copy" it. Otherwise we will get 404 errors in google.
> > >>>
> > >>>
> > >>>>
> > >>>> —
> > >>>> Denis
> > >>>>
> > >>>>> On Aug 30, 2017, at 4:38 AM, Serge Puchnin n <
> > sergey.puchnin@gmail.com
> > >>>
> > >>>> wrote:
> > >>>>>
> > >>>>> Sorry for inconvenience!
> > >>>>> there is a link for a sample:
> > >>>>> https://drive.google.com/open?id=0B-s4Ivq-
> > >> lrPobzZ4c2Y1X1ZLcWhGenE4TllVM3
> > >>>> VlODhtT2Iw
> > >>>>>
> > >>>>> Serge
> > >>>>>
> > >>>>>> On 29 Aug 2017, at 19:30, Denis Magda <dm...@apache.org> wrote:
> > >>>>>>
> > >>>>>> Serge,
> > >>>>>>
> > >>>>>> The attachment is missing. Try to share it via google drive or
> other
> > >>>> storage.
> > >>>>>>
> > >>>>>> —
> > >>>>>> Denis
> > >>>>>>
> > >>>>>>> On Aug 29, 2017, at 2:38 AM, Serge Puchnin <
> > sergey.puchnin@gmail.com
> > >>>
> > >>>> wrote:
> > >>>>>>>
> > >>>>>>> Hi !
> > >>>>>>>
> > >>>>>>> As I can see, there is some room for documentation improvement.
> > >>>>>>> As a sample of documentation, I've prepared a description of
> > "CREATE
> > >>>> INDEX" statement.
> > >>>>>>>
> > >>>>>>> What’s your opinion?
> > >>>>>>> What can be improved?
> > >>>>>>> What should be added?
> > >>>>>>>
> > >>>>>>> Thanks a lot!
> > >>>>>>>
> > >>>>>>> ---
> > >>>>>>> Serge
> > >>>>>>
> > >>>>
> > >>>>
> > >>
> > >>
> >
> >
>
Re: sql documentation
Posted by Serge Puchnin <se...@gmail.com>.
I've added a page for SQL language, create index statement and Upper
function as an example for the new format:
https://apacheignite-sql.readme.io/v2.1/docs/create-index
For me, it'd be OK to add a separate page for each SQL statement.
BR,
Serge
On Sat, 9 Sep 2017 at 02:19, Denis Magda <dm...@apache.org> wrote:
> Please check you inbox.
>
> —
> Denis
>
> > On Sep 8, 2017, at 3:38 PM, Dmitriy Setrakyan <ds...@apache.org>
> wrote:
> >
> > Denis,
> >
> > Can you please add me as an admin to that site?
> >
> > D.
> >
> > On Fri, Sep 8, 2017 at 3:23 PM, Denis Magda <dm...@apache.org> wrote:
> >
> >> Igniter (especially those who are willing to work on the new SQL doc),
> >>
> >> The doc for SQL capabilities has been set up. Copy pasted all the SQL
> >> materials we have there:
> >> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.
> >> readme.io/docs>
> >>
> >> Sergey P., feel free to start reworking the doc according to the new
> >> proposed format. Don’t hesitate removing outdating or misleading
> content.
> >> If you’re uncertain about something just send us a message here.
> >>
> >> Presently the doc is not indexed by searching engines. Let’s finish it
> >> first and announce afterwards.
> >>
> >> —
> >> Denis
> >>
> >>> On Aug 30, 2017, at 5:43 PM, Dmitriy Setrakyan <ds...@apache.org>
> >> wrote:
> >>>
> >>> On Wed, Aug 30, 2017 at 10:04 PM, Denis Magda <dm...@apache.org>
> wrote:
> >>>
> >>>> Serge,
> >>>>
> >>>> Undoubtedly, I like this format. I’ve created a new documentation
> domain
> >>>> for all our SQL capabilities:
> >>>> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.
> >>>> readme.io/docs>
> >>>>
> >>>> Once I get an open source license for it we can start moving the
> >> existing
> >>>> docs and create the new there.
> >>>>
> >>>
> >>> Sounds good. We should make sure that we do not "move" the
> documentation,
> >>> we should "copy" it. Otherwise we will get 404 errors in google.
> >>>
> >>>
> >>>>
> >>>> —
> >>>> Denis
> >>>>
> >>>>> On Aug 30, 2017, at 4:38 AM, Serge Puchnin n <
> sergey.puchnin@gmail.com
> >>>
> >>>> wrote:
> >>>>>
> >>>>> Sorry for inconvenience!
> >>>>> there is a link for a sample:
> >>>>> https://drive.google.com/open?id=0B-s4Ivq-
> >> lrPobzZ4c2Y1X1ZLcWhGenE4TllVM3
> >>>> VlODhtT2Iw
> >>>>>
> >>>>> Serge
> >>>>>
> >>>>>> On 29 Aug 2017, at 19:30, Denis Magda <dm...@apache.org> wrote:
> >>>>>>
> >>>>>> Serge,
> >>>>>>
> >>>>>> The attachment is missing. Try to share it via google drive or other
> >>>> storage.
> >>>>>>
> >>>>>> —
> >>>>>> Denis
> >>>>>>
> >>>>>>> On Aug 29, 2017, at 2:38 AM, Serge Puchnin <
> sergey.puchnin@gmail.com
> >>>
> >>>> wrote:
> >>>>>>>
> >>>>>>> Hi !
> >>>>>>>
> >>>>>>> As I can see, there is some room for documentation improvement.
> >>>>>>> As a sample of documentation, I've prepared a description of
> "CREATE
> >>>> INDEX" statement.
> >>>>>>>
> >>>>>>> What’s your opinion?
> >>>>>>> What can be improved?
> >>>>>>> What should be added?
> >>>>>>>
> >>>>>>> Thanks a lot!
> >>>>>>>
> >>>>>>> ---
> >>>>>>> Serge
> >>>>>>
> >>>>
> >>>>
> >>
> >>
>
>
Re: sql documentation
Posted by Denis Magda <dm...@apache.org>.
Please check you inbox.
—
Denis
> On Sep 8, 2017, at 3:38 PM, Dmitriy Setrakyan <ds...@apache.org> wrote:
>
> Denis,
>
> Can you please add me as an admin to that site?
>
> D.
>
> On Fri, Sep 8, 2017 at 3:23 PM, Denis Magda <dm...@apache.org> wrote:
>
>> Igniter (especially those who are willing to work on the new SQL doc),
>>
>> The doc for SQL capabilities has been set up. Copy pasted all the SQL
>> materials we have there:
>> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.
>> readme.io/docs>
>>
>> Sergey P., feel free to start reworking the doc according to the new
>> proposed format. Don’t hesitate removing outdating or misleading content.
>> If you’re uncertain about something just send us a message here.
>>
>> Presently the doc is not indexed by searching engines. Let’s finish it
>> first and announce afterwards.
>>
>> —
>> Denis
>>
>>> On Aug 30, 2017, at 5:43 PM, Dmitriy Setrakyan <ds...@apache.org>
>> wrote:
>>>
>>> On Wed, Aug 30, 2017 at 10:04 PM, Denis Magda <dm...@apache.org> wrote:
>>>
>>>> Serge,
>>>>
>>>> Undoubtedly, I like this format. I’ve created a new documentation domain
>>>> for all our SQL capabilities:
>>>> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.
>>>> readme.io/docs>
>>>>
>>>> Once I get an open source license for it we can start moving the
>> existing
>>>> docs and create the new there.
>>>>
>>>
>>> Sounds good. We should make sure that we do not "move" the documentation,
>>> we should "copy" it. Otherwise we will get 404 errors in google.
>>>
>>>
>>>>
>>>> —
>>>> Denis
>>>>
>>>>> On Aug 30, 2017, at 4:38 AM, Serge Puchnin n <sergey.puchnin@gmail.com
>>>
>>>> wrote:
>>>>>
>>>>> Sorry for inconvenience!
>>>>> there is a link for a sample:
>>>>> https://drive.google.com/open?id=0B-s4Ivq-
>> lrPobzZ4c2Y1X1ZLcWhGenE4TllVM3
>>>> VlODhtT2Iw
>>>>>
>>>>> Serge
>>>>>
>>>>>> On 29 Aug 2017, at 19:30, Denis Magda <dm...@apache.org> wrote:
>>>>>>
>>>>>> Serge,
>>>>>>
>>>>>> The attachment is missing. Try to share it via google drive or other
>>>> storage.
>>>>>>
>>>>>> —
>>>>>> Denis
>>>>>>
>>>>>>> On Aug 29, 2017, at 2:38 AM, Serge Puchnin <sergey.puchnin@gmail.com
>>>
>>>> wrote:
>>>>>>>
>>>>>>> Hi !
>>>>>>>
>>>>>>> As I can see, there is some room for documentation improvement.
>>>>>>> As a sample of documentation, I've prepared a description of "CREATE
>>>> INDEX" statement.
>>>>>>>
>>>>>>> What’s your opinion?
>>>>>>> What can be improved?
>>>>>>> What should be added?
>>>>>>>
>>>>>>> Thanks a lot!
>>>>>>>
>>>>>>> ---
>>>>>>> Serge
>>>>>>
>>>>
>>>>
>>
>>
Re: sql documentation
Posted by Dmitriy Setrakyan <ds...@apache.org>.
Denis,
Can you please add me as an admin to that site?
D.
On Fri, Sep 8, 2017 at 3:23 PM, Denis Magda <dm...@apache.org> wrote:
> Igniter (especially those who are willing to work on the new SQL doc),
>
> The doc for SQL capabilities has been set up. Copy pasted all the SQL
> materials we have there:
> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.
> readme.io/docs>
>
> Sergey P., feel free to start reworking the doc according to the new
> proposed format. Don’t hesitate removing outdating or misleading content.
> If you’re uncertain about something just send us a message here.
>
> Presently the doc is not indexed by searching engines. Let’s finish it
> first and announce afterwards.
>
> —
> Denis
>
> > On Aug 30, 2017, at 5:43 PM, Dmitriy Setrakyan <ds...@apache.org>
> wrote:
> >
> > On Wed, Aug 30, 2017 at 10:04 PM, Denis Magda <dm...@apache.org> wrote:
> >
> >> Serge,
> >>
> >> Undoubtedly, I like this format. I’ve created a new documentation domain
> >> for all our SQL capabilities:
> >> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.
> >> readme.io/docs>
> >>
> >> Once I get an open source license for it we can start moving the
> existing
> >> docs and create the new there.
> >>
> >
> > Sounds good. We should make sure that we do not "move" the documentation,
> > we should "copy" it. Otherwise we will get 404 errors in google.
> >
> >
> >>
> >> —
> >> Denis
> >>
> >>> On Aug 30, 2017, at 4:38 AM, Serge Puchnin n <sergey.puchnin@gmail.com
> >
> >> wrote:
> >>>
> >>> Sorry for inconvenience!
> >>> there is a link for a sample:
> >>> https://drive.google.com/open?id=0B-s4Ivq-
> lrPobzZ4c2Y1X1ZLcWhGenE4TllVM3
> >> VlODhtT2Iw
> >>>
> >>> Serge
> >>>
> >>>> On 29 Aug 2017, at 19:30, Denis Magda <dm...@apache.org> wrote:
> >>>>
> >>>> Serge,
> >>>>
> >>>> The attachment is missing. Try to share it via google drive or other
> >> storage.
> >>>>
> >>>> —
> >>>> Denis
> >>>>
> >>>>> On Aug 29, 2017, at 2:38 AM, Serge Puchnin <sergey.puchnin@gmail.com
> >
> >> wrote:
> >>>>>
> >>>>> Hi !
> >>>>>
> >>>>> As I can see, there is some room for documentation improvement.
> >>>>> As a sample of documentation, I've prepared a description of "CREATE
> >> INDEX" statement.
> >>>>>
> >>>>> What’s your opinion?
> >>>>> What can be improved?
> >>>>> What should be added?
> >>>>>
> >>>>> Thanks a lot!
> >>>>>
> >>>>> ---
> >>>>> Serge
> >>>>
> >>
> >>
>
>
Re: sql documentation
Posted by Denis Magda <dm...@apache.org>.
Igniter (especially those who are willing to work on the new SQL doc),
The doc for SQL capabilities has been set up. Copy pasted all the SQL materials we have there:
https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.readme.io/docs>
Sergey P., feel free to start reworking the doc according to the new proposed format. Don’t hesitate removing outdating or misleading content. If you’re uncertain about something just send us a message here.
Presently the doc is not indexed by searching engines. Let’s finish it first and announce afterwards.
—
Denis
> On Aug 30, 2017, at 5:43 PM, Dmitriy Setrakyan <ds...@apache.org> wrote:
>
> On Wed, Aug 30, 2017 at 10:04 PM, Denis Magda <dm...@apache.org> wrote:
>
>> Serge,
>>
>> Undoubtedly, I like this format. I’ve created a new documentation domain
>> for all our SQL capabilities:
>> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.
>> readme.io/docs>
>>
>> Once I get an open source license for it we can start moving the existing
>> docs and create the new there.
>>
>
> Sounds good. We should make sure that we do not "move" the documentation,
> we should "copy" it. Otherwise we will get 404 errors in google.
>
>
>>
>> —
>> Denis
>>
>>> On Aug 30, 2017, at 4:38 AM, Serge Puchnin n <se...@gmail.com>
>> wrote:
>>>
>>> Sorry for inconvenience!
>>> there is a link for a sample:
>>> https://drive.google.com/open?id=0B-s4Ivq-lrPobzZ4c2Y1X1ZLcWhGenE4TllVM3
>> VlODhtT2Iw
>>>
>>> Serge
>>>
>>>> On 29 Aug 2017, at 19:30, Denis Magda <dm...@apache.org> wrote:
>>>>
>>>> Serge,
>>>>
>>>> The attachment is missing. Try to share it via google drive or other
>> storage.
>>>>
>>>> —
>>>> Denis
>>>>
>>>>> On Aug 29, 2017, at 2:38 AM, Serge Puchnin <se...@gmail.com>
>> wrote:
>>>>>
>>>>> Hi !
>>>>>
>>>>> As I can see, there is some room for documentation improvement.
>>>>> As a sample of documentation, I've prepared a description of "CREATE
>> INDEX" statement.
>>>>>
>>>>> What’s your opinion?
>>>>> What can be improved?
>>>>> What should be added?
>>>>>
>>>>> Thanks a lot!
>>>>>
>>>>> ---
>>>>> Serge
>>>>
>>
>>
Re: sql documentation
Posted by Dmitriy Setrakyan <ds...@apache.org>.
On Wed, Aug 30, 2017 at 10:04 PM, Denis Magda <dm...@apache.org> wrote:
> Serge,
>
> Undoubtedly, I like this format. I’ve created a new documentation domain
> for all our SQL capabilities:
> https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.
> readme.io/docs>
>
> Once I get an open source license for it we can start moving the existing
> docs and create the new there.
>
Sounds good. We should make sure that we do not "move" the documentation,
we should "copy" it. Otherwise we will get 404 errors in google.
>
> —
> Denis
>
> > On Aug 30, 2017, at 4:38 AM, Serge Puchnin n <se...@gmail.com>
> wrote:
> >
> > Sorry for inconvenience!
> > there is a link for a sample:
> > https://drive.google.com/open?id=0B-s4Ivq-lrPobzZ4c2Y1X1ZLcWhGenE4TllVM3
> VlODhtT2Iw
> >
> > Serge
> >
> >> On 29 Aug 2017, at 19:30, Denis Magda <dm...@apache.org> wrote:
> >>
> >> Serge,
> >>
> >> The attachment is missing. Try to share it via google drive or other
> storage.
> >>
> >> —
> >> Denis
> >>
> >>> On Aug 29, 2017, at 2:38 AM, Serge Puchnin <se...@gmail.com>
> wrote:
> >>>
> >>> Hi !
> >>>
> >>> As I can see, there is some room for documentation improvement.
> >>> As a sample of documentation, I've prepared a description of "CREATE
> INDEX" statement.
> >>>
> >>> What’s your opinion?
> >>> What can be improved?
> >>> What should be added?
> >>>
> >>> Thanks a lot!
> >>>
> >>> ---
> >>> Serge
> >>
>
>
Re: sql documentation
Posted by Denis Magda <dm...@apache.org>.
Serge,
Undoubtedly, I like this format. I’ve created a new documentation domain for all our SQL capabilities:
https://apacheignite-sql.readme.io/docs <https://apacheignite-sql.readme.io/docs>
Once I get an open source license for it we can start moving the existing docs and create the new there.
—
Denis
> On Aug 30, 2017, at 4:38 AM, Serge Puchnin n <se...@gmail.com> wrote:
>
> Sorry for inconvenience!
> there is a link for a sample:
> https://drive.google.com/open?id=0B-s4Ivq-lrPobzZ4c2Y1X1ZLcWhGenE4TllVM3VlODhtT2Iw
>
> Serge
>
>> On 29 Aug 2017, at 19:30, Denis Magda <dm...@apache.org> wrote:
>>
>> Serge,
>>
>> The attachment is missing. Try to share it via google drive or other storage.
>>
>> —
>> Denis
>>
>>> On Aug 29, 2017, at 2:38 AM, Serge Puchnin <se...@gmail.com> wrote:
>>>
>>> Hi !
>>>
>>> As I can see, there is some room for documentation improvement.
>>> As a sample of documentation, I've prepared a description of "CREATE INDEX" statement.
>>>
>>> What’s your opinion?
>>> What can be improved?
>>> What should be added?
>>>
>>> Thanks a lot!
>>>
>>> ---
>>> Serge
>>
Re: sql documentation
Posted by Serge Puchnin n <se...@gmail.com>.
Sorry for inconvenience!
there is a link for a sample:
https://drive.google.com/open?id=0B-s4Ivq-lrPobzZ4c2Y1X1ZLcWhGenE4TllVM3VlODhtT2Iw
Serge
> On 29 Aug 2017, at 19:30, Denis Magda <dm...@apache.org> wrote:
>
> Serge,
>
> The attachment is missing. Try to share it via google drive or other storage.
>
> —
> Denis
>
>> On Aug 29, 2017, at 2:38 AM, Serge Puchnin <se...@gmail.com> wrote:
>>
>> Hi !
>>
>> As I can see, there is some room for documentation improvement.
>> As a sample of documentation, I've prepared a description of "CREATE INDEX" statement.
>>
>> What’s your opinion?
>> What can be improved?
>> What should be added?
>>
>> Thanks a lot!
>>
>> ---
>> Serge
>
Re: sql documentation
Posted by Denis Magda <dm...@apache.org>.
Serge,
The attachment is missing. Try to share it via google drive or other storage.
—
Denis
> On Aug 29, 2017, at 2:38 AM, Serge Puchnin <se...@gmail.com> wrote:
>
> Hi !
>
> As I can see, there is some room for documentation improvement.
> As a sample of documentation, I've prepared a description of "CREATE INDEX" statement.
>
> What’s your opinion?
> What can be improved?
> What should be added?
>
> Thanks a lot!
>
> ---
> Serge