hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mahesh kumar <sankarmahes...@gmail.com>
Subject Re: Hive 0.14 configuration
Date Tue, 04 Nov 2014 07:44:35 GMT
Hi Nitin,

             how to create table with AcidOuptut Format.?Can you send me
examples.

Thanks
Mahesh

On Tue, Nov 4, 2014 at 12:21 PM, Nitin Pawar <nitinpawar432@gmail.com>
wrote:

> As the error says, your table file format has to be AcidOutPutFormat or
> table needs to be bucketed to perform update operation.
>
> You may want to create a new table from your existing table with
> AcidOutPutFormat and insert data from current table to that table and then
> try update op on new table
>
> On Tue, Nov 4, 2014 at 12:11 PM, mahesh kumar <sankarmahesh37@gmail.com>
> wrote:
>
>> Hi ,
>>        Is anyone tried hive 0.14 configuration.I built it using maven
>> from github.
>> Insert is working fine but when i use update/delete i got the
>>  error.First i created table and inserted rows.
>>
>> CREATE  TABLE new(id int ,name string)ROW FORMAT DELIMITED FIELDS
>> TERMINATED BY ',';
>>  insert into table new values ('1','Mahesh');
>>
>> update new set name='Raj' where id=1;
>>
>> FAILED: SemanticException [Error 10297]: Attempt to do update or delete
>> on table default.new that does not use an AcidOutputFormat or is not
>> bucketed.
>>
>> When i update the table i got the above error.
>>
>> Can you help me guys.
>>
>> Thanks
>>
>> Mahesh.S
>>
>>
>>
>>
>
>
> --
> Nitin Pawar
>

Mime
View raw message