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 9B6C9197BA for ; Wed, 9 Mar 2016 09:50:21 +0000 (UTC) Received: (qmail 94796 invoked by uid 500); 9 Mar 2016 09:50:20 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 94719 invoked by uid 500); 9 Mar 2016 09:50:20 -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 94698 invoked by uid 99); 9 Mar 2016 09:50:20 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Mar 2016 09:50:20 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 96EA4180B84; Wed, 9 Mar 2016 09:50:19 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-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: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx2-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id EBJbidZi3xVK; Wed, 9 Mar 2016 09:50:18 +0000 (UTC) Received: from mail-lb0-f178.google.com (mail-lb0-f178.google.com [209.85.217.178]) by mx2-lw-eu.apache.org (ASF Mail Server at mx2-lw-eu.apache.org) with ESMTPS id 1795C5F2C3; Wed, 9 Mar 2016 09:50:18 +0000 (UTC) Received: by mail-lb0-f178.google.com with SMTP id x1so57148091lbj.3; Wed, 09 Mar 2016 01:50:18 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to; bh=GH/zy0xNvRFmwewGo337icZ+FxFbt8zTTStLe83ZNfY=; b=mzbhu2V96agj5XIhxpt+1GjUnGWnpuOZJQFaAS1z1XR9fjYVQRBfXYjN4B81kS5psn ymyRN/oMh8INW5/hPymj+EZOj0nLKuzssT8LHdeuzIai1a5hb/qIvO0uYhPmhuoKsufg HMRFmoCsKMilIkd6drsdiZhoj1say+S/7KYkbOzLcBlMeNsIGK3x7SSA52QkxmmbcBRs yrMj8F+IPDDASOsyD2Ez/I+dM6HvO/pWEtuADMcWWmjvXew7bxAhCOdYPe71dMm6cATK ZgCAQ8tEXVNQKiK+Wn0606YWo1TQphiv1PHQXum1uJrKT/YHbVAL4wlOvDLK4+EAUTAg nyLw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:date:message-id:subject:from:to; bh=GH/zy0xNvRFmwewGo337icZ+FxFbt8zTTStLe83ZNfY=; b=CWzJnipxgZVcXwvoGASG4xia/skkyqWTAZZna5r/3VNLqLwF+o1PPlMvKqIPAClsiP OQAnxuiq+8BiGehuDXME2N4+PDM7MqyWML4F2OQkfo8PJh1xuTjrmFsaokrdjqYg7y3v PEhs45USPZNAm6Fu5wEbOML8WD2b8j6xcw7+kLOB4WzPuW9XRStCQe3YAPBNGtBOX0Q1 keG1qHrtn7LKQ56bc7IZEZor3yQ1f672v8df8xbux1Nda8S9P1iVyU+PAwq0RlmV7tho ykK0xwUckm6iR/+NGVdhLJg+I+5rvaszvHWqrXNGBSJOjS2gS5+j99UNqB+XU5KeS/ie 40HA== X-Gm-Message-State: AD7BkJKD3fJvua4TJn2ntHigwxrF+AR1XFp1iY8Ipb+nnsux/wzFk+TK7HLC/m3g4IetfP5/39tZ1vii3bUXqw== MIME-Version: 1.0 X-Received: by 10.25.148.208 with SMTP id w199mr11775312lfd.124.1457517017632; Wed, 09 Mar 2016 01:50:17 -0800 (PST) Received: by 10.112.72.202 with HTTP; Wed, 9 Mar 2016 01:50:17 -0800 (PST) Date: Wed, 9 Mar 2016 12:50:17 +0300 Message-ID: Subject: SELECT without FROM From: Dmitry Tolpeko To: dev@hive.apache.org, user@hive.apache.org Content-Type: multipart/alternative; boundary=001a1140234c171a53052d9aa0cf --001a1140234c171a53052d9aa0cf Content-Type: text/plain; charset=UTF-8 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 --001a1140234c171a53052d9aa0cf Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I noticed that Hive allows you to execute SELE= CT 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/confluence/display/Hiv= e/LanguageManual+Select

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

Thanks,=C2=A0

Dmitry --001a1140234c171a53052d9aa0cf--