Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 4E8A7200D15 for ; Thu, 5 Oct 2017 18:02:22 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 4D3571609E1; Thu, 5 Oct 2017 16:02:22 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 68F101609DA for ; Thu, 5 Oct 2017 18:02:21 +0200 (CEST) Received: (qmail 57110 invoked by uid 500); 5 Oct 2017 16:02:20 -0000 Mailing-List: contact dev-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ignite.apache.org Delivered-To: mailing list dev@ignite.apache.org Received: (qmail 57093 invoked by uid 99); 5 Oct 2017 16:02:20 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Oct 2017 16:02:20 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 6B9E0CE12F for ; Thu, 5 Oct 2017 16:02:19 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.301 X-Spam-Level: X-Spam-Status: No, score=-0.301 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-2.8, RCVD_IN_SORBS_SPAM=0.5, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gridgain-com.20150623.gappssmtp.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id hw5Z5DbL-T6m for ; Thu, 5 Oct 2017 16:02:17 +0000 (UTC) Received: from mail-io0-f169.google.com (mail-io0-f169.google.com [209.85.223.169]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 247B35F19B for ; Thu, 5 Oct 2017 16:02:17 +0000 (UTC) Received: by mail-io0-f169.google.com with SMTP id q11so13803173ioe.10 for ; Thu, 05 Oct 2017 09:02:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gridgain-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=k0XF7xJ0E3Q9TcOYew3OyXXCBa61KOdG2bpAlPoDx6o=; b=JddXJgyOnPWoOv3VkmFrlmv8agPteG5m2mgLQqEmw/qOVdofRvRgGLQg8lNCXPVR0e fBSQ0xapmQexDJbZv/p7Zq6rCx2hUdeH7lR1kubEbVuOziwemcevkqURg7AeJ3nQLVZb Yph2viT5ixSFVj9SzBAWhD01d0wy4b1mPgXDuZG9HOwNzGSTE8RowPScR5/bfwOIExBB Y4qZYG3BP3Nd6rxKEDKL8T5b+tv1RJ4o9DHZXnljnCRAsYjmpA2Hrv8EPurRqxROprds P5pkdNkLscv3ust1yI4XPOiVUVsNcmy3rEMQaGtb6J2zLVnoSM6OTUVaptkZugK4Hygp 95kg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=k0XF7xJ0E3Q9TcOYew3OyXXCBa61KOdG2bpAlPoDx6o=; b=h8hd1et1+t1oOH5BhGE9iBLoVV1m9e89XfBu5ON/Hng8BPruUd1W1gmQ3dFiJ/wpxj AocZDEZMk00QcmHN55BLQ5u82tqaSLtpe/Y6DnbGnDBDrLJ2gaXIRLK7+YE+l2ARkJJN yXq69flf48OAPuoJvz2Zp8ABylpIO1HeTX0ldhG1SVKrEQJgZzsjf6ppJU4ifFtxVr/x LafcEtl1c1bc22y8eBuKmzgdVzEnA+RtpNoUk/mrmHcKGiisxFX/ymo5S0waGnCRvAXw 6joYEcV4ZA0D8y2jO/oNJCNKTgQMsIfjeiAmUspZZ3pvosnVpCbPCjlkL5iZcfG2uPVK zbWA== X-Gm-Message-State: AMCzsaV5BwWZyjVryTwnu4hDmseB/SxXL7m2FHhwbEmkr/HtPbyQX7L0 eGWuqh+bcIe85prYjax1LiRUjn+wAB5dU0hxWxJrcg== X-Google-Smtp-Source: AOwi7QAAm8XIl295Jdy3hmSKflhtk3WVhaPorAAXdcO4MDTKDCiz8yhnyvXocwYZq09aWipZn9jclm2s+XTw0IW6yM4= X-Received: by 10.107.46.163 with SMTP id u35mr35706144iou.276.1507219335388; Thu, 05 Oct 2017 09:02:15 -0700 (PDT) MIME-Version: 1.0 Received: by 10.2.20.74 with HTTP; Thu, 5 Oct 2017 09:02:14 -0700 (PDT) In-Reply-To: References: <19BBC834-B22D-4CBF-B6B4-8A1405227959@apache.org> From: Sergey Kozlov Date: Thu, 5 Oct 2017 19:02:14 +0300 Message-ID: Subject: Re: Adding sqlline tool to Apache Ignite project To: dev@ignite.apache.org Cc: Denis Magda Content-Type: multipart/alternative; boundary="001a113ab58815bd47055aced97f" archived-at: Thu, 05 Oct 2017 16:02:22 -0000 --001a113ab58815bd47055aced97f Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Dmitriy, Denis We're in progress to add sqlline in upcoming 2.3 On Thu, Oct 5, 2017 at 5:30 PM, Dmitriy Setrakyan 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 > 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 : > > > > > Denis, > > > > > > I=E2=80=99m glad you=E2=80=99re thinking of using SQLLine. Under the = BSD license, you > > > don=E2=80=99t need my permission to distribute, but I grant that perm= ission. > > > > > > Drill, Phoenix and Calcite already distribute SQLLine, so Ignite is i= n > > > 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 need Ignite-specif= ic 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 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/ > yde/ > > > > > > > > [2] https://github.com/julianhyde/sqlline > > julianhyde/sqlline> > > > > > > > > =E2=80=94 > > > > Denis > > > > > > > >> On Aug 25, 2017, at 9:17 AM, Denis Magda > > dmagda@apache.org>> 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 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 o= r > > 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 permit. > > > >> > > > >> =E2=80=94 > > > >> Denis > > > >> > > > >>> On Aug 25, 2017, at 9:12 AM, Ilya Kasnacheev < > > > ilya.kasnacheev@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 : > > > >>> > > > >>>> 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 com= patible > with > > > ours. > > > >>>> However, there is a note on ASF side saying that BSD licenses ca= n > be > > > >>>> included without advertising clause [1]. What does it mean for u= s? > > > 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 > > > > 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 > > > --=20 Sergey Kozlov GridGain Systems www.gridgain.com --001a113ab58815bd47055aced97f--