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 C4917D63E for ; Tue, 10 Jul 2012 08:03:45 +0000 (UTC) Received: (qmail 13011 invoked by uid 500); 10 Jul 2012 08:03:44 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 12590 invoked by uid 500); 10 Jul 2012 08:03:43 -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 12545 invoked by uid 99); 10 Jul 2012 08:03:42 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Jul 2012 08:03:42 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=FSL_RCVD_USER,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of dontariq@gmail.com designates 209.85.216.169 as permitted sender) Received: from [209.85.216.169] (HELO mail-qc0-f169.google.com) (209.85.216.169) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Jul 2012 08:03:37 +0000 Received: by qcsd16 with SMTP id d16so8083234qcs.14 for ; Tue, 10 Jul 2012 01:03:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type:content-transfer-encoding; bh=IWaPx8cZxTTMBPb0qyGmEbnqqJ7bh2A0BHEY/vd4kR0=; b=sN33Jx0dwE39ZgE4w3DBlu279uiPjcPFUdjC/BmFTjDYsag1I7iNSIl12pEVVp0UQJ OfG+phE83oLsBXtTqbrZYDFesgqctvYGCRm4LEAStkdvDdmOn+XfaFT4PD+NIqZhEcmc jPp+3C61G28H0ITInRZaXzFuKpxAfu3CDC+6SdvQlk1Bb7MQl0rJG/NsnUg+ctO12UOA A+SFFc2cqU7xscCr7HEngny0U+hlxLJYpNVmOf7U1y7wzMAMze6427d9tlTZlgDRgzAw tST0NG0cSVAwn1m//1TSwPi38zvHSVBk60QfqOM2imu5R+Lxg6Huqd+iWewMlGwQpD8Q A6cA== Received: by 10.224.138.147 with SMTP id a19mr77586653qau.84.1341907396846; Tue, 10 Jul 2012 01:03:16 -0700 (PDT) MIME-Version: 1.0 Received: by 10.229.188.210 with HTTP; Tue, 10 Jul 2012 01:02:36 -0700 (PDT) In-Reply-To: <3582213062677409219@unknownmsgid> References: <1F9B9B49-A4EB-4B11-98C3-CC1E5948F220@gmail.com> <3582213062677409219@unknownmsgid> From: Mohammad Tariq Date: Tue, 10 Jul 2012 13:32:36 +0530 Message-ID: Subject: Re: Composing your own timestamp To: user@hbase.apache.org Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org Hi Asaf, Apologies for being so dumb. I should have read the question properly. Regards, Mohammad Tariq On Tue, Jul 10, 2012 at 9:01 AM, Asaf Mesika wrote: > The int, short, short part goes to the time stamp. > > Thanks! > > Sent from my iPad > > On 10 =D7=91=D7=99=D7=95=D7=9C 2012, at 01:08, Mohammad Tariq wrote: > >> Hello Asaf, >> If the 'int' parts of your rowkeys are close to each other, you may >> face hotspotting. >> >> Best >> -Tariq >> >> On Monday, July 9, 2012, Asaf Mesika wrote: >>> No. >>> My index is composed of several fields. Some goes to the RowKey, some t= o >> the column name, and some - and hence the question - to timestamp. >>> Those that goes to the timestamp are of types Integer, Short and short >> which together form 8 bytes - the size of the Timestamp in hbase. >>> >>> So my question was if that's ok? I mean, it seems that the normal usage >> for the timestamp is to have a timestamp (ms since epoch) and to have >> values there which always increasing - meaning: you'll never see value 7 >> enters *before* value 3, for example. >>> >>> On Jul 9, 2012, at 18:54 PM, Sonal Goyal wrote: >>> >>>> Sorry I did not understand your question. Are you planning to use the >>>> concatenated long as the rowkey to your secondary table? >>>> >>>> Best Regards, >>>> Sonal >>>> Crux: Reporting for HBase >>>> Nube Technologies >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> On Mon, Jul 9, 2012 at 6:49 PM, Asaf Mesika >> wrote: >>>> >>>>> Hi, >>>>> >>>>> We've been tinkering around ideas of implementing secondary index. >>>>> One of the ideas is based on concatenating three meaningful fields in= to >> a >>>>> long: int, short (2 bytes), short. This long will be used as timestam= p >> when >>>>> issuing a put to the secondary index table. >>>>> This means an puts, timestamp wise, will not occur chronologically. >> since >>>>> this is not a real timestamp. >>>>> >>>>> Will this create any issues? >>>>> >>>>> >>>>> Thanks! >>>>> >>>>> Asaf >>>>> >>>>> >>> >>> >> >> -- >> Regards, >> Mohammad Tariq