Hi, Then is there any way to achieve this?
*Thanks & Regards,* *Srinivas T* On Fri, Feb 27, 2015 at 9:53 AM, Siddharth Tiwari <siddharth.tiw...@live.com > wrote: > Not yet ! > > Sent from my iPhone > > On Feb 26, 2015, at 8:23 PM, Srinivas Thunga <srinivas.thu...@gmail.com> > 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, Alan Gates <alanfga...@gmail.com> wrote: > >> 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. >> >> <compose-unknown-contact.jpg> >> Srinivas Thunga <srinivas.thu...@gmail.com> >> February 26, 2015 at 4:34 >> 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* >> >> >
