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 7B14E1985A for ; Wed, 9 Mar 2016 10:06:54 +0000 (UTC) Received: (qmail 53357 invoked by uid 500); 9 Mar 2016 10:06:52 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 53288 invoked by uid 500); 9 Mar 2016 10:06:52 -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 53269 invoked by uid 99); 9 Mar 2016 10:06:52 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Mar 2016 10:06:52 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 69BB2C11B0; Wed, 9 Mar 2016 10:06:52 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.198 X-Spam-Level: * X-Spam-Status: No, score=1.198 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_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd4-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 (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id qu4BegAptLGz; Wed, 9 Mar 2016 10:06:50 +0000 (UTC) Received: from mail-vk0-f44.google.com (mail-vk0-f44.google.com [209.85.213.44]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id E7F2D5F33D; Wed, 9 Mar 2016 10:06:49 +0000 (UTC) Received: by mail-vk0-f44.google.com with SMTP id e185so49756545vkb.1; Wed, 09 Mar 2016 02:06:49 -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=lTk/8frpHiBQFaHF0zeoZI5pP7Ext0k9XVvCF8P7nYU=; b=s+xZjgfTDnvv7fLftNw+QIghIxSyLVpjDHNh5ewJPVfX+NXNy1ProD0gh4zgiJKMKZ G/+fO0El8SWIu2xXc0HoYWjeTZtOX5HleDZMOsY0eSyozYuDYN7qnCdsdorbqA90+O9S QE5/ehK5Qj3jHKRsX1+S5qMib8F+nRyToe6/ANXAawT2QODcXiI0csX3+Rk83y6zJM8B XFov4Dw23csMYgz0QgCXTS2Xibt6mwTCDcv8dJZtq0QRuhrXhGhSTDOCzNg8dg8HQHiA JoEjam1vdlEZCpM8opxdfiyqBTSCfjKwFSKI4MBmORUJ4Gl+4EjT0qWF1JNr/9KarFue SpiA== 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=lTk/8frpHiBQFaHF0zeoZI5pP7Ext0k9XVvCF8P7nYU=; b=Yh3HiQzn1cZVJvjcIMJEO66S7eg14I7K3XLzCfqRXIhheEBWo00r85j57PCE4eP1rx 4OzxJDpiRzHcIDvq0SRAiYI3mVd7J3nldlZBzBgweSRA94ISfpZlXLxOD/yrK8Cm9J0w pe9nmY2699o+DqhLNzY7eoPlaG0P7O7qJ6dVUCDRMdClhZ+dvl+KYa58xCumngTi2LIy eP3V7Oub5ZO83FhlZWr5tJg/rXmlVbnuwYG0K5FMJWeMprtX5t8hd2MQDfuP85wwcMNV qG3wr9OFxaGy3UAMwe4egbxohayz1j3WyCZNu+kP0lDU/sO/6z/t4GMLJBMTnpFcRd8m +SmA== X-Gm-Message-State: AD7BkJLW3P+4zE2njkRmGaSCXRYvDl+S6O+jaT4LzwT26nyrJPLUnDjvRAh8KS5X50nCGX2r7L+g1KshGI8gcA== MIME-Version: 1.0 X-Received: by 10.31.8.17 with SMTP id 17mr20663473vki.139.1457518009372; Wed, 09 Mar 2016 02:06:49 -0800 (PST) Received: by 10.31.128.213 with HTTP; Wed, 9 Mar 2016 02:06:49 -0800 (PST) In-Reply-To: References: Date: Wed, 9 Mar 2016 10:06:49 +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=001a11441d8233d7a2052d9adba0 --001a11441d8233d7a2052d9adba0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I believe it has always been there Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=3DAAEAAAAWh2gBxianrbJd6= zP6AcPCCdOABUrV8Pw * 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/Enterpris= e >> 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=3DAAEAAAAWh2gBxianrb= Jd6zP6AcPCCdOABUrV8Pw >> * >> >> >> >> 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 futur= e. >>> >>> Thanks, >>> >>> Dmitry >>> >> >> > --001a11441d8233d7a2052d9adba0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
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
<= div class=3D"gmail_extra">
On Wed, Mar 9, 201= 6 at 12:56 PM, Mich Talebzadeh <mich.talebzadeh@gmail.com><= /span> wrote:
ASAIK any database = does that!

1> set nocount on
2> select @@version
3> selec= t 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=A0Ada= ptive 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



--001a11441d8233d7a2052d9adba0--