Return-Path: X-Original-To: apmail-hbase-user-archive@www.apache.org Delivered-To: apmail-hbase-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 8BED718BE0 for ; Wed, 20 Jan 2016 11:24:59 +0000 (UTC) Received: (qmail 89960 invoked by uid 500); 20 Jan 2016 11:24:57 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 89886 invoked by uid 500); 20 Jan 2016 11:24:57 -0000 Mailing-List: contact user-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hbase.apache.org Delivered-To: mailing list user@hbase.apache.org Received: (qmail 89873 invoked by uid 99); 20 Jan 2016 11:24:57 -0000 Received: from Unknown (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 20 Jan 2016 11:24:57 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 091381A0A14 for ; Wed, 20 Jan 2016 11:24:57 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.898 X-Spam-Level: ** X-Spam-Status: No, score=2.898 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-eu-west.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id ND6HwHleVpNj for ; Wed, 20 Jan 2016 11:24:55 +0000 (UTC) Received: from mail-yk0-f176.google.com (mail-yk0-f176.google.com [209.85.160.176]) by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with ESMTPS id 1C0D42565F for ; Wed, 20 Jan 2016 11:24:55 +0000 (UTC) Received: by mail-yk0-f176.google.com with SMTP id x67so5767643ykd.2 for ; Wed, 20 Jan 2016 03:24:55 -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=euDZT3wEI5Ide5BnqmX7npOwpcPi9qy6cAquqbNOYBQ=; b=jL25TvlaIL3Uods390vZXfWK2JRXOpLLjXIDQ3WmzSJPlq0ksyriG6aZPtXZJNcn0l nGUMqw9y8uz7MmTj/xZahnpEx1Fa/qRdcSvBhJ/91l2+m44vfVuM4XET8B7GS8KIvAcu veCEltOnY54AD/pPjpYf42GBsa09j5toLaWwKCZ74hNIt/7xlASXPc78R01cHvYGs5xa dgP1H/mCeBkpJ+Uk0pdxTIzX/ggxVj4a6CPcPY/e/hM1VCVX908RDOdTZ5Z2+7fcRjMW Ojjpy1nKLJrbQcbPLLmF8r5rTnGBOi4nm/2iNKmnPEXRbukjt6xpfUE1465DAFCplX8p MNYg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc:content-type; bh=euDZT3wEI5Ide5BnqmX7npOwpcPi9qy6cAquqbNOYBQ=; b=CSw1VJknL6vFDhPXfu/cJb6xJcD8EK9Q/MkPJWy5Fg+GB57wtUskOg2crYyM/XIvSE zw5GtCw/gVsNEKID3jb7Px7VpYWrf4AZkVeiyEU+JqWXKtdvBxZy0GI/waSzysgyAG3m m5FfvhyiymEv5nNir7AWCl1GSiA5UM+DSzSWCzx1EK77iPRi43Vb+kRBiWMuL8n34J+p oRTc/VtNgctYu+ubNAqfKxcN8OHgmzajUxXV+iEfH7REUddHAc3yaazA4dk9eGgNrewi sVTUaW2kCV3JyevL0rkkVcTPHD4c+vdSDpU7WMY7dtSDNAEqWS0IxzZoE1IwWol4gcHS VDoA== X-Gm-Message-State: ALoCoQlUsw3qmgABrFeGSQ+eVdDgF6u7Y5su/+w/sdP791wNFNFBIpViB7sx72tXGSnSD7F+aycnAczGb2bI69amrTGNUKug7Q== MIME-Version: 1.0 X-Received: by 10.37.230.198 with SMTP id d189mr10841237ybh.74.1453289094106; Wed, 20 Jan 2016 03:24:54 -0800 (PST) Received: by 10.37.207.5 with HTTP; Wed, 20 Jan 2016 03:24:54 -0800 (PST) In-Reply-To: References: <329954765.8548713.1453272661102.JavaMail.yahoo.ref@mail.yahoo.com> <329954765.8548713.1453272661102.JavaMail.yahoo@mail.yahoo.com> Date: Wed, 20 Jan 2016 03:24:54 -0800 Message-ID: Subject: Re: Table copies in hbase From: Ted Yu To: "user@hbase.apache.org" Cc: Sumit Nigam Content-Type: multipart/alternative; boundary=94eb2c0a8d2c35d8370529c23cf2 --94eb2c0a8d2c35d8370529c23cf2 Content-Type: text/plain; charset=UTF-8 There is also backup / restore (work in progress): https://issues.apache.org/jira/browse/HBASE-7912 FYI On Wed, Jan 20, 2016 at 2:12 AM, Samir Ahmic wrote: > Hi Sumit, > IMHO snapshots are easiest way to copy tables you need just to steps: > > 1. create snapshot > 2. clone snapshot to another table > > What version of hbase you are using? Regarding you question what will > happen in case operation fails in case of cloning snapshot i have never > experience such event if snapshot was not corrupted. In case of CopyTable > mr i assume that data will be partially copied. In any case your source > tables will be OK. > > > Regards > Samir > > On Wed, Jan 20, 2016 at 7:51 AM, Sumit Nigam > > wrote: > > > Hi, > > I have a a few tables in hbase which I would like to create copies of. > The > > tables will be in same cluster. > > I wanted to know based on experience, which one of the options is better: > > 1. copyTable2. snapshot3. Any other? > > Besides efficiency aspect, I am also interested in knowing what happens > > when the operation fails midway copying from snapshot to destination > table. > > Or when it fails midway copying to destination table in copyTable option. > > Would data be left in inconsistent state? > > Thanks,Sumit > --94eb2c0a8d2c35d8370529c23cf2--