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: <F0A7CFE2-5925-4D99-AB34-3F888EDE74A5@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> <CAJdBuJh5wRr6F0dKf0_VoL4UD=kBHfNYLnG=yaP5Azm5pNF4Ow@mail.gmail.com>
 <F0A7CFE2-5925-4D99-AB34-3F888EDE74A5@apache.org>
From: Prachi Garg <pgarg@gridgain.com>
Date: Wed, 18 Oct 2017 16:26:15 -0700
Message-ID: <CAABS=BPpktXvX+RvtoBDoamisFKvRFcwCBHhNx34H9SPONinjQ@mail.gmail.com>
Subject: Re: Adding sqlline tool to Apache Ignite project
To: dev@ignite.apache.org
Content-Type: multipart/alternative; boundary="001a113b1bbcba2258055bda92e5"
archived-at: Wed, 18 Oct 2017 23:27:02 -0000

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

Here is the link for SQLLine documentation -
https://apacheignite-sql.readme.io/v2.1/docs/sqlline

-P

On Tue, Oct 17, 2017 at 11:54 AM, Denis Magda <dmagda@apache.org> wrote:

> Looks good to me. Prachi will help us documenting the tool usage:
> https://issues.apache.org/jira/browse/IGNITE-6656 <
> https://issues.apache.org/jira/browse/IGNITE-6656>
>
> However, I can=E2=80=99t conceive how to see a table structure (columns a=
nd their
> types, indexes with names and types) using SQLLine. I=E2=80=99ve tried !m=
etadata
> with a variety of parameters but no luck. As for !indexes and !tables
> commands they just print out table names and secondary indexes omitting
> columns, indexes types and *primary indexes*. Considering that Ignite
> doesn=E2=80=99t support standard *describe* command I assumed SQLLine wou=
ld help us
> out. But how do I do this with SQLLine?
>
> =E2=80=94
> Denis
>
> > On Oct 17, 2017, at 4:33 AM, Oleg Ostanin <oostanin@gridgain.com> wrote=
:
> >
> > New example build with sqlline:
> >
> > https://ci.ignite.apache.org/viewLog.html?buildId=3D894407&
> tab=3Dartifacts&buildTypeId=3DIgniteRelease_XxxFromMirrorIgniteRelease3Pr=
e
> pareVote#!1rrb2,1esn4zrslm4po,-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 a=
nd
> >> errors, put together documentation. Prachi will be able to help with t=
he
> >> 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_XxxFromMirrorIgniteRelease=
3Pre
> >> 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, D=
mitriy Setrakyan <
> >>>>> dsetrakyan@apache.org <javascript:;>
> >>>>>>>> <javascript:;>>:
> >>>>>>>>>
> >>>>>>>>>> How does the binding happen? Can we bind to everything, like w=
e
> >>>>> 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) =
argument
> >>>> 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. Vla=
dimir=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) =
argument
> >>>> 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 Ign=
ite=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 SQ=
LLine. 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 n=
eed
> >>>>> 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 repea=
t 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 writ=
ten
> >>>> 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 p=
ermit.
> >>>>>>>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>>>>>>>> =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 BS=
D-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
> >>>>>>>>>>>>>>>>>
> >>>>>>>>>>>>>>>
> >>>>>>>>>>>>>
> >>>>>>>>>>>>
> >>>>>>>>>>>
> >>>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>>
> >>>>>>>>
> >>>>>>>
> >>>>>>
> >>>>>
> >>>>
> >>
> >>
>
>

--001a113b1bbcba2258055bda92e5--