Return-Path: X-Original-To: apmail-hbase-dev-archive@www.apache.org Delivered-To: apmail-hbase-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 0314A11CF0 for ; Sat, 24 May 2014 00:55:17 +0000 (UTC) Received: (qmail 85537 invoked by uid 500); 24 May 2014 00:55:16 -0000 Delivered-To: apmail-hbase-dev-archive@hbase.apache.org Received: (qmail 85444 invoked by uid 500); 24 May 2014 00:55:16 -0000 Mailing-List: contact dev-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hbase.apache.org Delivered-To: mailing list dev@hbase.apache.org Received: (qmail 85435 invoked by uid 99); 24 May 2014 00:55:16 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 24 May 2014 00:55:16 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of enis.soz@gmail.com designates 209.85.160.172 as permitted sender) Received: from [209.85.160.172] (HELO mail-yk0-f172.google.com) (209.85.160.172) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 24 May 2014 00:55:10 +0000 Received: by mail-yk0-f172.google.com with SMTP id 79so4614419ykr.31 for ; Fri, 23 May 2014 17:54:48 -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; bh=YvO/y/0z/o67LfJFq39rxbHNjnrvo6X0d2IZ0IeVqRE=; b=DEKtsV6sfxCrixajwg9Qp4wBfTnHIfFc7KApHUP94t/lAXPZSNCjSKS9KwP3r8/enK CU8ACLoaY7HSo/YStLnDEjlTYwDxjW8reccKE0CC0JAGYeeL4ncCSPWIA6fI4jQJRC62 8W/lSwR1oa3NpUdxuOaOHEewtncJYEWcg60khqox0DSdv2qouRbSTQVgmGbcT/fPgp/W wyKBIPTHIVT5b8NZ/j8ePYIUaEXs1NUYHnciqyuE2lrZHLnXZKHLheiCQ5492ciaA96m AahcMG/kOc+g6doIrgB5i/MbzoyC9TxOwr6RlUPq4EFzZIHvpK0AzH9RChy6OTnrlU8b XfcQ== X-Received: by 10.236.1.36 with SMTP id 24mr12261257yhc.45.1400892888031; Fri, 23 May 2014 17:54:48 -0700 (PDT) MIME-Version: 1.0 Received: by 10.170.208.206 with HTTP; Fri, 23 May 2014 17:54:27 -0700 (PDT) In-Reply-To: <1400891279.11418.YahooMailNeo@web140603.mail.bf1.yahoo.com> References: <1400891279.11418.YahooMailNeo@web140603.mail.bf1.yahoo.com> From: =?UTF-8?Q?Enis_S=C3=B6ztutar?= Date: Fri, 23 May 2014 17:54:27 -0700 Message-ID: Subject: Re: Timestamp resolution To: "dev@hbase.apache.org" , lars hofhansl Content-Type: multipart/alternative; boundary=001a1133db94f5ac5104fa1aca41 X-Virus-Checked: Checked by ClamAV on apache.org --001a1133db94f5ac5104fa1aca41 Content-Type: text/plain; charset=UTF-8 +1 to micros. We should do it at the table level rather than CF level? How can we get the micros resolution efficiently in java? Enis On Fri, May 23, 2014 at 5:27 PM, lars hofhansl wrote: > We have discussed this in the past. It just came up again during an > internal discussion. > Currently we simply store a Java timestamp (millisec since epoch), i.e. we > have ms resolution. > > We do have 8 bytes for the TS, though. Not enough to store nanosecs (that > would only cover 2^63/10^9/3600/24/365.24 = 292.279 years), but enough for > microseconds (292279 years). > Should we just store he TS is microseconds? We could do that right now > (and just keep the ms resolution for now - i.e. the us part would always be > 0 for now). > Existing data must be in ms of course, so we'd grandfather that in, but > new tables could store by default in us. > > We'd need to make this configurable both the column family level and > client level, so clients could still opt to see data in ms. > > Comments? Too much to bite off? > > -- Lars > > --001a1133db94f5ac5104fa1aca41--