I believe it has always been there


On 9 March 2016 at 09:58, Dmitry Tolpeko <dmtolpeko@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.talebzadeh@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



On 9 March 2016 at 09: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