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 <nitinpawar...@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 <sankarmahes...@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
>
