hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dmitry Tolpeko <dmtolp...@gmail.com>
Subject Re: SELECT without FROM
Date Wed, 09 Mar 2016 10:08:37 GMT
Not sure. It does not work in my Hive 0.13 version.

On Wed, Mar 9, 2016 at 1:06 PM, Mich Talebzadeh <mich.talebzadeh@gmail.com>
wrote:

> I believe it has always been there
>
> 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: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, 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: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