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.talebza...@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 <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 >>>>>> >>>>> >>>>> >>>> >>> >> >
