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 D2A63CF94 for ; Mon, 24 Nov 2014 08:13:16 +0000 (UTC) Received: (qmail 81030 invoked by uid 500); 24 Nov 2014 08:13:14 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 80961 invoked by uid 500); 24 Nov 2014 08:13:14 -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 80951 invoked by uid 99); 24 Nov 2014 08:13:14 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 24 Nov 2014 08:13:14 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of unmeshabiju@gmail.com designates 209.85.213.181 as permitted sender) Received: from [209.85.213.181] (HELO mail-ig0-f181.google.com) (209.85.213.181) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 24 Nov 2014 08:13:09 +0000 Received: by mail-ig0-f181.google.com with SMTP id l13so2937455iga.2 for ; Mon, 24 Nov 2014 00:11:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to:content-type; bh=wjQELFVtT2ovMtpuZmsXSuNX/4kbO1Pok38Rfzra8Tc=; b=ZlHPnjzYx4k7crOUCYYhUdhKQU1a8ikaPMZr4dNhhLzSRXfTmbIXCUWAJJxFFbRwGX 3NtnCD88ms6U5jPNbmwCouU7ndFv0fl7CHozHKAA4vd6+qKXMaZoaa6dLej/mtgWRAJJ cI2Fh9NbGhHnDwygJRCZebb4csa0L5ezaaS6OCK5TAGf/J1CZDYBlzV1UIYSabjRvvef CzVDl1iHGjZq+AzprHAWSzfoO6spao4r8xqKvTmr0b7iQegU6oCJDC2rbTv+Vnhcep1V 9ashPFIWEoj8CKFtUSVVQaCxR9bL7jZo2fCKQr+HiccIXEk7v+FnGWoRIGUTBJdEjmlU Iw9g== X-Received: by 10.50.96.17 with SMTP id do17mr10168585igb.44.1416816663528; Mon, 24 Nov 2014 00:11:03 -0800 (PST) MIME-Version: 1.0 Received: by 10.107.134.145 with HTTP; Mon, 24 Nov 2014 00:10:23 -0800 (PST) From: unmesha sreeveni Date: Mon, 24 Nov 2014 13:40:23 +0530 Message-ID: Subject: UPDATE in Hive -0.14.0 To: User - Hive Content-Type: multipart/alternative; boundary=047d7bd6b856f10e6c05089655be X-Virus-Checked: Checked by ClamAV on apache.org --047d7bd6b856f10e6c05089655be Content-Type: text/plain; charset=UTF-8 Hi I am using hive -0.14.0 which support UPDATE statement but I am getting an error once I did this Command UPDATE Emp SET salary = 50000 WHERE employeeid = 19; FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations. hive> Am I doing anything wrong? -- *Thanks & Regards * *Unmesha Sreeveni U.B* *Hadoop, Bigdata Developer* *Centre for Cyber Security | Amrita Vishwa Vidyapeetham* http://www.unmeshasreeveni.blogspot.in/ --047d7bd6b856f10e6c05089655be Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi

I am using hive -0.14.0 which support UPDATE statement<= /div>
=
but I am getting an error once I did this Command
UPDATE Emp SET salar= y =3D 50000 WHERE employeeid =3D 19;

FAILED: SemanticException [Error 1029= 4]: Attempt to do update or delete using transaction manager that does not = support these operations.
hive>=C2=A0


Am I doing anything wrong?

--
Thanks & Regards

Unmesha Sreeveni U.B
Hadoop, Bigdata Developer
=
Centre for Cyber Security | Amrita Vishwa V= idyapeetham
=

--047d7bd6b856f10e6c05089655be--