hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stephen Boesch <java...@gmail.com>
Subject Re: SELECT without FROM
Date Fri, 11 Mar 2016 02:09:22 GMT
>> any database

Just as trivia:
i have not used oracle for quite a while but it traditionally does not.

AFAICT it is also not ansi sql

2016-03-10 17:47 GMT-08:00 Shannon Ladymon <sladymon@gmail.com>:

> It looks like FROM was made optional in Hive 0.13.0 with HIVE-4144
> <https://issues.apache.org/jira/browse/HIVE-4144> (thanks Alan Gates to
> pointing us to the grammar file and Sushanth Sowyman for helping track this
> down). A note has been added to the wiki
> <https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select#LanguageManualSelect-SelectSyntax>
> about this.
>
> Dmitry, you said it didn't work in your Hive 0.13 version, but it seems
> like the patch was applied to 0.13.0. You might want to take a look at
> HIVE-4144 and see if that patch was applied to your version.
>
> -Shannon Ladymon
>
> On Wed, Mar 9, 2016 at 2:13 AM, Mich Talebzadeh <mich.talebzadeh@gmail.com
> > wrote:
>
>> 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