---------
>>>>>> Adaptive Server Enterprise/15.7/EBF 21708 SMP SP110
>>>>>> /P/x86_64/Enterprise
>>>>>>
>>>>>> -----------
>>>
--
>>>>> 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
>>>>>
>
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/confluen
try Tolpeko 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.apac
--
>>>2
>>>
>>>
>>> Dr Mich Talebzadeh
>>>
>>>
>>>
>>> LinkedIn *
>>> https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>>> <https://www.linkedin.com/profile/view?id=AAEWh
8Pw
> <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>
>
>
> http://talebzadehmich.wordpress.com
>
>
>
> On 9 March 2016 at 09:50, Dmitry Tolpeko wrote:
>
>> I noticed that Hive allows you to execute SELECT without FROM clause
&g
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
r. I expect people to like it if it
is added to Hive.
> SELECT without FROM should assume a one-row table with no columns.
> --
>
> Key: HIVE-178
> URL: https://issues.apache.org/j
approach - since the {{VALUES(...)}}
syntax isn't yet supported in Hive, one can do something like this:
{code}
CREATE TABLE dual (dummy STRING);
INSERT INTO TABLE dual SELECT count(*) FROM dual;
{code}
Then {{SELECT ... FROM dual;}} queries work as expected.
> SELECT without FROM should
hat the data needn't be
queried...the only relevant info from the table would be the number of rows it
has, which is available for free from the metastore.
> SELECT without FROM should assume a one-row table with no columns.
> ---
ata is being pulled
from it (as we see from the SELECT statement, that table's name or alias does
not appear).
Summary: SELECT without FROM should assume a one-row table with no
columns. (was: SELECT without FROM; dropping unnecessary table references)
> SELECT without FROM s
12 matches
Mail list logo
