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