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 5939D19875 for ; Wed, 9 Mar 2016 10:08:46 +0000 (UTC) Received: (qmail 62764 invoked by uid 500); 9 Mar 2016 10:08:41 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 62583 invoked by uid 500); 9 Mar 2016 10:08:41 -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 62140 invoked by uid 99); 9 Mar 2016 10:08:41 -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; Wed, 09 Mar 2016 10:08:41 +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 AF3561A0479; Wed, 9 Mar 2016 10:08:40 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.179 X-Spam-Level: * X-Spam-Status: No, score=1.179 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_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, 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 mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id k8GIqrdURHWu; Wed, 9 Mar 2016 10:08:38 +0000 (UTC) Received: from mail-lb0-f174.google.com (mail-lb0-f174.google.com [209.85.217.174]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 186375FBA6; Wed, 9 Mar 2016 10:08:38 +0000 (UTC) Received: by mail-lb0-f174.google.com with SMTP id bc4so57808098lbc.2; Wed, 09 Mar 2016 02:08:38 -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=hVVERQ2NPjs7c8t0rw99AZTIWfrjEnaxFpSR1N6AUXk=; b=N7jltd8MQYiuVso8fjk6hdLWPngOKfgthFIQ+f35bEW92sGLiZ/sUXJUzgQm+nsfjw 4/D8JNFGRuJVki//clqa3EmCowSgwD0QblJqbgw9hxQZFDup7cIFYPb4XKqCRHCw/T5w BsSgoHbnjOF8oSpotnieuPJLSuYlu5k0MV7sVTbo4MGN6A5iutlXcdwP38kKhT1dOG52 bsZGJBjqSWTbjnEiPq7qklfpm8XrhumqFBot0VlczyMvHqy9rxVd+H2szLSnlGyqzsUd ZcNUPhrX0gmo09uamLhpwQjhFi0HHOni57SNqPGYvLGsmJt6Hdc8tEdNbEILgJ2/dbbT SErQ== 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=hVVERQ2NPjs7c8t0rw99AZTIWfrjEnaxFpSR1N6AUXk=; b=BRPxW8jQCVf8k8VaT9585hhF4QiKNdwCwef0fIDpcppwfNRTyTAO7Er6BYPOhIWnsZ VQo80SCe4D75m8hhmrjkZLeAvt1q5EdszItmZ6NebjNskeSvBydqzEibTtsBqNv8Uirb 5RrfBLfF4SBbvdioMeE8XZGiG2fXWm3b9jKZLDAKrX4WlWaqkQGPFx7vzKHz94rqr7Si SM0LEMLon6gmSmq7QLGRq4KBlQuhlPu9WnNwYckk1odJv1267VYqcJ7owigRPg+MGYkN saYc++5Ormbeqdv+YWb2MTqXrgY5Qhu15kdxCU3O15jZwhmsSr3Wtt+m2s/uuBI82u0+ s96Q== X-Gm-Message-State: AD7BkJKeXqscqcljCECzdHKKkVIpzBePMluMHsAV8cLwjVu7U2KJkmG2d0IlbyYI1JlVaHaAs4z4/VWziQ/3rQ== MIME-Version: 1.0 X-Received: by 10.25.209.73 with SMTP id i70mr11812063lfg.0.1457518117643; Wed, 09 Mar 2016 02:08:37 -0800 (PST) Received: by 10.112.72.202 with HTTP; Wed, 9 Mar 2016 02:08:37 -0800 (PST) In-Reply-To: References: Date: Wed, 9 Mar 2016 13:08:37 +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=001a1141fcaaa7ef4e052d9ae19a --001a1141fcaaa7ef4e052d9ae19a Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Not sure. It does not work in my Hive 0.13 version. On Wed, Mar 9, 2016 at 1:06 PM, Mich Talebzadeh wrote: > I believe it has always been there > > Dr Mich Talebzadeh > > > > LinkedIn * https://www.linkedin.com/profile/view?id=3DAAEAAAAWh2gBxianrbJ= d6zP6AcPCCdOABUrV8Pw > * > > > > 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=3DAAEAAAAWh2gBxianr= bJd6zP6AcPCCdOABUrV8Pw >>> * >>> >>> >>> >>> 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 clause >>>> (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+Select >>>> >>>> So the question whether it is official and will not be removed in >>>> future. >>>> >>>> Thanks, >>>> >>>> Dmitry >>>> >>> >>> >> > --001a1141fcaaa7ef4e052d9ae19a Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Not sure. It does not work in my Hive 0.13 versio= n.

On = Wed, Mar 9, 2016 at 1:06 PM, Mich Talebzadeh <mich.talebzadeh@gma= il.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.

Dmitry
=

On Wed, Mar 9, 2016 at 12:56 PM, Mich Talebzadeh &l= t;mich.taleb= zadeh@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 noticed that Hive allows you to execute SELECT without F= ROM clause (tested in Hive 0.14, Hive 1.2.1):

SELECT 1+1;

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

So t= he question whether it is official and will not be removed in future.
=

Thanks,=C2=A0

Dmitry




--001a1141fcaaa7ef4e052d9ae19a--