RE: Create table as select

2013-10-16 Thread Adline Dsilva
sec Sorry for the trouble Regards, Adline From: Adline Dsilva Sent: 16 October 2013 15:24 To: David Morel; user@hive.apache.org Subject: RE: Create table as select Limit clause is creating the problem, hive> create TABLE tmp_table AS select * from user

RE: Create table as select

2013-10-16 Thread Adline Dsilva
oop with a BI tool, which creates temp tables. Without limit, huge data will roast BI :-) Regards, Adline From: David Morel [dmo...@amakuru.net] Sent: 16 October 2013 15:05 To: Adline Dsilva; user@hive.apache.org Subject: Re: Create table as select On 16

Re: Create table as select

2013-10-15 Thread Nitin Pawar
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