hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Siddharth Tiwari <siddharth.tiw...@live.com>
Subject Re: column selection for insert
Date Fri, 27 Feb 2015 04:23:56 GMT
Not yet ! 

Sent from my iPhone

> On Feb 26, 2015, at 8:23 PM, Srinivas Thunga <srinivas.thunga@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 <alanfgates@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
> 

Mime
View raw message