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 <dmtolp...@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.talebza...@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 <dmtolp...@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.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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >>>> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* >>>> >>>> >>>> >>>> http://talebzadehmich.wordpress.com >>>> >>>> >>>> >>>> On 9 March 2016 at 09:50, Dmitry Tolpeko <dmtolp...@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 >>>>> >>>> >>>> >>> >> >
