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 840F4DD16 for ; Mon, 25 Feb 2013 02:26:46 +0000 (UTC) Received: (qmail 52644 invoked by uid 500); 25 Feb 2013 02:26:44 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 52592 invoked by uid 500); 25 Feb 2013 02:26:44 -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 52582 invoked by uid 99); 25 Feb 2013 02:26:44 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 25 Feb 2013 02:26:44 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [209.85.212.177] (HELO mail-wi0-f177.google.com) (209.85.212.177) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 25 Feb 2013 02:26:37 +0000 Received: by mail-wi0-f177.google.com with SMTP id hm14so2635524wib.16 for ; Sun, 24 Feb 2013 18:26:17 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=x-received:mime-version:in-reply-to:references:from:date:message-id :subject:to:content-type:x-gm-message-state; bh=QX6VCTSejJkLRGROwvAv+FrmgyV8qFeuWeMcv5sTy+s=; b=cyBcz8Sdvvn2648QbS3IZTxo0duDCQqDJTY192aAibDvL3192E8qxFt9MdIAyrzHDL y16XrE4Z/GTI03HuB9E8ezMKtpyDxd5NpsnJDHEvchReSY6M78VJlr7zvJbQ8RFKYt+M EieKAaAJ10ULdbaTA+WHaVRvUAN6h4bZjXLUMEz60NeKfe14METB0wrg8Pn/H2kOrjOc AxHUzk92kAH4N+JRVRsbVkG/xiYR22zMJX5VbRiJLGs22/J/Unsy2wysc9WvP3gYQX/N 4VSFs19KcJSY1Fto+MGLALImrRM3bRl7dWk8BkWbLqhtCgn/S9rLaJFiamw8enoSyIwT zSiw== X-Received: by 10.180.107.70 with SMTP id ha6mr9197278wib.10.1361759176819; Sun, 24 Feb 2013 18:26:16 -0800 (PST) MIME-Version: 1.0 Received: by 10.194.176.71 with HTTP; Sun, 24 Feb 2013 18:25:56 -0800 (PST) In-Reply-To: References: <1360803001.75692.YahooMailNeo@web140601.mail.bf1.yahoo.com> <6670454D-5AE4-40BD-A5E2-43FA1D70E33B@gmail.com> From: Jean-Marc Spaggiari Date: Sun, 24 Feb 2013 21:25:56 -0500 Message-ID: Subject: Re: RowKey design with hashing To: user@hbase.apache.org Content-Type: multipart/alternative; boundary=e89a8f234d090105a304d683449a X-Gm-Message-State: ALoCoQmUKbdGwPaHoCr0EYFzPhZ6ydMCzWBzFQXuF9ruIiuNsn2BAE738qGtLeZ/mEkWXskwWdNJ X-Virus-Checked: Checked by ClamAV on apache.org --e89a8f234d090105a304d683449a Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Ted, Thanks for pointing me to HBASE-4218. I will take a look at it. JM 2013/2/13 Ted Yu > My name is Ted, not Lars :-) > > On Wed, Feb 13, 2013 at 7:41 PM, Mehmet Simsek >wrote: > > > Thanks Lars > > > > M.Nurettin =C5=9Eim=C5=9Fek > > > > On 14 =C5=9Eub 2013, at 05:18, Ted Yu wrote: > > > > > Jean-Marc: > > > You can find almost all the details you need from this JIRA: > > > HBASE-4218 Data Block Encoding of KeyValues (aka delta encoding / > prefix > > > compression) > > > > > > Cheers > > > > > > On Wed, Feb 13, 2013 at 6:09 PM, Jean-Marc Spaggiari < > > > jean-marc@spaggiari.org> wrote: > > > > > >> Hi Lars, > > >> > > >> Can you please tell more about key prefix block encoding? Or refer t= o > > >> some blog/doc? How it works, what it is, etc.? > > >> > > >> Thanks, > > >> > > >> JM > > >> > > >> 2013/2/13, lars hofhansl : > > >>> Depends on you search pattern. > > >>> If you never care about scans ordering i.e. you only do point gets = to > > see > > >>> whether you've already seen an email address, do the hash part. > > >>> > > >>> I'd perfer #1 over #2, because it would let you do efficient key > prefix > > >>> block encoding (FAST_DIFF). > > >>> > > >>> -- Lars > > >>> > > >>> > > >>> > > >>> ________________________________ > > >>> From: Nurettin =C5=9Eim=C5=9Fek > > >>> To: user@hbase.apache.org > > >>> Sent: Wednesday, February 13, 2013 12:35 AM > > >>> Subject: RowKey design with hashing > > >>> > > >>> Hi All, > > >>> > > >>> In our project mail adresses are row key. Which rowkey design we > > should > > >>> choose? > > >>> > > >>> 1) com.yahoo@xxxx (Reversed) > > >>> 2) xxxx@yahoo.com > > >>> 3) md5 hash(xxxx@yahoo.com) > > >>> 4) Any other solution. > > >>> > > >>> Many thanks. > > >>> > > >>> -- > > >>> M. Nurettin =C5=9E=C4=B0M=C5=9EEK > > >> > > > --e89a8f234d090105a304d683449a--