Here's more information about configuring for transactions: Hive
Transactions -- Configuration
<https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-Configuration>
.
-- Lefty
On Tue, Nov 4, 2014 at 4:19 AM, mahesh kumar <sankarmahes...@gmail.com>
wrote:
> Hi,
> Finally i updated and deleted from hive table.we need to create table
> with transactional = true like following.
>
> create table test(id int, name varchar(128)) clustered by (id) into 2
> buckets stored as orc TBLPROPERTIES ('transactional'='true')
> insert into table test values(1,'Mahesh');
> update test set name='Raj' where id=1;
> delete from test where name='Raj';
>
> Cheers,
>
> Mahesh.S
>
>
> On Tue, Nov 4, 2014 at 1:52 PM, mahesh kumar <sankarmahes...@gmail.com>
> wrote:
>
>> Hi Nitin,
>> I created table with ORC format when i update it shows the
>> following error.
>> CREATE TABLE students (name VARCHAR(64), age INT, gpa DECIMAL(3, 2))
>> CLUSTERED BY (age) INTO 2 BUCKETS STORED AS ORC;
>>
>> INSERT INTO TABLE students VALUES ('fred flintstone', 35, 1.28), ('barney
>> rubble', 32, 2.32);
>>
>> hive> update students set age='12' where name='barney rubble';
>>
>> FAILED: SemanticException [Error 10122]: Bucketized tables do not support
>> INSERT INTO: Table: default.students
>>
>> Thanks,
>> Mahesh.S
>>
>>
>> On Tue, Nov 4, 2014 at 1:28 PM, Nitin Pawar <nitinpawar...@gmail.com>
>> wrote:
>>
>>> 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
>>>
>>
>>
>
