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 86643200C1F for ; Sat, 4 Feb 2017 03:03:02 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 84BC3160B55; Sat, 4 Feb 2017 02:03:02 +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 A8644160B3F for ; Sat, 4 Feb 2017 03:03:01 +0100 (CET) Received: (qmail 92960 invoked by uid 500); 4 Feb 2017 02:03:00 -0000 Mailing-List: contact dev-help@asterixdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@asterixdb.apache.org Delivered-To: mailing list dev@asterixdb.apache.org Received: (qmail 92947 invoked by uid 99); 4 Feb 2017 02:03:00 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 04 Feb 2017 02:03:00 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 2B531181BC0 for ; Sat, 4 Feb 2017 02:03:00 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.379 X-Spam-Level: ** X-Spam-Status: No, score=2.379 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_SORBS_SPAM=0.5, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id dFLlTCSNDy1g for ; Sat, 4 Feb 2017 02:02:58 +0000 (UTC) Received: from mail-yw0-f175.google.com (mail-yw0-f175.google.com [209.85.161.175]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id A95DD5F30A for ; Sat, 4 Feb 2017 02:02:57 +0000 (UTC) Received: by mail-yw0-f175.google.com with SMTP id u68so22806442ywg.0 for ; Fri, 03 Feb 2017 18:02:57 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=r+yXlaAnCErsjuE9DsyZiagNARi47ufLYxYjxiWGGjs=; b=XcPWAd3BSKOsTDWn/IdG8pHUIOJD7bChCY/WkStbe1m2YS/+5eH+jNx2Iv+4EGvV1c Pk4e0H8XOD7I2lPQ20U2zYcYjRpKd2okZj3l73wzXXBTLk2Z5PxQYXiuMgUylbcfV5xe V8ba2TM4sJGwvmJn990X9WGyVewzBqgHZ3YMlxxwaZXA6B1wtnw5XCdjncmpiwylbSrv pT6dO6G8oPye/ViAZYVe9AxAn+KMwQMQO9Q/wn/36s4vGpakDdDYwNn/g7xhVPJ6C4Q3 Hx58N8pRADHYacfDZ5rdidbNU9uArvI/J0HIZLXeshuW9p1MkQKzdiYOiuCUG63Z2yiM RXZA== 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; bh=r+yXlaAnCErsjuE9DsyZiagNARi47ufLYxYjxiWGGjs=; b=iTH8Cca4iELO4A2XST+xECpMGCbbUQo/MS+50JzENKHDH7kQhG2Yfvfn0FzPJgyNny TIqK9Pj3NrDnWsG0C+3QsbLiajTy7MCccFSEmdP8elUjPAotN5ANjQ1ljfKZkt9eM8RX m/cXhedRy6Jp00U7BtOFteFAVwVE1sIppa7gAdQKyb564wUUwioAVaZHKoEnV3Ao+bUA k5FDRRVDWwAnntGphWpzjIr2ibsZxGElqBX/VggzMAhdbEtZq1zXTti3LLpuF6cQbmxp xrP0IZiVYwpEK6brObVpENC823cyzYSuoamX0BfDwpDl9ef1MBjJagyQFfuLfK7Yv5Xx Oijg== X-Gm-Message-State: AIkVDXJuhm7IDrWHmVvFG5wts7S41q4KQ7TAdRFASnGwOGTcUKxKjEoloPElyfY1DJ+DNro7H3l8e1UeYGIUQw== X-Received: by 10.129.181.1 with SMTP id t1mr54979ywh.16.1486173772994; Fri, 03 Feb 2017 18:02:52 -0800 (PST) MIME-Version: 1.0 Received: by 10.37.116.138 with HTTP; Fri, 3 Feb 2017 18:02:52 -0800 (PST) In-Reply-To: References: <9B87BCFE-A957-42BB-80F1-E76EE26D67D6@apache.org> <1340feeb-6ac7-585f-304d-f117a3a3cc81@gmail.com> From: Yingyi Bu Date: Fri, 3 Feb 2017 18:02:52 -0800 Message-ID: Subject: Re: Choosing defaults for AsterixDB To: dev@asterixdb.apache.org Content-Type: multipart/alternative; boundary=f403045eadced05ec30547aacbe4 archived-at: Sat, 04 Feb 2017 02:03:02 -0000 --f403045eadced05ec30547aacbe4 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable >> I want to pick up this thread to verify if the AQL will still be supported in the future? AQL will still stay there. However, "supported" might not be a 100% accurate term for an ASF open source software. Regardless of AQL or SQL++, if a user finds a bug or needs an improvement in any place of the system, s/he can open an issue. Then, if some committer/contributor is interested in fixing the bug, then s/he submits a patch. The process is volunteer or up to committers' interests. At least, that's my understanding of how ASF software works. This is very different from a paid enterprise software -- a reported bug or a wanted feature from customers must be responded (and/or fixed):-) Thoughts? >> It will be a hard work to switch to SQL++. Why translating to SQL++ is harder than AQL? I wonder if the current SQL++ language design and implementation misses some key pieces. Best, Yingyi On Fri, Feb 3, 2017 at 5:37 PM, Jianfeng Jia wrote= : > Hi, I want to pick up this thread to verify if the AQL will still be > supported in the future? > Currently, Cloudberry automatically translates the JSON request to AQL > statements. It will be a hard work to switch to SQL++. > > I=E2=80=99m not object to set the default option to SQL++. However, we wi= ll keep > the support for AQL, right? (especially in the RESTFull API). > > > On Jan 10, 2017, at 5:47 PM, Till Westmann wrote: > > > > Ok, since there=E2=80=99s a lot of agreement and no concerns, I=E2=80= =99ll go ahead. > > > > Thanks, > > Till > > > > On 10 Jan 2017, at 9:22, Yingyi Bu wrote: > > > >> +100! > >> > >> On Tue, Jan 10, 2017 at 9:17 AM, Mike Carey wrote: > >> > >>> +1 from me too for SQL++ and clean JSON. > >>> > >>> > >>> > >>> On 1/10/17 8:25 AM, Murtadha Hubail wrote: > >>> > >>>> +1 to SQL++ and clean JSON. > >>>> > >>>> Cheers, > >>>> Murtadha > >>>> > >>>> On Jan 10, 2017, at 9:46 AM, Till Westmann wrote: > >>>>> > >>>>> Hi, > >>>>> > >>>>> as you know AsterixDB supports 2 query languages (AQL and SQL++) an= d > many > >>>>> output formats (ADM, clean JSON, lossless JSON, CSV). Our current > >>>>> defaults > >>>>> for these options (at least on the web interface) are AQL and ADM. > >>>>> > >>>>> I=E2=80=99d like to propose to change those defaults to be SQL++ an= d (clean) > >>>>> JSON. > >>>>> The reason for wanting them to change, is that I think that these > choices > >>>>> are more attractive to new users of the system and thus can help to > >>>>> increase > >>>>> the adoption of AsterixDB. A user with some database experience is > much > >>>>> more > >>>>> likely to have previous SQL experience and to feel at home with SQL= ++ > >>>>> than > >>>>> having XQuery experience and feeling at home with AQL. Similarly, > most > >>>>> users > >>>>> will want to use the data that they get out of AsterixDB in an > >>>>> application > >>>>> and it will be a lot easier to consume JSON than it is to consume > ADM. > >>>>> > >>>>> I've prepared a (tiny) change to change the defaults [1] and I'm > >>>>> wondering > >>>>> if there are concerns that should keep us from making this change. > >>>>> > >>>>> Cheers, > >>>>> Till > >>>>> > >>>>> [1] https://asterix-gerrit.ics.uci.edu/#/c/1409/ > >>>>> > >>>> > >>> > > --f403045eadced05ec30547aacbe4--