hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Srinivas Thunga <srinivas.thu...@gmail.com>
Subject Re: column selection for insert
Date Fri, 27 Feb 2015 04:28:57 GMT
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.tiwari@live.com
> wrote:

> 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 <srinivas.thunga@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*
>>
>>
>

Mime
View raw message