Re: column selection for insert

Hi, Then is there any way to achieve this? *Thanks & Regards,* *Srinivas T* On Fri, Feb 27, 2015 at 9:53 AM, Siddharth Tiwari wrote: > Not yet ! > > Sent from my iPhone > > On Feb 26, 2015, at 8:23 PM, Srinivas Thunga > wrote: > > Hi, > > Thanks for the prompt response. > > Cann't i insert

Re: column selection for insert

Not yet ! Sent from my iPhone > On Feb 26, 2015, at 8:23 PM, Srinivas Thunga > wrote: > > Hi, > > Thanks for the prompt response. > > Cann't i insert specific columns which i want? > > Like we do in oracle. > > Thanks & Regards, > > Srinivas T > >> On Thu, Feb 26, 2015 at 8:55 PM, Ala

Re: column selection for insert

Hi, Thanks for the prompt response. Cann't i insert specific columns which i want? Like we do in oracle. *Thanks & Regards,* *Srinivas T* On Thu, Feb 26, 2015 at 8:55 PM, Alan Gates wrote: > Specifying which columns in the target table to insert into (emp in your > case) is not supported in

Re: column selection for insert

Specifying which columns in the target table to insert into (emp in your case) is not supported in 0.14. You have to insert into all the columns in the table and they have to match the order of items in the select or values clause. This will be supported in 1.2. Alan. Srinivas Thunga

column selection for insert

Hi, I am using Hive 0.14 Can any one help me on to execute the below type query insert into table emp (eid,ename) select * from dept where emp.id = dept.id *Thanks & Regards,* *Srinivas T*