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 7FE6B197FA for ; Wed, 9 Mar 2016 09:57:06 +0000 (UTC) Received: (qmail 21350 invoked by uid 500); 9 Mar 2016 09:57:04 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 21285 invoked by uid 500); 9 Mar 2016 09:57:04 -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 21266 invoked by uid 99); 9 Mar 2016 09:57:04 -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 09:57:04 +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 1D306C11B0; Wed, 9 Mar 2016 09:57:04 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-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: 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 9ZIvDnHE5tpf; Wed, 9 Mar 2016 09:57:02 +0000 (UTC) Received: from mail-vk0-f54.google.com (mail-vk0-f54.google.com [209.85.213.54]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id EBBA35FB2B; Wed, 9 Mar 2016 09:57:01 +0000 (UTC) Received: by mail-vk0-f54.google.com with SMTP id e185so49509387vkb.1; Wed, 09 Mar 2016 01:57:01 -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=vdtvS+QA95yw6eKXVXktasl5PWnjIdeaBGRl5KfW5Lo=; b=VkU02hzQ/Q24ybU00NgyynFQoND4YqBgQuUuijTLz61DFEEpnTW7VOkX7gs9ndZ7MM W10xS4GmOPOR646Q1woc7eH0l+6bIm3wrN0q+DHckOD4ZNlKzMUgayCQuYQDhzo8kX7A 372L1baPg0QuZ+PD80M3lhhAKUVEtFAWQTbbwRE1EIDUb8Wp+KXbD4rPcbvxGWV+rBdI m7+0v8gcUqozYp8pwYvDP276Zk6YplytkUpTORJ9e22JRtbTagostZaRCCkl/Frqd/qp 9n+mxffTOI2T836y8PRpRHmXTIpjHPmMkFvgCFZTLyBNCJ4GCQzI5BS5Q3L6hd+Ho8oh DL6w== 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=vdtvS+QA95yw6eKXVXktasl5PWnjIdeaBGRl5KfW5Lo=; b=hTEyvF4QxcUySQTrwE6zBp6me0qgnySc9F1pvuhWc6UxKzvKjbrtettbLnmoZkehsq FhNFd3XLs8beXTqF5+JV5fTYgB13dx6ofETFvLavPgMOAglA//2/YgOYqeZXnus1xz08 HWdL8hmDaI/cEO2ILoWQcQtMHJuHGnBFuH88B1OfBeS6mbqEHIVDNYDpdwcoovNvmIfO JBJ+weJekiSX3O152id+p/776im6ZdQmd9p01ISkYfZ/gMucHa1jl9sYKm0QttY3Fbtk Z855uabPGznx0ADxQEeGgkf0+/0OR/3cUN5tEaiBRvyDpUU5mWLvR9qPutICLZ9O+DUy J42Q== X-Gm-Message-State: AD7BkJKIPxkLktrKHjTBUENIV43cW9wqN3cC34FIFhphvYkDwQq/BQDbQF2dxWMhp0TIDlAtixD2wx8ajmGYqQ== MIME-Version: 1.0 X-Received: by 10.31.8.17 with SMTP id 17mr20633280vki.139.1457517415522; Wed, 09 Mar 2016 01:56:55 -0800 (PST) Received: by 10.31.128.213 with HTTP; Wed, 9 Mar 2016 01:56:55 -0800 (PST) In-Reply-To: References: Date: Wed, 9 Mar 2016 09:56:55 +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=001a11441d82ce67d8052d9ab7de --001a11441d82ce67d8052d9ab7de Content-Type: text/plain; charset=UTF-8 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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * 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 > --001a11441d82ce67d8052d9ab7de Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
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 SE= LECT 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 men= tioned in docs=C2=A0https://cwiki.apache.org/conf= luence/display/Hive/LanguageManual+Select

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

Thanks,=C2=A0

Dmitry
--001a11441d82ce67d8052d9ab7de--