You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Dmitry Tolpeko <dm...@gmail.com> on 2016/03/09 10:50:17 UTC
SELECT without FROM
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
Re: SELECT without FROM
Posted by Dmitry Tolpeko <dm...@gmail.com>.
Thanks, Alan. We should document this as well, now the syntax at
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select states
that FROM is mandatory.
Dmitry
On Wed, Mar 9, 2016 at 6:46 PM, Alan Gates <al...@gmail.com> wrote:
> I’m not aware of any JIRA on it. The easiest way to find out will be to
> look at the git history of Hive’s grammar file and see when it changed.
>
> As for taking out, we shouldn’t since it’s valid SQL and we’re pushing
> towards more ANSI compliance.
>
> Alan.
>
> > On Mar 9, 2016, at 01:50, Dmitry Tolpeko <dm...@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
>
>
Re: SELECT without FROM
Posted by Alan Gates <al...@gmail.com>.
I’m not aware of any JIRA on it. The easiest way to find out will be to look at the git history of Hive’s grammar file and see when it changed.
As for taking out, we shouldn’t since it’s valid SQL and we’re pushing towards more ANSI compliance.
Alan.
> On Mar 9, 2016, at 01:50, Dmitry Tolpeko <dm...@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
Re: SELECT without FROM
Posted by Stephen Boesch <ja...@gmail.com>.
>> 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 <sl...@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 <dm...@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 <dm...@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 <dm...@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
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
Re: SELECT without FROM
Posted by Dmitry Tolpeko <dm...@gmail.com>.
Thank you, Shannon!
On Fri, Mar 11, 2016 at 4:47 AM, Shannon Ladymon <sl...@gmail.com> wrote:
> 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 <dm...@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 <dm...@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 <dm...@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
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
Re: SELECT without FROM
Posted by Stephen Boesch <ja...@gmail.com>.
>> 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 <sl...@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 <dm...@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 <dm...@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 <dm...@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
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
Re: SELECT without FROM
Posted by Dmitry Tolpeko <dm...@gmail.com>.
Thank you, Shannon!
On Fri, Mar 11, 2016 at 4:47 AM, Shannon Ladymon <sl...@gmail.com> wrote:
> 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 <dm...@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 <dm...@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 <dm...@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
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
Re: SELECT without FROM
Posted by Shannon Ladymon <sl...@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 <mi...@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 <dm...@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 <dm...@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 <dm...@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
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>
Re: SELECT without FROM
Posted by Shannon Ladymon <sl...@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 <mi...@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 <dm...@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 <dm...@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 <dm...@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
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>
Re: SELECT without FROM
Posted by Mich Talebzadeh <mi...@gmail.com>.
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 <dm...@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 <dm...@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 <dm...@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
>>>>>
>>>>
>>>>
>>>
>>
>
Re: SELECT without FROM
Posted by Dmitry Tolpeko <dm...@gmail.com>.
Not sure. It does not work in my Hive 0.13 version.
On Wed, Mar 9, 2016 at 1:06 PM, Mich Talebzadeh <mi...@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 <dm...@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 <dm...@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
>>>>
>>>
>>>
>>
>
Re: SELECT without FROM
Posted by Dmitry Tolpeko <dm...@gmail.com>.
Not sure. It does not work in my Hive 0.13 version.
On Wed, Mar 9, 2016 at 1:06 PM, Mich Talebzadeh <mi...@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 <dm...@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 <dm...@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
>>>>
>>>
>>>
>>
>
Re: SELECT without FROM
Posted by Mich Talebzadeh <mi...@gmail.com>.
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 <dm...@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 <dm...@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
>>>
>>
>>
>
Re: SELECT without FROM
Posted by Dmitry Tolpeko <dm...@gmail.com>.
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 <mi...@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 <dm...@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
>>
>
>
Re: SELECT without FROM
Posted by Dmitry Tolpeko <dm...@gmail.com>.
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 <mi...@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 <dm...@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
>>
>
>
Re: SELECT without FROM
Posted by Mich Talebzadeh <mi...@gmail.com>.
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 <dm...@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
>