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 10:13:21 GMT
hm. Certainly it worked if I recall correctly on 0.14, 1.2.1 and now on 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 10:08, Dmitry Tolpeko <dmtolpeko@gmail.com> wrote:

> 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