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, Adline Dsilva <[EMAIL PROTECTED]>wrote:
> 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.