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