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 94B3219895 for ; Wed, 9 Mar 2016 10:13:26 +0000 (UTC) Received: (qmail 80459 invoked by uid 500); 9 Mar 2016 10:13:24 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 80373 invoked by uid 500); 9 Mar 2016 10:13:24 -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 80353 invoked by uid 99); 9 Mar 2016 10:13:24 -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; Wed, 09 Mar 2016 10:13:24 +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 56E0DC0133; Wed, 9 Mar 2016 10:13:24 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-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: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id RabEJCNhfFyO; Wed, 9 Mar 2016 10:13:22 +0000 (UTC) Received: from mail-vk0-f53.google.com (mail-vk0-f53.google.com [209.85.213.53]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 02D2F5F33D; Wed, 9 Mar 2016 10:13:21 +0000 (UTC) Received: by mail-vk0-f53.google.com with SMTP id k1so49986329vkb.0; Wed, 09 Mar 2016 02:13:21 -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=2smMn5QQpZfFLkL/P1yIDa5ZOCOxQkgnKU3DhpvxnFI=; b=JDqYngmtOeQ46p2TBavAbP08SuqZ6cA0YtQUiheRDIxKulYrr+mNoIU8yBSLKuhpip /5ZMrsKufLBIPm56/2nQC+OZs4qtH487AhdjdV3vnkF95BGMR2hV5h4hz1QcY+U5wofT 7ExAO0nRnenXCXH0G+Bnri9efwqJOZnhjArbmGGH1aAT30Dek9geZk3Jb+iegfyrXrXc WMrDe6h+2+m9bIY587o8j/wia8RRHg2ZaWfYurR66I+F7PDGVsIAXG7+wiLDiHid3VeL EXNkp0tU1bDGYYLDnAyuwLLu3Tp/pCsx+fxGCPLzhBjXANnzc8Tl3FDTVfoZlkUU+Cm2 xXvA== 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=2smMn5QQpZfFLkL/P1yIDa5ZOCOxQkgnKU3DhpvxnFI=; b=kJrIPaKD+H8NuRgTEa21F7716BUNMJq0SDyOSRJgKTff4+iOLFu0cYlxCcXcstvvIJ l/d2skv/PYM0Tb4Il4YIS7TQQmfjZJ1RiQQpYjjbFYaoNpilcO2Oi5IFBnLVVw3CTpgn 9B3pJbtk07qRrfSY7+iFxbv7LgWm+N9nv7Zz0tFH8HbCRtIWpzNMoj+MvLYetUJjuIlQ Vn8Dmk+1ep8uUABexCS6j875ssZYkzsTy27p6X+1ALneOlShDbby7NAHw//1bcEgyzXP 1v8wtru2neU8esl0Tq068fuD0cGw5rAyhdUgHZOql4dIRYU+bESP60Y0ESaC3py7BJjz GUgA== X-Gm-Message-State: AD7BkJJDZcZGSx5bXBOzB+bHpb8jwUF4dBBLGaDyA4gpszhh4Zn80REERtUWw7vW5vHdk1OwOaNx138GFmcAfw== MIME-Version: 1.0 X-Received: by 10.31.162.3 with SMTP id l3mr31341565vke.68.1457518401440; Wed, 09 Mar 2016 02:13:21 -0800 (PST) Received: by 10.31.128.213 with HTTP; Wed, 9 Mar 2016 02:13:21 -0800 (PST) In-Reply-To: References: Date: Wed, 9 Mar 2016 10:13:21 +0000 Message-ID: Subject: Re: SELECT without FROM From: Mich Talebzadeh To: user@hive.apache.org Cc: dev@hive.apache.org Content-Type: multipart/alternative; boundary=001a114406ea9264f4052d9af2ac --001a114406ea9264f4052d9af2ac Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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=3DAAEAAAAWh2gBxianrbJd6= zP6AcPCCdOABUrV8Pw * 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 > wrote: > >> I believe it has always been there >> >> Dr Mich Talebzadeh >> >> >> >> LinkedIn * https://www.linkedin.com/profile/view?id=3DAAEAAAAWh2gBxianrb= Jd6zP6AcPCCdOABUrV8Pw >> * >> >> >> >> 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:3= 9:38 >>>> 2013 >>>> >>>> ----------- >>>> 2 >>>> >>>> >>>> Dr Mich Talebzadeh >>>> >>>> >>>> >>>> LinkedIn * https://www.linkedin.com/profile/view?id=3DAAEAAAAWh2gBxian= rbJd6zP6AcPCCdOABUrV8Pw >>>> * >>>> >>>> >>>> >>>> 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+Selec= t >>>>> >>>>> So the question whether it is official and will not be removed in >>>>> future. >>>>> >>>>> Thanks, >>>>> >>>>> Dmitry >>>>> >>>> >>>> >>> >> > --001a114406ea9264f4052d9af2ac Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
hm. Certainly it worked if I recall correctly on 0.14, 1.2= .1 and now on 2


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

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

Dmitry

On Wed, M= ar 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-------------------------------= ---------------------------------------------------------------------------= ---------------------------------------------------------------------------= --------------------------------------------------------------------------<= br>=C2=A0Adaptive Server Enterprise/15.7/EBF 21708 SMP SP110 /P/x86_64/Ente= rprise 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





--001a114406ea9264f4052d9af2ac--