hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shannon Ladymon <slady...@gmail.com>
Subject Re: SELECT without FROM
Date Fri, 11 Mar 2016 01:47:19 GMT
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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message