Return-Path: X-Original-To: apmail-hadoop-user-archive@minotaur.apache.org Delivered-To: apmail-hadoop-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 DB7D8105F6 for ; Thu, 27 Nov 2014 12:06:23 +0000 (UTC) Received: (qmail 49457 invoked by uid 500); 27 Nov 2014 12:06:19 -0000 Delivered-To: apmail-hadoop-user-archive@hadoop.apache.org Received: (qmail 49348 invoked by uid 500); 27 Nov 2014 12:06:19 -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 49338 invoked by uid 99); 27 Nov 2014 12:06:18 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Nov 2014 12:06:18 +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 (athena.apache.org: domain of nitinpawar432@gmail.com designates 209.85.213.53 as permitted sender) Received: from [209.85.213.53] (HELO mail-yh0-f53.google.com) (209.85.213.53) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Nov 2014 12:06:14 +0000 Received: by mail-yh0-f53.google.com with SMTP id i57so2194205yha.40 for ; Thu, 27 Nov 2014 04:05: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 :cc:content-type; bh=XB6JXD02vMgFLbArusIuasrudqDhEZwi9ucgFMUqQks=; b=RA9TZNTlHp/ude0TeJf3ikQ06KJ7FK5X2YXnrP6IVFZBp54a8X6Yj97o7GfIMnUQuY jbkRPHGtyBud71K/1ncWU5cVUzT6bbwnNVMlsUIZToLpKcNnD2KWSjwh0pSFYijzRsqK NpUyb1kvaeOlOCju7bSxwmWYQa3I01PreTu+xmd40SJ0w5jvfoZGdzFW9Dp1eij8ckBt zAbzhnXq+oFu5vNRQlrMGXm0O5FFkscdahVcAmiNADyuXwupvPUxEg/gv/UjpYxfUsPi yuuY5zLTP/40IFGC07ESd/990yjEtP+No0O4oDeEUyc8gk23QMUNvHYziyl9CzdI5ZQ4 hAPw== MIME-Version: 1.0 X-Received: by 10.236.207.8 with SMTP id m8mr37237627yho.2.1417089953311; Thu, 27 Nov 2014 04:05:53 -0800 (PST) Received: by 10.170.133.215 with HTTP; Thu, 27 Nov 2014 04:05:53 -0800 (PST) In-Reply-To: References: Date: Thu, 27 Nov 2014 17:35:53 +0530 Message-ID: Subject: Re: Detailing on how UPDATE is performed in Hive From: Nitin Pawar To: user@hadoop.apache.org Cc: User - Hive Content-Type: multipart/alternative; boundary=001a11c1f1264832d30508d5f7ae X-Virus-Checked: Checked by ClamAV on apache.org --001a11c1f1264832d30508d5f7ae Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions entire implementation is under jira here https://issues.apache.org/jira/browse/HIVE-5317 On Thu, Nov 27, 2014 at 4:11 PM, unmesha sreeveni wrote: > 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 bloc= k > 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 i= s > deleted and written once again? > > where 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 Vidyapeetham* > http://www.unmeshasreeveni.blogspot.in/ > > > --=20 Nitin Pawar --001a11c1f1264832d30508d5f7ae Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

On Thu, Nov 27, 2014 at 4:11 PM, = unmesha sreeveni <unmeshabiju@gmail.com> wrote:
Hi friends
=C2=A0 Where can I find de= tails on how update is performed in Hive.

=E2=80=8B1. When an upd= ate is performed,whether HDFS will write that block elsewhere with the new = value.=C2=A0
2. whether the old block is unallocated and is allowed for fur= ther writes.=C2=A0
3. Whether this process create fragmentation ?
4. while = creating a partitioned table, and update is performed ,whether the partitio= n 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 knowl= ege=E2=80=8B

--
Thanks &= amp; Regards

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




--
Nitin Pawar
--001a11c1f1264832d30508d5f7ae--