Mailing-List: contact dev-help@ignite.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@ignite.apache.org
MIME-Version: 1.0
In-Reply-To: <2094EBF7-236C-446F-A595-122D164F1B68@apache.org>
References: <CAObTb87XAp52pZuGexjNRgFBDdBwzGSi1FL86-zvUpfqE6aCRQ@mail.gmail.com>
 <C4D9F70A-159F-4C65-9892-621966752C6B@apache.org> <CAA-MoLhveaqfqKQ2=jYYX35yUAi-iKA3DmYDtu-WemTEGJn-0A@mail.gmail.com>
 <E8D04089-D2FA-4404-8628-3BFED7F3B1D8@apache.org> <19BBC834-B22D-4CBF-B6B4-8A1405227959@apache.org>
 <CAE8DB43-4EE4-44A2-B287-30087EB1CC55@apache.org> <CAObTb84mbLgYwfriG=8Lx-_CnFOkmeVKoxDTRsAo_+QKAYBkFw@mail.gmail.com>
 <CA+0=VoUn1OCmo46+JT9Wa0-4SDAzhpECOd10ka5jT=bSd1cYSg@mail.gmail.com>
 <CAMbfdjbK_GHv61rU=OwhE13oA76zuVm1WjFov5Ng1odC5VQS_g@mail.gmail.com>
 <0CAB33E3-1E6C-48A2-9131-7D9BE3E1FDAB@apache.org> <CAMbfdjZ5unNPkjOFpDG0Y+UAM1nKaaxn11Y9DzbC5Y3a8s=vaw@mail.gmail.com>
 <CAGt6o8kn9bHXFk54jsmfKVPLj49Y24bh+x_-Q+n1V1--Pa_GvQ@mail.gmail.com>
 <3ad7522f-60df-4ea6-bafd-c0e336ad702b@apache.org> <CAOKDqC_n-VT-z0aT5TEpW8JKAVGH9cbdAsRiPnN0mipypb8H_w@mail.gmail.com>
 <8C8201C8-3815-4183-A499-7EBD9ED2B408@apache.org> <FE28CCBC-5D01-43C4-B11D-2958D34666DB@apache.org>
 <FD8AA910-4AB0-4056-B23E-2CEF03346E33@apache.org> <CA+0=VoWn3wUNgfDpQARyaRH8gqiv1HGD-Ha7D0gGYny+axvz=g@mail.gmail.com>
 <CAGt6o8kL_w0mXEG+Gs56tLpjfxR7JNCyWNODJUNYfHf3pK8dPQ@mail.gmail.com>
 <CA+0=VoVxwso2wXHVD2=4nh+mQkActzBaq4ZwBtx79U7-Wr5fvw@mail.gmail.com>
 <CAK0qHnqLzP-_WTsbiQyxScDTqzu-DU-qeLPRvtTyo9HkPftZXQ@mail.gmail.com>
 <CAJdBuJiZjxTVTQkgfoqD3Og4+FgkXRLBaCgaMdzua8a+-7y8vw@mail.gmail.com>
 <CAOKDqC8anRyR5Ci0_CpOigMUf9aX6_b-6ZJG-4HZKJm5=GBDFQ@mail.gmail.com>
 <CAK0qHnrpsczXKkUXf12gf8WgAk2QVJTkqTAtmnkeRshyrXnuxQ@mail.gmail.com>
 <CAJdBuJjA0PtCuztGr+GZni2PS7iA2jX5C_KfDWeJOCpyu6ZPNQ@mail.gmail.com> <2094EBF7-236C-446F-A595-122D164F1B68@apache.org>
From: Oleg Ostanin <oostanin@gridgain.com>
Date: Tue, 17 Oct 2017 14:33:29 +0300
Message-ID: <CAJdBuJh5wRr6F0dKf0_VoL4UD=kBHfNYLnG=yaP5Azm5pNF4Ow@mail.gmail.com>
Subject: Re: Adding sqlline tool to Apache Ignite project
To: dev@ignite.apache.org
Content-Type: multipart/alternative; boundary="089e082f7e8c050b01055bbc7ed2"
archived-at: Tue, 17 Oct 2017 11:33:39 -0000

--089e082f7e8c050b01055bbc7ed2
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

New example build with sqlline:

https://ci.ignite.apache.org/viewLog.html?buildId=3D894407&tab=3Dartifacts&=
buildTypeId=3DIgniteRelease_XxxFromMirrorIgniteRelease3PrepareVote#!1rrb2,1=
esn4zrslm4po,-h8h0hn9vvvxp


On Wed, Oct 11, 2017 at 1:00 AM, Denis Magda <dmagda@apache.org> wrote:

> Oleg,
>
> Looks good to me. Please consider the notes left in the ticket. I want us
> to prepare a script for Windows, review the language for help notice and
> errors, put together documentation. Prachi will be able to help with the
> editing and documentation.
>
> =E2=80=94
> Denis
>
> > On Oct 9, 2017, at 10:13 AM, Oleg Ostanin <oostanin@gridgain.com> wrote=
:
> >
> > New build with fixed argument parsing:
> > https://ci.ignite.apache.org/viewLog.html?buildId=3D882282&
> tab=3Dartifacts&buildTypeId=3DIgniteRelease_XxxFromMirrorIgniteRelease3Pr=
e
> pareVote#!1rrb2,1esn4zrslm4po,-h8h0hn9vvvxp
> >
> > On Mon, Oct 9, 2017 at 5:38 PM, Denis Magda <dmagda@gridgain.com> wrote=
:
> >
> >> I think it=E2=80=99s a must have for the ticket resolution.
> >>
> >> Denis
> >>
> >> On Monday, October 9, 2017, Anton Vinogradov <avinogradov@gridgain.com=
>
> >> wrote:
> >>
> >>> Any plans to have ignitesql.bat?
> >>>
> >>> On Mon, Oct 9, 2017 at 5:29 PM, Oleg Ostanin <oostanin@gridgain.com
> >>> <javascript:;>> wrote:
> >>>
> >>>> Another build with sqlline included:
> >>>> https://ci.ignite.apache.org/viewLog.html?buildId=3D881120&
> >>>> tab=3Dartifacts&buildTypeId=3DIgniteRelease_
> XxxFromMirrorIgniteRelease3Pre
> >>>> pareVote#!1rrb2,-wpvx2aopzexz,1esn4zrslm4po,-h8h0hn9vvvxp
> >>>>
> >>>> On Sun, Oct 8, 2017 at 5:11 PM, Denis Magda <dmagda@gridgain.com
> >>> <javascript:;>> wrote:
> >>>>
> >>>>> No more doubts on my side. +1 for Vladimir=E2=80=99s suggestion.
> >>>>>
> >>>>> Denis
> >>>>>
> >>>>> On Saturday, October 7, 2017, Dmitriy Setrakyan <
> >> dsetrakyan@apache.org
> >>> <javascript:;>>
> >>>>> wrote:
> >>>>>
> >>>>>> I now tend to agree with Vladimir. We should always require that
> >> some
> >>>>>> address is specified. The help menu should clearly state how to
> >>> connect
> >>>>> to
> >>>>>> a localhost.
> >>>>>>
> >>>>>> D.
> >>>>>>
> >>>>>> On Sat, Oct 7, 2017 at 12:44 AM, Vladimir Ozerov <
> >>> vozerov@gridgain.com <javascript:;>
> >>>>>> <javascript:;>>
> >>>>>> wrote:
> >>>>>>
> >>>>>>> Denis,
> >>>>>>>
> >>>>>>> Default Ignite configuration uses multicast, this is why you do
> >> not
> >>>>> need
> >>>>>> to
> >>>>>>> change anything. Ignite node is always both a server (listens)
> >> and
> >>> a
> >>>>>> client
> >>>>>>> (connects).
> >>>>>>>
> >>>>>>> This will not work for ignitesql, as this is a client. And in
> >> real
> >>>>>>> deployments it will connect to remote nodes, not local. So the
> >>>> earlier
> >>>>> we
> >>>>>>> explain user how to do this, the better. This is why it should
> >> not
> >>>> work
> >>>>>> out
> >>>>>>> of the box connecting to 127.0.0.1. No magic for users please.
> >>>>>>>
> >>>>>>> This is what user will see (draft):
> >>>>>>>> ./ignitesql.sh
> >>>>>>>> Please specify the host: ignitesql.sh [host]; type --help for
> >>> more
> >>>>>>> information.
> >>>>>>>> ./ignitesql.sh 192.168.12.55
> >>>>>>>> Connected successfully.
> >>>>>>>
> >>>>>>> Again, specifying parameters manually is not poor UX. This is
> >>>> excellent
> >>>>>> UX,
> >>>>>>> as user learns on his own how to connect to a node in 1 minute.
> >>> Most
> >>>>>>> command line tools work this way.
> >>>>>>>
> >>>>>>> =D1=81=D0=B1, 7 =D0=BE=D0=BA=D1=82. 2017 =D0=B3. =D0=B2 7:12, Dmi=
triy Setrakyan <
> >>> dsetrakyan@apache.org <javascript:;>
> >>>>>> <javascript:;>>:
> >>>>>>>
> >>>>>>>> How does the binding happen? Can we bind to everything, like we
> >>> do
> >>>> in
> >>>>>>>> Ignite?
> >>>>>>>>
> >>>>>>>> On Fri, Oct 6, 2017 at 2:51 PM, Denis Magda <dmagda@apache.org
> >>> <javascript:;>
> >>>>>> <javascript:;>> wrote:
> >>>>>>>>
> >>>>>>>>> Thought over 127.0.0.1 as a default host once again. The bad
> >>>> thing
> >>>>>>> about
> >>>>>>>>> it is that the user gets a lengthy exception stack trace if
> >>>> Ignite
> >>>>>> is
> >>>>>>>> not
> >>>>>>>>> running locally and not a small error message.
> >>>>>>>>>
> >>>>>>>>> What are the other opinions on this? Do we want to follow
> >>>>> Vladimir=E2=80=99s
> >>>>>>>>> suggestion forcing to set the host name/IP (port is optional)
> >>> for
> >>>>> the
> >>>>>>>> sake
> >>>>>>>>> of usability or leaver 127.0.0.1 as default?
> >>>>>>>>>
> >>>>>>>>> =E2=80=94
> >>>>>>>>> Denis
> >>>>>>>>>
> >>>>>>>>>> On Oct 6, 2017, at 12:21 PM, Denis Magda <
> >> dmagda@apache.org
> >>> <javascript:;>
> >>>>>> <javascript:;>> wrote:
> >>>>>>>>>>
> >>>>>>>>>>> But, we need to support =E2=80=9Chelp=E2=80=9D (-h, -help) ar=
gument
> >> listing
> >>>> all
> >>>>>> the
> >>>>>>>>> parameters accepted by the tools.
> >>>>>>>>>>
> >>>>>>>>>> Meant accepted by the ignitesql script only such as host
> >>> name.
> >>>>>>>>>>
> >>>>>>>>>> =E2=80=94
> >>>>>>>>>> Denis
> >>>>>>>>>>
> >>>>>>>>>>> On Oct 6, 2017, at 12:20 PM, Denis Magda <
> >> dmagda@apache.org
> >>> <javascript:;>
> >>>>>> <javascript:;>> wrote:
> >>>>>>>>>>>
> >>>>>>>>>>> Really nice, could click through the getting started [1]
> >> in
> >>> a
> >>>>>>> minute!
> >>>>>>>>>>>
> >>>>>>>>>>> +1 to rename the script to =E2=80=9Cignitesql=E2=80=9D. Vladi=
mir=E2=80=99s point
> >>> makes
> >>>>>> total
> >>>>>>>>> sense.
> >>>>>>>>>>>
> >>>>>>>>>>> However, tend to disagree that the host has to be
> >> requested
> >>>> all
> >>>>>> the
> >>>>>>>>> times. We never request a configuration or host name for
> >>>> ignite.sh,
> >>>>>>> visor
> >>>>>>>>> or web agent scripts. I would follow this approach that=E2=80=
=99s
> >>>> excellent
> >>>>>> for
> >>>>>>>> dev
> >>>>>>>>> time.
> >>>>>>>>>>>
> >>>>>>>>>>> But, we need to support =E2=80=9Chelp=E2=80=9D (-h, -help) ar=
gument
> >> listing
> >>>> all
> >>>>>> the
> >>>>>>>>> parameters accepted by the tools.
> >>>>>>>>>>>
> >>>>>>>>>>> Please consider our feedback and share the next build once
> >>>> it=E2=80=99s
> >>>>>>> ready.
> >>>>>>>>>>>
> >>>>>>>>>>>
> >>>>>>>>>>> [1] https://apacheignite-sql.readme.io/v2.1/docs/getting-
> >>>>> started
> >>>>>> <
> >>>>>>>>> https://apacheignite-sql.readme.io/v2.1/docs/getting-started
> >>>
> >>>>>>>>>>>
> >>>>>>>>>>> =E2=80=94
> >>>>>>>>>>> Denis
> >>>>>>>>>>>
> >>>>>>>>>>>> On Oct 6, 2017, at 9:04 AM, Anton Vinogradov <
> >>>>>>>> avinogradov@gridgain.com <javascript:;> <javascript:;>>
> >>>>>>>>> wrote:
> >>>>>>>>>>>>
> >>>>>>>>>>>> How about sqlconsole.sh or sqlcmd.sh ?
> >>>>>>>>>>>>
> >>>>>>>>>>>> On Fri, Oct 6, 2017 at 6:04 PM, <dsetrakyan@apache.org
> >>> <javascript:;>
> >>>>>> <javascript:;>> wrote:
> >>>>>>>>>>>>
> >>>>>>>>>>>>> I like ignitesql.
> >>>>>>>>>>>>>
> >>>>>>>>>>>>> =E2=81=A3D.=E2=80=8B
> >>>>>>>>>>>>>
> >>>>>>>>>>>>> On Oct 6, 2017, 4:49 PM, at 4:49 PM, Vladimir Ozerov <
> >>>>>>>>> vozerov@gridgain.com <javascript:;> <javascript:;>>
> >>>>>>>>>>>>> wrote:
> >>>>>>>>>>>>>> Denis,
> >>>>>>>>>>>>>>
> >>>>>>>>>>>>>> Setting default host to 127.0.0.1 is bad idea, because
> >> it
> >>>>> mean
> >>>>>>> that
> >>>>>>>>> in
> >>>>>>>>>>>>>> practice users would have to change the script always.
> >>>>> Instead,
> >>>>>>> we
> >>>>>>>>>>>>>> should
> >>>>>>>>>>>>>> accept host name as argument. This is perfectly fine
> >> from
> >>>>>>> usability
> >>>>>>>>>>>>>> perspective, most tools work this way (i.e. throw error
> >>>> when
> >>>>>>>> started
> >>>>>>>>>>>>>> without arguments).
> >>>>>>>>>>>>>>
> >>>>>>>>>>>>>> Also IMO "ignitedb" is misleading name. Users would
> >> like
> >>>>> think
> >>>>>>> that
> >>>>>>>>> it
> >>>>>>>>>>>>>> is a
> >>>>>>>>>>>>>> kind of script to start database, rather than to
> >> connect
> >>> to
> >>>>> it.
> >>>>>>> We
> >>>>>>>>>>>>>> should
> >>>>>>>>>>>>>> think on other names. E.g. "ignitesql".
> >>>>>>>>>>>>>>
> >>>>>>>>>>>>>> On Fri, Oct 6, 2017 at 5:23 PM, Sergey Kozlov <
> >>>>>>>> skozlov@gridgain.com <javascript:;> <javascript:;>>
> >>>>>>>>>>>>>> wrote:
> >>>>>>>>>>>>>>
> >>>>>>>>>>>>>>> Denis
> >>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>> The link below has included sqlline. Please take a
> >> look:
> >>>>>>>>>>>>>>> https://ci.ignite.apache.org/
> >>> viewLog.html?buildId=3D875441&
> >>>>>>>>>>>>>>> buildTypeId=3DIgniteRelease_
> >>> XxxFromMirrorIgniteRelease3Pre
> >>>>>>>>>>>>>>> pareVote&tab=3Dartifacts#!1rrb2,-wpvx2aopzexz
> >>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>> On Thu, Oct 5, 2017 at 7:48 PM, Denis Magda <
> >>>>>> dmagda@apache.org <javascript:;> <javascript:;>>
> >>>>>>>>>>>>>> wrote:
> >>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>> Here is the original ticket [1]. Ilya, closed the one
> >>>>> created
> >>>>>>> by
> >>>>>>>>>>>>>> you as a
> >>>>>>>>>>>>>>>> duplicate.
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>> In addition to the tool=E2=80=99s jar inclusion in Ignit=
e=E2=80=99s
> >>>> binary
> >>>>>>>> releases
> >>>>>>>>>>>>>> let=E2=80=99s
> >>>>>>>>>>>>>>>> create a shell script to simplify the connectivity
> >>> phase:
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>> - name the script as ignitedb.sh for Unix and
> >>>> ignitedb.bat
> >>>>>> for
> >>>>>>>>>>>>>>> Windows.
> >>>>>>>>>>>>>>>> -
> >>>>>>>>>>>>>>>> - the script uses the following connection string by
> >>>>> default:
> >>>>>>>>>>>>>> .sqlline
> >>>>>>>>>>>>>>>> -d org.apache.ignite.IgniteJdbcThinDriver
> >> --color=3Dtrue
> >>>>>>>>>>>>>> --verbose=3Dtrue
> >>>>>>>>>>>>>>>> --showWarnings=3Dtrue --showNestedErrs=3Dtrue -u
> >>> jdbc:ignite:
> >>>>>>>>>>>>>>>> thin://127.0.0.1/
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>> - make up parameters list to adjust Ignite specific
> >>> part
> >>>> of
> >>>>>> the
> >>>>>>>>>>>>>>>> connection string: Ignite IP and port, streaming
> >> mode,
> >>>> etc.
> >>>>>> The
> >>>>>>>>>>>>>> full
> >>>>>>>>>>>>>>> list
> >>>>>>>>>>>>>>>> of supported parameters is here:
> >> https://apacheignite-
> >>>>>>>>>>>>>>>> sql.readme.io/docs/jdbc-driver#jdbc-thin-driver
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>> <https://apacheignite-sql.readme.io/docs/jdbc-driver#
> >>>>>>>>> jdbc-thin-driver
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>> [1] https://issues.apache.org/
> >> jira/browse/IGNITE-5608
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>> =E2=80=94
> >>>>>>>>>>>>>>>> Denis
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>> On Oct 5, 2017, at 9:02 AM, Sergey Kozlov <
> >>>>>>> skozlov@gridgain.com <javascript:;> <javascript:;>>
> >>>>>>>>>>>>>> wrote:
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>> Dmitriy, Denis
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>> We're in progress to add sqlline in upcoming 2.3
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>> On Thu, Oct 5, 2017 at 5:30 PM, Dmitriy Setrakyan
> >>>>>>>>>>>>>> <dsetrakyan@apache.org <javascript:;> <javascript:;>
> >>>>>>>>>>>>>>>>> wrote:
> >>>>>>>>>>>>>>>> Would be nice to get it in 2.3. This is critical
> >>>>>> functionality
> >>>>>>>> for
> >>>>>>>>>>>>>> our
> >>>>>>>>>>>>>>>> users and 2.4 seems too far to give anyone comfort.
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>> On Thu, Oct 5, 2017 at 11:33 AM, Ilya Suntsov
> >>>>>>>>>>>>>> <isuntsov@gridgain.com <javascript:;> <javascript:;>>
> >>>>>>>>>>>>>>>> wrote:
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>> Guys,
> >>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>> I've created the ticket for 2.4 release:
> >>>>>>>>>>>>>>>>> https://issues.apache.org/jira/browse/IGNITE-6561
> >>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>> 2017-08-30 22:21 GMT+03:00 Julian Hyde <
> >>>> jhyde@apache.org <javascript:;>
> >>>>>> <javascript:;>>:
> >>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>> Denis,
> >>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>> I=E2=80=99m glad you=E2=80=99re thinking of using SQLL=
ine. Under
> >> the
> >>>> BSD
> >>>>>>>>>>>>>> license, you
> >>>>>>>>>>>>>>>>>> don=E2=80=99t need my permission to distribute, but I =
grant
> >>>> that
> >>>>>>>>>>>>>> permission.
> >>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>> Drill, Phoenix and Calcite already distribute
> >>> SQLLine,
> >>>> so
> >>>>>>>>>>>>>> Ignite is
> >>>>>>>>>>>>>>> in
> >>>>>>>>>>>>>>>>>> good company.
> >>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>> If you need extensions, please discuss on the dev
> >>> list,
> >>>>> or
> >>>>>>> open
> >>>>>>>>>>>>>> a
> >>>>>>>>>>>>>>>> GitHub
> >>>>>>>>>>>>>>>>>> case or pull request. SQLLine operates in the usual
> >>> way
> >>>>>> for a
> >>>>>>>>>>>>>> GitHub
> >>>>>>>>>>>>>>>>>> project. It=E2=80=99s unlikely that you=E2=80=99ll nee=
d
> >>> Ignite-specific
> >>>>>>>>>>>>>> extensions =E2=80=94
> >>>>>>>>>>>>>>>>>> SQLLine just exposes what comes through the JDBC
> >>>> driver =E2=80=94
> >>>>>> but
> >>>>>>>>>>>>>> we can
> >>>>>>>>>>>>>>>>>> discuss if the need arises. The Hive project forked
> >>>>> SQLLine
> >>>>>>>>>>>>>> into its
> >>>>>>>>>>>>>>>> own
> >>>>>>>>>>>>>>>>>> Beeline module and I=E2=80=99d like to avoid a repeat =
of
> >>> that.
> >>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>> Julian
> >>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>> On Aug 29, 2017, at 6:35 PM, Denis Magda <
> >>>>>> dmagda@apache.org <javascript:;> <javascript:;>
> >>>>>>>>
> >>>>>>>>>>>>>>> wrote:
> >>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>> Igniters,
> >>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>> Let me introduce Julian Hyde [1], creator of
> >> SQLLine
> >>>>> tool
> >>>>>>> and
> >>>>>>>>>>>>>> our
> >>>>>>>>>>>>>>>>> Apache
> >>>>>>>>>>>>>>>>>> mate,
> >>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>> Julian,
> >>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>> Please grant that Apache Ignite community a
> >>> permission
> >>>>> to
> >>>>>>>>>>>>>> include
> >>>>>>>>>>>>>>>>>> SQLLine [2] it in every Ignite deliverable (source,
> >>>>>> binary).
> >>>>>>>>>>>>>> It=E2=80=99s
> >>>>>>>>>>>>>>>> planned
> >>>>>>>>>>>>>>>>>> to suggest the tool as a default command line SQL
> >>>> utility
> >>>>>> for
> >>>>>>>>>>>>>> Ignite
> >>>>>>>>>>>>>>>>>> clusters. SQLLite and Ignite usage will also be
> >>>>> documented
> >>>>>> on
> >>>>>>>>>>>>>>> Ignite=E2=80=99s
> >>>>>>>>>>>>>>>>>> technical documentation.
> >>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>> [1] https://people.apache.org/~jhyde/ <
> >>>>>>>>>>>>>>> https://people.apache.org/~jh
> >>>>>>>>>>>>>>>>> yde/
> >>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>> [2] https://github.com/julianhyde/sqlline
> >>>>>>>>>>>>>> <https://github.com/
> >>>>>>>>>>>>>>>>>> julianhyde/sqlline>
> >>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>> =E2=80=94
> >>>>>>>>>>>>>>>>>>> Denis
> >>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>> On Aug 25, 2017, at 9:17 AM, Denis Magda <
> >>>>>>> dmagda@apache.org <javascript:;> <javascript:;>
> >>>>>>>>>>>>>>>> <mailto:
> >>>>>>>>>>>>>>>>>> dmagda@apache.org <javascript:;> <javascript:;>>>
> >>> wrote:
> >>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>> Hi Ilya,
> >>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>> Thanks for the clarification! Referring to the
> >> page
> >>>>>> shared
> >>>>>>>>>>>>>> by you
> >>>>>>>>>>>>>>>> [1]
> >>>>>>>>>>>>>>>>>> if we need to get author=E2=80=99s consent in a writte=
n
> >> form:
> >>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>> A permissive license similar to the BSD 2-Clause
> >>>>> License,
> >>>>>>>>>>>>>> but
> >>>>>>>>>>>>>>> with a
> >>>>>>>>>>>>>>>>>> 3rd clause that prohibits others from using the
> >> name
> >>> of
> >>>>> the
> >>>>>>>>>>>>>> project
> >>>>>>>>>>>>>>> or
> >>>>>>>>>>>>>>>>> its
> >>>>>>>>>>>>>>>>>> contributors to promote derived products without
> >>>> written
> >>>>>>>>>>>>>> consent.
> >>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>> [1]
> >>>>>>>>>>>>>> https://github.com/julianhyde/
> >>> sqlline/blob/master/LICENSE
> >>>> <
> >>>>>>>>>>>>>>>>>> https://github.com/julianhyde/
> >>>>> sqlline/blob/master/LICENSE>
> >>>>>> <
> >>>>>>>>>>>>>>>>>> https://github.com/julianhyde/
> >>>>> sqlline/blob/master/LICENSE
> >>>>>> <
> >>>>>>>>>>>>>>>>>> https://github.com/julianhyde/
> >>>>> sqlline/blob/master/LICENSE
> >>>>>>>>
> >>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>> I=E2=80=99ll reach out the author requesting the per=
mit.
> >>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>> =E2=80=94
> >>>>>>>>>>>>>>>>>>>> Denis
> >>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>> On Aug 25, 2017, at 9:12 AM, Ilya Kasnacheev <
> >>>>>>>>>>>>>>>>>> ilya.kasnacheev@gmail.com <javascript:;>
> >>> <javascript:;> <mailto:
> >>>>>> ilya.kasnacheev@gmail.com <javascript:;> <javascript:;>
> >>>>>>>>>
> >>>>>>>>>>>>>> wrote:
> >>>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>> Hi Denis,
> >>>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>> There are two kinds of BSD license, 3-clause and
> >>>>>> 4-clause.
> >>>>>>>>>>>>>> The
> >>>>>>>>>>>>>>>>>> difference
> >>>>>>>>>>>>>>>>>>>>> between them is advertising clause:
> >>>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>> "3. All advertising materials mentioning
> >> features
> >>> or
> >>>>> use
> >>>>>>> of
> >>>>>>>>>>>>>> this
> >>>>>>>>>>>>>>>>>> software
> >>>>>>>>>>>>>>>>>>>>> must display the following acknowledgement: This
> >>>>> product
> >>>>>>>>>>>>>> includes
> >>>>>>>>>>>>>>>>>> software
> >>>>>>>>>>>>>>>>>>>>> developed by the University of California,
> >>> Berkeley
> >>>>> and
> >>>>>>> its
> >>>>>>>>>>>>>>>>>> contributors."
> >>>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>> which is causing problems with other licenses
> >> and
> >>>>> which
> >>>>>>>>>>>>>> sqlline's
> >>>>>>>>>>>>>>>>>> license
> >>>>>>>>>>>>>>>>>>>>> doesn't contain:
> >>>>>>>>>>>>>>>>>>>>> https://github.com/julianhyde/
> >>>>>> sqlline/blob/master/LICENSE
> >>>>>>> <
> >>>>>>>>>>>>>>>>>> https://github.com/julianhyde/
> >>>>> sqlline/blob/master/LICENSE>
> >>>>>>>>>>>>>>>>>>>>> So it should be all good for inclusion.
> >>>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>> --
> >>>>>>>>>>>>>>>>>>>>> Ilya Kasnacheev.
> >>>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>> 2017-08-25 18:48 GMT+03:00 Denis Magda <
> >>>>>> dmagda@apache.org <javascript:;> <javascript:;>
> >>>>>>>> :
> >>>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>>> Hi Ilya,
> >>>>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>>> It will be a useful addition to Ignite. I would
> >>>>> include
> >>>>>>>>>>>>>> the tool
> >>>>>>>>>>>>>>>> in
> >>>>>>>>>>>>>>>>>> one of
> >>>>>>>>>>>>>>>>>>>>>> the nearest releases. It=E2=80=99s license is BSD-=
3
> >> which
> >>>> is
> >>>>>>>>>>>>>> compatible
> >>>>>>>>>>>>>>>> with
> >>>>>>>>>>>>>>>>>> ours.
> >>>>>>>>>>>>>>>>>>>>>> However, there is a note on ASF side saying
> >> that
> >>>> BSD
> >>>>>>>>>>>>>> licenses
> >>>>>>>>>>>>>>> can
> >>>>>>>>>>>>>>>> be
> >>>>>>>>>>>>>>>>>>>>>> included without advertising clause [1]. What
> >>> does
> >>>> it
> >>>>>>> mean
> >>>>>>>>>>>>>> for
> >>>>>>>>>>>>>>> us?
> >>>>>>>>>>>>>>>>>> Can we
> >>>>>>>>>>>>>>>>>>>>>> document the tool and mention on our site?
> >>>>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>>> [1] https://www.apache.org/legal/
> >>>>>>> resolved.html#category-a
> >>>>>>>>>>>>>> <
> >>>>>>>>>>>>>>>>>>>>>> https://www.apache.org/legal/
> >>>>> resolved.html#category-a>
> >>>>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>>> =E2=80=94
> >>>>>>>>>>>>>>>>>>>>>> Denis
> >>>>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>>>> On Aug 25, 2017, at 8:32 AM, Ilya Suntsov <
> >>>>>>>>>>>>>>> isuntsov@gridgain.com <javascript:;> <javascript:;>
> >>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>> wrote:
> >>>>>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>>>> Hi Igniters,
> >>>>>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>>>> I've found one command line tool that can be
> >>> used
> >>>>> for
> >>>>>>>>>>>>>> execute
> >>>>>>>>>>>>>>>>> queries
> >>>>>>>>>>>>>>>>>>>>>>> (DDL/DML) with data from Apache Ignite grid
> >> via
> >>>>>>>>>>>>>>>>>>>>>>> *org.apache.ignite.IgniteJdbcThinDriver*.
> >>>>>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>>>> Here you can find overview of internal
> >> commands
> >>> of
> >>>>>> this
> >>>>>>>>>>>>>> tool:
> >>>>>>>>>>>>>>>>>>>>>>> https://cwiki.apache.org/
> >>>> confluence/display/IGNITE/
> >>>>>>>>>>>>>>>>>> Overview+sqlline+tool
> >>>>>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>>>> The most problems with sqlline relate with
> >> some
> >>>>> issues
> >>>>>>>>>>>>>> from our
> >>>>>>>>>>>>>>>>> side
> >>>>>>>>>>>>>>>>>> or
> >>>>>>>>>>>>>>>>>>>>>>> some unsupported features.
> >>>>>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>>>> Would be nice to add tool like this (sqlline
> >> or
> >>>>>>> something
> >>>>>>>>>>>>>> else)
> >>>>>>>>>>>>>>>> in
> >>>>>>>>>>>>>>>>>> our
> >>>>>>>>>>>>>>>>>>>>>>> project.
> >>>>>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>>>> Have you any objections or other thoughts?
> >>>>>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>>>> --
> >>>>>>>>>>>>>>>>>>>>>>> Ilya Suntsov
> >>>>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>> --
> >>>>>>>>>>>>>>>>> Ilya Suntsov
> >>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>> --
> >>>>>>>>>>>>>>>> Sergey Kozlov
> >>>>>>>>>>>>>>>> GridGain Systems
> >>>>>>>>>>>>>>>> www.gridgain.com
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>> --
> >>>>>>>>>>>>>>> Sergey Kozlov
> >>>>>>>>>>>>>>> GridGain Systems
> >>>>>>>>>>>>>>> www.gridgain.com
> >>>>>>>>>>>>>>>
> >>>>>>>>>>>>>
> >>>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>
> >>>>>>>
> >>>>>>
> >>>>>
> >>>>
> >>>
> >>
>
>

--089e082f7e8c050b01055bbc7ed2--