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. > > 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* > >