Here is the original ticket [1]. Ilya, closed the one created by you as a duplicate.
In addition to the tool’s jar inclusion in Ignite’s binary releases let’s 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=true --verbose=true --showWarnings=true --showNestedErrs=true -u jdbc:ignite:thin://127.0.0.1/ <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 — Denis > On Oct 5, 2017, at 9:02 AM, Sergey Kozlov <skoz...@gridgain.com> 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 <dsetrak...@apache.org> > 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 <isunt...@gridgain.com> 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 <jh...@apache.org>: > > > > > Denis, > > > > > > I’m glad you’re thinking of using SQLLine. Under the BSD license, you > > > don’t 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’s unlikely that you’ll need Ignite-specific extensions — > > > SQLLine just exposes what comes through the JDBC driver — but we can > > > discuss if the need arises. The Hive project forked SQLLine into its own > > > Beeline module and I’d like to avoid a repeat of that. > > > > > > Julian > > > > > > > On Aug 29, 2017, at 6:35 PM, Denis Magda <dma...@apache.org> 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’s 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’s > > > 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> > > > > > > > > — > > > > Denis > > > > > > > >> On Aug 25, 2017, at 9:17 AM, Denis Magda <dma...@apache.org <mailto: > > > dma...@apache.org>> wrote: > > > >> > > > >> Hi Ilya, > > > >> > > > >> Thanks for the clarification! Referring to the page shared by you [1] > > > if we need to get author’s consent in a written 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’ll reach out the author requesting the permit. > > > >> > > > >> — > > > >> Denis > > > >> > > > >>> On Aug 25, 2017, at 9:12 AM, Ilya Kasnacheev < > > > ilya.kasnach...@gmail.com <mailto:ilya.kasnach...@gmail.com>> 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 <dma...@apache.org>: > > > >>> > > > >>>> Hi Ilya, > > > >>>> > > > >>>> It will be a useful addition to Ignite. I would include the tool in > > > one of > > > >>>> the nearest releases. It’s 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> > > > >>>> > > > >>>> — > > > >>>> Denis > > > >>>> > > > >>>>> On Aug 25, 2017, at 8:32 AM, Ilya Suntsov <isunt...@gridgain.com> > > > 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
