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 <alanfga...@gmail.com> wrote: > 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 <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 > >
