hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dmitry Tolpeko <dmtolp...@gmail.com>
Subject Re: SELECT without FROM
Date Wed, 09 Mar 2016 16:45:44 GMT
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 <alanfgates@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 <dmtolpeko@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
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message