hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <mich.talebza...@gmail.com>
Subject Re: SELECT without FROM
Date Wed, 09 Mar 2016 09:56:55 GMT
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
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*



http://talebzadehmich.wordpress.com



On 9 March 2016 at 09:50, Dmitry Tolpeko <dmtolpeko@gmail.com> 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
>

Mime
View raw message