From user-return-34179-apmail-hbase-user-archive=hbase.apache.org@hbase.apache.org Mon Feb 18 22:19:06 2013 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 DAB77DB08 for ; Mon, 18 Feb 2013 22:19:06 +0000 (UTC) Received: (qmail 9415 invoked by uid 500); 18 Feb 2013 22:19:04 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 9341 invoked by uid 500); 18 Feb 2013 22:19:04 -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 9330 invoked by uid 99); 18 Feb 2013 22:19:04 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 18 Feb 2013 22:19:04 +0000 X-ASF-Spam-Status: No, hits=2.5 required=5.0 tests=FREEMAIL_REPLY,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of asaf.mesika@gmail.com designates 209.85.214.180 as permitted sender) Received: from [209.85.214.180] (HELO mail-ob0-f180.google.com) (209.85.214.180) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 18 Feb 2013 22:18:56 +0000 Received: by mail-ob0-f180.google.com with SMTP id ef5so5902459obb.25 for ; Mon, 18 Feb 2013 14:18:35 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:in-reply-to:references:date:message-id :subject:from:to:content-type; bh=kMHWSQWimS+oh725r0mZUU4zQajP0hybH+2P80QYwM4=; b=soNlNnThOTJVAQs+ctU9E/wl6F6ur7EULWJZFXBU/Qhi0ErywHMmWsAJ+VC7v7nqOD WSY8cJt1pAG0v4Dk4udKeRXi1UEFv8GsM7CxbijNRSmPqG+GXy1V5zfl6gCG9TBkS8o/ b401OFuZCYGeKLdFzL8TokwCLO8qNWZhoPBqrXCJJQQEutkyZPOerp4mKahUIdlX5k9I a/8V5x3tWk40KOSZ7tATId4NsYIhp0BxhzNKlEqjLbcoHHgTx6ZoS4YAT/ebEMC4nJuZ gyhn9D+Mg914K83nlNMYZ+8uf6Ky0Dd7FxVDAyiZPbndVMiiYdvZ7uFDDRtbwGYtjklj FvrQ== MIME-Version: 1.0 X-Received: by 10.60.0.199 with SMTP id 7mr6777882oeg.139.1361225915146; Mon, 18 Feb 2013 14:18:35 -0800 (PST) Received: by 10.60.37.194 with HTTP; Mon, 18 Feb 2013 14:18:35 -0800 (PST) In-Reply-To: References: Date: Tue, 19 Feb 2013 00:18:35 +0200 Message-ID: Subject: Re: increment counters via bulk upload in HBase From: Asaf Mesika To: "user@hbase.apache.org" Content-Type: multipart/alternative; boundary=e89a8fb1f3be21a1ed04d6071ba7 X-Virus-Checked: Checked by ClamAV on apache.org --e89a8fb1f3be21a1ed04d6071ba7 Content-Type: text/plain; charset=UTF-8 We solved this partially by converting increment to put and aggregating in preCompact. I guess that if you bulk upload an HFile which has this puts which are a representation of a delta to a column, and merge it in the compaction it could work. On Monday, February 18, 2013, Andrew Purtell wrote: > > Is there a way to increment counters in HBase via bulk upload? > > I thought about maybe doing this once, as > https://issues.apache.org/jira/browse/HBASE-3936, but we decided to > resolve > it as maybe something to try later if there was ever a compelling need. I > wonder if doing the in memory merge of most recent value with increments > found in HFiles submitted for bulk import would perform any better than > just incrementing with the client API (perhaps with some level of > batching). Seems a complicated undertaking with unclear benefit. Would > still be interesting to try as a experiment someday though. > > On Sat, Feb 16, 2013 at 8:39 AM, Ashish Nigam > >wrote: > > > Hi, > > Is there a way to increment counters in HBase via bulk upload? > > At present, I am storing counters in a sequence file in HDFS. Then I use > a > > mapper to read the file and increment counters in HBase via Java API > calls. > > I am assuming that if there is a way to increment counters via bulk > upload, > > it will be more efficient. > > > > Thanks > > Ashish > > > > > > -- > Best regards, > > - Andy > > Problems worthy of attack prove their worth by hitting back. - Piet Hein > (via Tom White) > --e89a8fb1f3be21a1ed04d6071ba7--