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

Thanks, Alan. We should document this as well, now the syntax at https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select states that FROM is mandatory. Dmitry On Wed, Mar 9, 2016 at 6:46 PM, Alan Gates wrote: > I’m not aware of any JIRA on it. The easiest way to find out will be

Re: SELECT without FROM

I’m not aware of any JIRA on it. The easiest way to find out will be to look at the git history of Hive’s grammar file and see when it changed. As for taking out, we shouldn’t since it’s valid SQL and we’re pushing towards more ANSI compliance. Alan. > On Mar 9, 2016, at 01:50, Dmitry Tolpeko

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

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