Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 50C00189F2 for ; Fri, 11 Mar 2016 06:35:04 +0000 (UTC) Received: (qmail 732 invoked by uid 500); 11 Mar 2016 06:35:02 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 662 invoked by uid 500); 11 Mar 2016 06:35:02 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 643 invoked by uid 99); 11 Mar 2016 06:35:02 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 Mar 2016 06:35:02 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 49F2E1A10DB; Fri, 11 Mar 2016 06:35:02 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.198 X-Spam-Level: ** X-Spam-Status: No, score=2.198 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_REPLY=1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx2-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id 9uh0ICKc245k; Fri, 11 Mar 2016 06:35:00 +0000 (UTC) Received: from mail-lb0-f172.google.com (mail-lb0-f172.google.com [209.85.217.172]) by mx2-lw-us.apache.org (ASF Mail Server at mx2-lw-us.apache.org) with ESMTPS id 6242C5F572; Fri, 11 Mar 2016 06:34:59 +0000 (UTC) Received: by mail-lb0-f172.google.com with SMTP id xr8so137847383lbb.1; Thu, 10 Mar 2016 22:34:59 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc; bh=s5S0JMW3Ku1Tjum/t0z2uF7qWQYODhpkNVFipyTZhjc=; b=hrnj0a2vvNcX2kWGHU5gwtn/Ma24cDenjfE8JeOyEtprY9vWJ743E6KIZ47c78fo6q JPXsz7SrIX3r8pztimOMh/3zas95dHphCMFpXSlJcLgm8MOg6LAjWE7JkYCcE6WyimCZ bNolYGnSC4fpXZFTkQqY/8b+LXMGcGAKq2mfcjJJ6le3laKO+q1uKfCi9YD4sDOsyi6y UMTZ9D//qRvasjlGOXmZrjwFEwdvooy212TPmvoaG84GxRckV/MATFuoSfiXe3qHsS/d VC8x9AzNgA0k1w1h0ppLTzDG+srD3t7Gg6pjEzzTh6cKDhGuGC7q3yV6YVr7J6XNfA2W k1vA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc; bh=s5S0JMW3Ku1Tjum/t0z2uF7qWQYODhpkNVFipyTZhjc=; b=gqymMPcVPd5x6vj5sk3+sLA/nryXA/WMceBFHHvWSqSn0eTUVHb27n6vv9ASys0dzQ CCwjLvyqjIiBxLUlkijSbLQ/QNroZVuLzkLkZeD63ZToxDyaGSHmrLjmsG457CAk2tA0 DTCColcV2DJJ3XmWZmhTkA+TV46k42BGLgz+Nbc/qcsF1YcOPnPvoQsnogeaCX3VaXOU UcF5qSULQmvWzvOUaLqFUSu8p2ZxCyPTR0wwo5QSGqY3ofVdwdZfshuPAzbb5WFcaW5/ DiXxNvLtq2cEf9a96CFADLA8/gGZ0wl/a7uZpE4XSKjXNQ/67EcSQf4eFk22UF7PNzbq 6xsg== X-Gm-Message-State: AD7BkJImgj2EaQvRFyOkvUW5FBEknIu+1vLwVXHPxgeofEL5H/9HRhedISq5wzhQPLE6wklHY8XNASjTfUnJNw== MIME-Version: 1.0 X-Received: by 10.25.21.94 with SMTP id l91mr2605375lfi.25.1457678097652; Thu, 10 Mar 2016 22:34:57 -0800 (PST) Received: by 10.112.72.202 with HTTP; Thu, 10 Mar 2016 22:34:57 -0800 (PST) In-Reply-To: References: Date: Fri, 11 Mar 2016 09:34:57 +0300 Message-ID: Subject: Re: SELECT without FROM From: Dmitry Tolpeko To: user@hive.apache.org Cc: dev@hive.apache.org Content-Type: multipart/alternative; boundary=001a113f17d63523ce052dc021a7 --001a113f17d63523ce052dc021a7 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thank you, Shannon! On Fri, Mar 11, 2016 at 4:47 AM, Shannon Ladymon wrote= : > It looks like FROM was made optional in Hive 0.13.0 with HIVE-4144 > (thanks Alan Gates to > pointing us to the grammar file and Sushanth Sowyman for helping track th= is > down). A note has been added to the wiki > > about this. > > Dmitry, you said it didn't work in your Hive 0.13 version, but it seems > like the patch was applied to 0.13.0. You might want to take a look at > HIVE-4144 and see if that patch was applied to your version. > > -Shannon Ladymon > > On Wed, Mar 9, 2016 at 2:13 AM, Mich Talebzadeh > wrote: > >> hm. Certainly it worked if I recall correctly on 0.14, 1.2.1 and now on = 2 >> >> Dr Mich Talebzadeh >> >> >> >> LinkedIn * https://www.linkedin.com/profile/view?id=3DAAEAAAAWh2gBxianrb= Jd6zP6AcPCCdOABUrV8Pw >> * >> >> >> >> http://talebzadehmich.wordpress.com >> >> >> >> On 9 March 2016 at 10:08, Dmitry Tolpeko wrote: >> >>> Not sure. It does not work in my Hive 0.13 version. >>> >>> On Wed, Mar 9, 2016 at 1:06 PM, Mich Talebzadeh < >>> mich.talebzadeh@gmail.com> wrote: >>> >>>> I believe it has always been there >>>> >>>> Dr Mich Talebzadeh >>>> >>>> >>>> >>>> LinkedIn * https://www.linkedin.com/profile/view?id=3DAAEAAAAWh2gBxian= rbJd6zP6AcPCCdOABUrV8Pw >>>> * >>>> >>>> >>>> >>>> http://talebzadehmich.wordpress.com >>>> >>>> >>>> >>>> On 9 March 2016 at 09:58, Dmitry Tolpeko wrote: >>>> >>>>> Mich, >>>>> >>>>> I now that. I just want to trace when it was added to Hive. >>>>> >>>>> Dmitry >>>>> >>>>> On Wed, Mar 9, 2016 at 12:56 PM, Mich Talebzadeh < >>>>> mich.talebzadeh@gmail.com> wrote: >>>>> >>>>>> ASAIK any database does that! >>>>>> >>>>>> 1> set nocount on >>>>>> 2> select @@version >>>>>> 3> select 1 + 1 >>>>>> 4> go >>>>>> >>>>>> >>>>>> >>>>>> -------------------------------------------------------------------= ---------------------------------------------------------------------------= ---------------------------------------------------------------------------= -------------------------------------- >>>>>> Adaptive Server Enterprise/15.7/EBF 21708 SMP SP110 >>>>>> /P/x86_64/Enterprise Linux/ase157sp11x/3546/64-bit/FBO/Fri Nov 8 05= :39:38 >>>>>> 2013 >>>>>> >>>>>> ----------- >>>>>> 2 >>>>>> >>>>>> >>>>>> Dr Mich Talebzadeh >>>>>> >>>>>> >>>>>> >>>>>> LinkedIn * https://www.linkedin.com/profile/view?id=3DAAEAAAAWh2gBxi= anrbJd6zP6AcPCCdOABUrV8Pw >>>>>> * >>>>>> >>>>>> >>>>>> >>>>>> http://talebzadehmich.wordpress.com >>>>>> >>>>>> >>>>>> >>>>>> On 9 March 2016 at 09:50, Dmitry Tolpeko wrote= : >>>>>> >>>>>>> I noticed that Hive allows you to execute SELECT without FROM claus= e >>>>>>> (tested in Hive 0.14, Hive 1.2.1): >>>>>>> >>>>>>> SELECT 1+1; >>>>>>> >>>>>>> In which version was it added (is there a Jira)? I see that it is >>>>>>> not mentioned in docs >>>>>>> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Sel= ect >>>>>>> >>>>>>> So the question whether it is official and will not be removed in >>>>>>> future. >>>>>>> >>>>>>> Thanks, >>>>>>> >>>>>>> Dmitry >>>>>>> >>>>>> >>>>>> >>>>> >>>> >>> >> > --001a113f17d63523ce052dc021a7 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Thank you, Shannon!

On Fri, Mar 11, 2016 at 4:47 AM, Shannon = Ladymon <sladymon@gmail.com> wrote:
It looks like FROM was made option= al in Hive 0.13.0 with HIVE-4144 (thanks Alan Gates to pointing us t= o the grammar file and Sushanth Sowyman for helping track this down). A not= e has been added to the wiki about this.

Dmitry, you said it didn't w= ork in your Hive 0.13 version, but it seems like the patch was applied to 0= .13.0. You might want to take a look at HIVE-4144 and see if that patch was= applied to your version.

-Shannon Ladymon

On Wed, Mar 9, 2016 at 2:13= AM, Mich Talebzadeh <mich.talebzadeh@gmail.com> wro= te:
hm. Certainly it wor= ked if I recall correctly on 0.14, 1.2.1 and now on 2


On 9 March 2016 at 10:08, D= mitry Tolpeko <dmtolpeko@gmail.com> wrote:
Not sure. It does not work in my Hive 0.13 version.=

On Wed, Mar 9, 2016 at 1:06 PM, Mich Talebzadeh <= mich.talebza= deh@gmail.com> wrote:
I = believe it has always been there


On 9 March 2016 at 09:58, Dmitry Tolpeko <dmtolpeko@gmail.com> wrote:
Mich,

I now that= . I just want to trace when it was added to Hive.
Dmit= ry

On Wed, Mar 9, 2016 at 12:56 PM, Mich Talebzadeh <mich.talebzadeh@gmail.com> wrote:
=
ASAIK any database does that!

1> set nocount on=
2> select @@version
3> select 1 + 1
4> go
=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0
=C2=A0-= ---------------------------------------------------------------------------= ---------------------------------------------------------------------------= ---------------------------------------------------------------------------= -----------------------------
=C2=A0Adaptive Server Enterprise/15.7/EBF = 21708 SMP SP110 /P/x86_64/Enterprise Linux/ase157sp11x/3546/64-bit/FBO/Fri = Nov=C2=A0 8 05:39:38 2013=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0
=C2=A0-----------
= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 2
=



On 9 March 2016 at 09:50, Dmitry Tolpeko <dmtolpeko@gmail.com> wrote:
I notic= ed that Hive allows you to execute SELECT without FROM clause (tested in Hi= ve 0.14, Hive 1.2.1):

SELECT 1+1;

In which version was it added (is there a Jira)? I see that= it is not mentioned in docs=C2=A0https://cwiki.a= pache.org/confluence/display/Hive/LanguageManual+Select

So the question whethe= r it is official and will not be removed in future.

Thanks,=C2=A0

Dmitry







--001a113f17d63523ce052dc021a7--