Return-Path: X-Original-To: apmail-hadoop-common-user-archive@www.apache.org Delivered-To: apmail-hadoop-common-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 AE5BA107E2 for ; Mon, 17 Nov 2014 04:33:35 +0000 (UTC) Received: (qmail 56820 invoked by uid 500); 17 Nov 2014 04:33:30 -0000 Delivered-To: apmail-hadoop-common-user-archive@hadoop.apache.org Received: (qmail 56701 invoked by uid 500); 17 Nov 2014 04:33:30 -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 56691 invoked by uid 99); 17 Nov 2014 04:33:29 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Nov 2014 04:33:29 +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.181 as permitted sender) Received: from [209.85.223.181] (HELO mail-ie0-f181.google.com) (209.85.223.181) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Nov 2014 04:33:25 +0000 Received: by mail-ie0-f181.google.com with SMTP id tp5so1680299ieb.40 for ; Sun, 16 Nov 2014 20:30:50 -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=VE5QDE6S7yk5FRCEUoGTECAowU2or08sFPAqCZt7Fmk=; b=SN3APfqrjIxTYJrSCOGVQTxY7tZzngcyfEL65kThijxBvR3UgQVqHpG3mZAWk1vzwg n9c7atWdJBgtbdImw5qNrzk0KQM6G4lY/ncet3dJZr4o9TQfIexsogvwMm+mekYZVuzn +Aup3mBr/EcVN3IkRZgPmoisjdv5z/XLZ89ZOrGxYl3TO4MS+B/O9aoQfOGcYbjCRhYW gOsL9fhwIwzb44E4758OP5InsnCSgzHHAwCa3ppqMiYRAh1aLJlblkd0Kqiz9ynh3Loz 8uTs2lFAd7M5Hkf1n6S1P8O93Kp30M1DCQCqT0Zz0zzVlFjWpgHCRU5VNQEQyw64mXSk bxvg== X-Received: by 10.43.170.134 with SMTP id nq6mr25615151icc.30.1416198650278; Sun, 16 Nov 2014 20:30:50 -0800 (PST) MIME-Version: 1.0 Received: by 10.107.134.130 with HTTP; Sun, 16 Nov 2014 20:30:10 -0800 (PST) From: unmesha sreeveni Date: Mon, 17 Nov 2014 10:00:10 +0530 Message-ID: Subject: Values getting duplicated in Hive table(Partitioned) To: User - Hive , User Hadoop Content-Type: multipart/alternative; boundary=001a11c2e2227b37fa05080671ba X-Virus-Checked: Checked by ClamAV on apache.org --001a11c2e2227b37fa05080671ba Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I created a Hive table with *partition* and inserted data into Partioned Hive table. Refered site 1. *Initially created one Non -partioned table and then using select query and loaded data into partioned table. Is there an alternate way?* 2. *By following above link my partioned table contains duplicate values. Below are the setps* This is my Sample employee dataset:link1 I tried the following queries: link2 But after updating a value in Hive table,the values are getting duplicated. 7 Nirmal Tech 12000 A 7 Nirmal Tech 12000 B Nirmal is placed in Department *A* only =E2=80=8B,=E2=80=8B but it is duplicated to department *B*. And Once I update a column value in middle I am getting NULL values displayed,while updating last column it is fine. Am I doing any thing wrong. Please suggest.-- *Thanks & Regards * *Unmesha Sreeveni U.B* *Hadoop, Bigdata Developer* *Centre for Cyber Security | Amrita Vishwa Vidyapeetham* http://www.unmeshasreeveni.blogspot.in/ --001a11c2e2227b37fa05080671ba Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

I created a Hive table with=C2=A0partition=C2=A0and inserted data into Partio= ned Hive table.

Refered site<= /a>

  1. Initially created one Non= -partioned table and then using select query and loaded data into partione= d table. Is there an alternate way?

  2. = By following above link my partioned table contains duplicate values. Below= are the setps

This is my Sample employee dataset:link1

I tried the following queries:=C2=A0link2

But after updating a value i= n Hive table,the values are getting duplicated.

7       Nirmal  Tech    12000   A
7       Nirmal  Tech    12000   B

Nirmal is placed in Depar= tment=C2=A0A= =C2=A0only

=E2=80=8B,=E2=80=8B
but it is duplicated to d= epartment=C2=A0B.

And Once I update a column value in middle I am getting NULL valu= es displayed,while updating last column it is fine.

Am I doing any thing w= rong.

Please suggest.--=C2=A0
= Thanks & Regards

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

--001a11c2e2227b37fa05080671ba--