hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mahesh kumar <sankarmahes...@gmail.com>
Subject Re: Hive 0.14 configuration
Date Tue, 04 Nov 2014 08:22:40 GMT
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 <nitinpawar432@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 <sankarmahesh37@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 <nitinpawar432@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 <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
>>>
>>
>>
>
>
> --
> Nitin Pawar
>

Mime
View raw message