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 B7C7A101DA for ; Thu, 27 Nov 2014 10:43:09 +0000 (UTC) Received: (qmail 58223 invoked by uid 500); 27 Nov 2014 10:43:03 -0000 Delivered-To: apmail-hadoop-common-user-archive@hadoop.apache.org Received: (qmail 58108 invoked by uid 500); 27 Nov 2014 10:43:03 -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 58098 invoked by uid 99); 27 Nov 2014 10:43:02 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Nov 2014 10:43:02 +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 (nike.apache.org: domain of unmeshabiju@gmail.com designates 209.85.223.180 as permitted sender) Received: from [209.85.223.180] (HELO mail-ie0-f180.google.com) (209.85.223.180) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Nov 2014 10:42:36 +0000 Received: by mail-ie0-f180.google.com with SMTP id rp18so4358274iec.11 for ; Thu, 27 Nov 2014 02:41: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=jkK2uXO/PVIkGdcXFjnfdx2+PAyzJzXuXiOe1Zi+D8c=; b=gFLVFAc4sYjiPQHNjHZ2JFBudbpNqNbL72jrhjMwQflRwNvbuEfO2OULRtjZCoaRrp U/wDS6iRxh5h6a0WMBXXzA9up5wXqEeYvzmfFOdej6UP5l7+B8oC+w4AxCS5Oou3ZcF2 dJtA/93pu7MDif3or0QDyXHu5YNd4gYKlGXMDJJDV+nyLmPtZ28N3DbXoCT8guX4Uz84 5myIoIcfOhmccC3+G96IS2zbO2DwmqTdBiL+M0G8TU2j3yCqIuHPtNtet27E0Waohkpm e0geuZAYIurXSanxvpBaUkWlFhJC4Zgh07cfYGS2M/MvK1+Aj4Q/AbBXNpchm4YWcha3 DSfQ== X-Received: by 10.43.132.137 with SMTP id hu9mr36843559icc.27.1417084910800; Thu, 27 Nov 2014 02:41:50 -0800 (PST) MIME-Version: 1.0 Received: by 10.107.134.145 with HTTP; Thu, 27 Nov 2014 02:41:10 -0800 (PST) From: unmesha sreeveni Date: Thu, 27 Nov 2014 16:11:10 +0530 Message-ID: Subject: Detailing on how UPDATE is performed in Hive To: User - Hive , User Hadoop Content-Type: multipart/alternative; boundary=20cf307f3adcb9963f0508d4ca46 X-Virus-Checked: Checked by ClamAV on apache.org --20cf307f3adcb9963f0508d4ca46 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi friends Where can I find details on how update is performed in Hive. =E2=80=8B1. When an update is performed,whether HDFS will write that block elsewhere with the new value. 2. whether the old block is unallocated and is allowed for further writes. 3. Whether this process create fragmentation ? 4. while creating a partitioned table, and update is performed ,whether the partition is deleted and updated with new value or the entire block is deleted and written once again? where will be the good place to gather these knowlege=E2=80=8B --=20 *Thanks & Regards * *Unmesha Sreeveni U.B* *Hadoop, Bigdata Developer* *Centre for Cyber Security | Amrita Vishwa Vidyapeetham* http://www.unmeshasreeveni.blogspot.in/ --20cf307f3adcb9963f0508d4ca46 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi friends
=C2=A0 Where can I find details on how update is per= formed in Hive.

=E2=80=8B1. When an update is performed,whether H= DFS will write that block elsewhere with the new value.=C2=A0
2. whether th= e old block is unallocated and is allowed for further writes.=C2=A0
3. Whet= her this process create fragmentation ?
4. while creating a partitioned tab= le, and update is performed ,whether the partition is deleted and updated w= ith new value or the entire block is deleted and written once again?
<= div class=3D"gmail_default" style=3D"font-family:verdana,sans-serif">
w= here will be the good place to gather these knowlege=E2=80=8B

--
Thanks & Regards

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

--20cf307f3adcb9963f0508d4ca46--