Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 6FE5C17AC5 for ; Tue, 4 Nov 2014 08:23:11 +0000 (UTC) Received: (qmail 16075 invoked by uid 500); 4 Nov 2014 08:23:10 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 16012 invoked by uid 500); 4 Nov 2014 08:23:09 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 16002 invoked by uid 99); 4 Nov 2014 08:23:09 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Nov 2014 08:23:09 +0000 X-ASF-Spam-Status: No, hits=1.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of sankarmahesh37@gmail.com designates 209.85.212.181 as permitted sender) Received: from [209.85.212.181] (HELO mail-wi0-f181.google.com) (209.85.212.181) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Nov 2014 08:22:41 +0000 Received: by mail-wi0-f181.google.com with SMTP id n3so8543485wiv.8 for ; Tue, 04 Nov 2014 00:22:41 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=sjeR0omIhSEciJSKrKdZkoouvpMaulWbe7aPSYJdtJM=; b=B3CpdxoCDzioJo6cV5uogAEzrak/93aX4uafbSpa0a0ohn5iQ1gvOxi0W9SNsXL8Da xpv0oriFIMY8VMUqXj7bOxpcqUwGAdXMAVRqEzzmxSWKYDmMdzi1EYYDQebJUIYlVrCT Mep62dKrjmVk1LO4Y2xKnfvVWD9cDzTx4ic7cY9FeLHH/AhjfkOHumYNC9vAEkIkZqXu Fxtw3Wkb8mPAxmjzsTa3D+qzozrj/KzaQ/S+03pa1n9hdxjc9WHeqr1KCq8toGuxk4Xe FVOAbnofxBDKB0wWT1rJhkSjHcr5nwsGDYaLEdvRPo9yoYLuZHgrsnCFPxiit3k9QGSE 7y3g== MIME-Version: 1.0 X-Received: by 10.180.9.103 with SMTP id y7mr22766632wia.5.1415089360930; Tue, 04 Nov 2014 00:22:40 -0800 (PST) Received: by 10.194.32.68 with HTTP; Tue, 4 Nov 2014 00:22:40 -0800 (PST) In-Reply-To: References: Date: Tue, 4 Nov 2014 13:52:40 +0530 Message-ID: Subject: Re: Hive 0.14 configuration From: mahesh kumar To: user@hive.apache.org Content-Type: multipart/alternative; boundary=001a11c238b8af0dc70507042ad8 X-Virus-Checked: Checked by ClamAV on apache.org --001a11c238b8af0dc70507042ad8 Content-Type: text/plain; charset=UTF-8 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 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 > 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 >> 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 >>> 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 > --001a11c238b8af0dc70507042ad8 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Nitin,
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0I c= reated 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;
=C2=A0
INSERT INTO TABLE students VALUES ('fred flintstone', 35, 1= .28), ('barney rubble', 32, 2.32);

<= div>hive> update students set age=3D'12' where name=3D'barne= y rubble'; =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0=C2=A0
FAILED: SemanticException [Error 10122]: Buck= etized tables do not support INSERT INTO: Table: default.students

Thanks,
Mahesh.S

=

On Tue, Nov 4, 20= 14 at 1:28 PM, Nitin Pawar <nitinpawar432@gmail.com> w= rote:
currently only ORC= Fileformat is supports ACIDOutputformat

So you may want = to create a table with orcfile format and see if you are able to do acid op= ertaions.=C2=A0



On Tue, Nov = 4, 2014 at 1:14 PM, mahesh kumar <sankarmahesh37@gmail.com><= /span> wrote:
Hi Nitin,<= div>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0how to c= reate 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 AcidOutPutForm= at or table needs to be bucketed to perform update operation.=C2=A0
You may want to create a new table from your existing table wit= h AcidOutPutFormat and insert data from current table to that table and the= n try update op on new table=C2=A0

On Tue, Nov 4, 2014 at 12:11 PM, mah= esh kumar <sankarmahesh37@gmail.com> wrote:
Hi ,
=C2=A0 =C2=A0= =C2=A0 =C2=A0Is anyone tried hive 0.14 configuration.I built it using mave= n from github.
Insert is working fine but when i use update/delet= e i got the =C2=A0error.First i created table and inserted rows.
=
CREATE =C2=A0TABLE new(id int ,name string)ROW FORMAT DELIMI= TED FIELDS TERMINATED BY ',';
=C2=A0insert into table new= values ('1','Mahesh');=C2=A0

upda= te new set name=3D'Raj' where id=3D1;

FAIL= ED: SemanticException [Error 10297]: Attempt to do update or delete on tabl= e default.new that does not use an AcidOutputFormat or is not bucketed.

When i update the table i got the above error.=C2=A0<= /div>

Can you help me guys.

Tha= nks

Mahesh.S=C2=A0






<= font color=3D"#888888">--
Nitin Pawar




<= /div>--
Nitin Pawar=

--001a11c238b8af0dc70507042ad8--