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 C64B9174AD for ; Tue, 22 Sep 2015 16:46:19 +0000 (UTC) Received: (qmail 32628 invoked by uid 500); 22 Sep 2015 16:46:11 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 32560 invoked by uid 500); 22 Sep 2015 16:46:11 -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 32543 invoked by uid 99); 22 Sep 2015 16:46:11 -0000 Received: from Unknown (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Sep 2015 16:46:11 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 58643C0F96 for ; Tue, 22 Sep 2015 16:46:10 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.149 X-Spam-Level: * X-Spam-Status: No, score=1.149 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, FREEMAIL_REPLY=1, RCVD_IN_MSPIKE_H2=-0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id DOmMW5J7_6m4 for ; Tue, 22 Sep 2015 16:46:06 +0000 (UTC) Received: from mail-pa0-f53.google.com (mail-pa0-f53.google.com [209.85.220.53]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with ESMTPS id 8EAAF44170 for ; Tue, 22 Sep 2015 16:46:06 +0000 (UTC) Received: by pacfv12 with SMTP id fv12so14062211pac.2 for ; Tue, 22 Sep 2015 09:46:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=from:content-type:content-transfer-encoding:mime-version:subject :message-id:date:references:in-reply-to:to; bh=YmfeSkkuWXZj+KbaKp4Wj3irKGxrUiUs4lzgGpeA42Q=; b=CMjCYkVEYHo9Bw+Pp6O+ko4diTvl8ZWtRtUivr12S4hg+kVXNUvucqc9AN3CL07muk lpeqeFh/Lkrvfw+IJD4U7E1zPHWqNbfiCtry83NPZSzHJEUm09XIJVIID+yepgjO9vOF tYeQ1YsAwPEgZ4M0t6A8+RT1eOEBxUahABiSEq7oRG8hLw8tqowqm7QV7K1owDZL03l2 LwvWzABKspERCRdLBT5YNeS9DT5c+H/kqZvc3r7VEl86M61LqK1qE5u/vgRYT4sDI/SV 5aUC5aqieCfdZNIWKvmMeD6azNRCK3GXE2JZDgUP3ffO26JbecIP52KRZJVD5bCQai5l K4KA== X-Received: by 10.66.228.71 with SMTP id sg7mr32641995pac.70.1442940360483; Tue, 22 Sep 2015 09:46:00 -0700 (PDT) Received: from [10.62.9.135] (mobile-166-176-59-208.mycingular.net. [166.176.59.208]) by smtp.gmail.com with ESMTPSA id rs8sm3290654pbb.14.2015.09.22.09.45.59 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Tue, 22 Sep 2015 09:46:00 -0700 (PDT) From: Anil Gupta Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (1.0) Subject: Re: Hbase import/export change number of rows Message-Id: <3A5DBC74-72D7-4B61-B12C-7224F6F5D109@gmail.com> Date: Tue, 22 Sep 2015 09:46:18 -0700 References: In-Reply-To: To: user@hbase.apache.org X-Mailer: iPhone Mail (13A344) How many rows are expected? Can you do sanity checking in your data to make sure there are no duplicate r= owkeys? Sent from my iPhone > On Sep 22, 2015, at 8:35 AM, OM PARKASH Nain w= rote: >=20 > I using two methods for row count: >=20 > hbase shell: >=20 > count "Table1" >=20 > another is: >=20 > hbase org.apache.hadoop.hbase.mapreduce.RowCounter "Table1" >=20 > Both give same number of row but export have different number of rows. >=20 > hbase org.apache.hadoop.hbase.mapreduce.Export "Table1" "hdfs path" >=20 >=20 >=20 >=20 > On Tue, Sep 22, 2015 at 5:33 PM, OM PARKASH Nain > wrote: >=20 >> I am using Hbase export using command. >>=20 >> hbase org.apache.hadoop.hbase.mapreduce.Export "Table1" "hdfs path" >>=20 >> Then I use import command from HDFS to Hbase Table; >>=20 >> hbase org.apache.hadoop.hbase.mapreduce.Import "hdfs path" "Table2" >>=20 >> Then I count number of row in both tables, I found mismatch number of row= s >>=20 >> Table1:8301 Table2:8032 >>=20 >> Please define what goes wrong with my system. >>=20