currently only ORCFileformat is supports ACIDOutputformat
So you may want to create a table with orcfile format and see if you are
able to do acid opertaions.
On Tue, Nov 4, 2014 at 1:14 PM, mahesh kumar <sankarmahes...@gmail.com>
wrote:
> 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
>>
>
>
--
Nitin Pawar
