Hive 0.12 is just released today and I still have not got my hands on it.
But the query you are trying works on hive-0.11
Hive dev team works extremely hard to keep backward compatibility so it
should work on hive-0.12
If you face any issues do file a JIRA :)
On Wed, Oct 16, 2013 at 11:18 AM, A
Hi All,
Does hive (0.12) support sql statement "create TABLE tmp_table AS select *
from user_table limit 500". Currently I'm running 0.10 version, where its not
supported.
Regards,
Adline
The Apache Hive team is proud to announce the the release of Apache
Hive version 0.12.0. The Apache Hive (TM) data warehouse software
facilitates querying and
managing large datasets residing in distributed storage. Built on top
of Apache Hadoop (TM), it provides:
* Tools to enable easy data extrac
hive-variables are interpreted by the CLI before the query parser. If your
using hive 0.8. you should upgrade. You can benefit hive's macro system.
On Tue, Oct 15, 2013 at 5:49 AM, Ed Soniat wrote:
> Hive variables do not seem to be evaluated by the assigned expression, so
> they seem to be ma
Hive variables do not seem to be evaluated by the assigned expression, so
they seem to be macros not variables.
Let us say I want to have a variable called secondsInADay and for clarity
set it thus set secondsInADay=24*60*60;
To the best of my ability to determine secondsInADay will perform the
