Re: SELECT without FROM
Thank you, Shannon! On Fri, Mar 11, 2016 at 4:47 AM, Shannon Ladymon 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 > 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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >> <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* >> >> >> >> http://talebzadehmich.wordpress.com >> >> >> >> On 9 March 2016 at 10:08, Dmitry Tolpeko 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.talebza...@gmail.com> wrote: >>> >>>> I believe it has always been there >>>> >>>> Dr Mich Talebzadeh >>>> >>>> >>>> >>>> LinkedIn * >>>> https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >>>> <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* >>>> >>>> >>>> >>>> http://talebzadehmich.wordpress.com >>>> >>>> >>>> >>>> On 9 March 2016 at 09:58, Dmitry Tolpeko 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.talebza...@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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >>>>>> <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* >>>>>> >>>>>> >>>>>> >>>>>> http://talebzadehmich.wordpress.com >>>>>> >>>>>> >>>>>> >>>>>> On 9 March 2016 at 09:50, Dmitry Tolpeko 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
>> 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 : > 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 > 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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >> <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* >> >> >> >> http://talebzadehmich.wordpress.com >> >> >> >> On 9 March 2016 at 10:08, Dmitry Tolpeko 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.talebza...@gmail.com> wrote: >>> >>>> I believe it has always been there >>>> >>>> Dr Mich Talebzadeh >>>> >>>> >>>> >>>> LinkedIn * >>>> https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >>>> <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* >>>> >>>> >>>> >>>> http://talebzadehmich.wordpress.com >>>> >>>> >>>> >>>> On 9 March 2016 at 09:58, Dmitry Tolpeko 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.talebza...@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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >>>>>> <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* >>>>>> >>>>>> >>>>>> >>>>>> http://talebzadehmich.wordpress.com >>>>>> >>>>>> >>>>>> >>>>>> On 9 March 2016 at 09:50, Dmitry Tolpeko 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
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 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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* > > > > http://talebzadehmich.wordpress.com > > > > On 9 March 2016 at 10:08, Dmitry Tolpeko 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.talebza...@gmail.com> wrote: >> >>> I believe it has always been there >>> >>> Dr Mich Talebzadeh >>> >>> >>> >>> LinkedIn * >>> https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >>> <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* >>> >>> >>> >>> http://talebzadehmich.wordpress.com >>> >>> >>> >>> On 9 March 2016 at 09:58, Dmitry Tolpeko 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.talebza...@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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >>>>> <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* >>>>> >>>>> >>>>> >>>>> http://talebzadehmich.wordpress.com >>>>> >>>>> >>>>> >>>>> On 9 March 2016 at 09:50, Dmitry Tolpeko 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
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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* http://talebzadehmich.wordpress.com On 9 March 2016 at 10:08, Dmitry Tolpeko wrote: > Not sure. It does not work in my Hive 0.13 version. > > On Wed, Mar 9, 2016 at 1:06 PM, Mich Talebzadeh > wrote: > >> I believe it has always been there >> >> Dr Mich Talebzadeh >> >> >> >> LinkedIn * >> https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >> <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* >> >> >> >> http://talebzadehmich.wordpress.com >> >> >> >> On 9 March 2016 at 09:58, Dmitry Tolpeko 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.talebza...@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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >>>> <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* >>>> >>>> >>>> >>>> http://talebzadehmich.wordpress.com >>>> >>>> >>>> >>>> On 9 March 2016 at 09:50, Dmitry Tolpeko 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
Not sure. It does not work in my Hive 0.13 version. On Wed, Mar 9, 2016 at 1:06 PM, Mich Talebzadeh wrote: > I believe it has always been there > > Dr Mich Talebzadeh > > > > LinkedIn * > https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* > > > > http://talebzadehmich.wordpress.com > > > > On 9 March 2016 at 09:58, Dmitry Tolpeko 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.talebza...@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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >>> <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* >>> >>> >>> >>> http://talebzadehmich.wordpress.com >>> >>> >>> >>> On 9 March 2016 at 09:50, Dmitry Tolpeko 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
I believe it has always been there Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* http://talebzadehmich.wordpress.com On 9 March 2016 at 09:58, Dmitry Tolpeko 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.talebza...@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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* >> >> >> >> http://talebzadehmich.wordpress.com >> >> >> >> On 9 March 2016 at 09:50, Dmitry Tolpeko 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
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 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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* > > > > http://talebzadehmich.wordpress.com > > > > On 9 March 2016 at 09:50, Dmitry Tolpeko 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
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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* http://talebzadehmich.wordpress.com On 9 March 2016 at 09:50, Dmitry Tolpeko 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 >
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