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 >>>> >>> >>> >> >