Return-Path: X-Original-To: apmail-hadoop-hdfs-user-archive@minotaur.apache.org Delivered-To: apmail-hadoop-hdfs-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 45FD9C35E for ; Tue, 18 Nov 2014 13:58:23 +0000 (UTC) Received: (qmail 32277 invoked by uid 500); 18 Nov 2014 13:58:18 -0000 Delivered-To: apmail-hadoop-hdfs-user-archive@hadoop.apache.org Received: (qmail 32134 invoked by uid 500); 18 Nov 2014 13:58:18 -0000 Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hadoop.apache.org Delivered-To: mailing list user@hadoop.apache.org Received: (qmail 32124 invoked by uid 99); 18 Nov 2014 13:58:18 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Nov 2014 13:58:18 +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.223.174 as permitted sender) Received: from [209.85.223.174] (HELO mail-ie0-f174.google.com) (209.85.223.174) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Nov 2014 13:58:13 +0000 Received: by mail-ie0-f174.google.com with SMTP id rl12so3566169iec.33 for ; Tue, 18 Nov 2014 05:57:53 -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=8jGCNgwMLanLZaspbVWZj8WzY6SCXEi2lAqxsux9gqk=; b=I7VDuKUZ/dAhVbypaAPbTJITlpWMlfWc6U9D4Mt6KBSHoB07ztcZycW/si9qdpRMdg N6TSbTjMQwGGwGA545+JSd/1VihxfaVpTJtG+URP9jKnuJ7IH2/T93jds11G/VTEchqx UdbuIET52h4XqPU2lXNBidYiGALdqIkx/asqzHcHrGow+UXhAo2VQCAoePR5aO+C6j1v 5vj5ryJJuveswnwYGiaVdqQDY8wu6gfjYlwc8y7iG1XwMyfvh/+sW5rHk74OJmwYHFNx DPSghf/kfkOITUJ4FXLC/3130uKmRWIibmbwdqDMJCQa6ezgr8HCl8VIVDGlGxTz4blG lMMA== MIME-Version: 1.0 X-Received: by 10.42.204.81 with SMTP id fl17mr3553325icb.57.1416319072982; Tue, 18 Nov 2014 05:57:52 -0800 (PST) Received: by 10.107.134.145 with HTTP; Tue, 18 Nov 2014 05:57:47 -0800 (PST) Received: by 10.107.134.145 with HTTP; Tue, 18 Nov 2014 05:57:47 -0800 (PST) In-Reply-To: References: Date: Tue, 18 Nov 2014 19:27:47 +0530 Message-ID: Subject: Re: Fwd: Values getting duplicated in Hive table(Partitioned) From: unmesha sreeveni To: hadoophive@gmail.com, User Hadoop Content-Type: multipart/alternative; boundary=20cf303dd6a03bdc560508227b48 X-Virus-Checked: Checked by ClamAV on apache.org --20cf303dd6a03bdc560508227b48 Content-Type: text/plain; charset=UTF-8 Thanks it worked. On Nov 17, 2014 3:32 PM, "unmesha sreeveni" wrote: > > ---------- Forwarded message ---------- > From: unmesha sreeveni > Date: Mon, Nov 17, 2014 at 10:49 AM > Subject: Re: Values getting duplicated in Hive table(Partitioned) > To: User - Hive > > > In non partitioned table I am getting the correct values. > > Is my update query wrong? > > 1. INSERT OVERWRITE TABLE Unm_Parti_Trail PARTITION (Department = 'A') > SELECT employeeid,firstname,designation, CASE WHEN employeeid=19 THEN > '50000 ELSE salary END AS salary FROM Unm_Parti_Trail; > > What I tried to include in the query is , In partion with department = A, > update employeeid =19 's salary with 50000 > > Is that query statement wrong? and the replication is not affected to dept > B and C. > -- > *Thanks & Regards * > > > *Unmesha Sreeveni U.B* > *Hadoop, Bigdata Developer* > *Centre for Cyber Security | Amrita Vishwa Vidyapeetham* > http://www.unmeshasreeveni.blogspot.in/ > > > > > > -- > *Thanks & Regards * > > > *Unmesha Sreeveni U.B* > *Hadoop, Bigdata Developer* > *Centre for Cyber Security | Amrita Vishwa Vidyapeetham* > http://www.unmeshasreeveni.blogspot.in/ > > > --20cf303dd6a03bdc560508227b48 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Thanks it worked.

On Nov 17, 2014 3:32 PM, "unmesha sreeveni&= quot; <unmeshabiju@gmail.com> wrote:

---------- Forwarded message ----= ------
From: unmesha sreeveni <un= meshabiju@gmail.com>
Date: Mon, Nov 17, 2014 at 10:49 AMSubject: Re: Values getting duplicated in Hive table(Partitioned)
To: = User - Hive <u= ser@hive.apache.org>


In non partitioned table I am getting the correc= t values.

Is my update query wrong?
  1. INSERT OVERWRITE TABLE Unm_Parti_Trail P= ARTITION (Department =3D 'A') SELECT employeeid,firstname,designati= on, CASE WHEN employeeid=3D19 THEN '50000 ELSE salary END AS salary FRO= M Unm_Parti_Trail;
What I tried to include in the query is , In = partion with department =3D A, update employeeid =3D19 's salary with 5= 0000

Is that query statement wrong? and = the replication is not affected to dept B and C.
<= span>
--=C2=A0
Thanks & Regards

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




--
Thanks & Regards

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

--20cf303dd6a03bdc560508227b48--