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 > (thanks Alan Gates to > pointing us to the grammar file and Sushanth Sowyman for helping track this

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 >

Re: SELECT without FROM

It looks like FROM was made optional in Hive 0.13.0 with 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

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 * http://talebzadehmich.

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 >

Re: SELECT without FROM

I believe it has always been there Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * http://talebzadehmich.wordpress.com On 9 March 2016 at 09:

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

Re: SELECT without FROM

ASAIK any database does that! 1> set nocount on 2> select @@version 3> select 1 + 1 4> go