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
