hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <nitinpawar...@gmail.com>
Subject Re: Hive 0.14 configuration
Date Tue, 04 Nov 2014 06:51:34 GMT
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