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 5F6031944B for ; Wed, 23 Mar 2016 03:49:42 +0000 (UTC) Received: (qmail 94488 invoked by uid 500); 23 Mar 2016 03:49:40 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 94411 invoked by uid 500); 23 Mar 2016 03:49:40 -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 94399 invoked by uid 99); 23 Mar 2016 03:49:40 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 23 Mar 2016 03:49:40 +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 E9547C0BC3 for ; Wed, 23 Mar 2016 03:49:39 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.821 X-Spam-Level: X-Spam-Status: No, score=-0.821 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-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-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id zzKivnMWXrYb for ; Wed, 23 Mar 2016 03:49:38 +0000 (UTC) Received: from mail-ob0-f174.google.com (mail-ob0-f174.google.com [209.85.214.174]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 43DC75FB9E for ; Wed, 23 Mar 2016 03:49:37 +0000 (UTC) Received: by mail-ob0-f174.google.com with SMTP id fp4so2548026obb.2 for ; Tue, 22 Mar 2016 20:49:37 -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; bh=SCtw83DED76Qp8YWiaSLfayfydcx3R2omyzu+4dcE20=; b=uyBbVlSyTtzoQ+EkF4H/EYMYO2OTd3/uEXvudYfMGE45NBC+OuS7zRQ+5KCQLKZqAO RgOXx0S9qBpPHXOrlFCB/AAi/VW91IutgWEZ2vrGbHdubrA1nLW5RKN83PzOe/altKdf ZV+uGpVp0b6Ixv6ti9tqXi8MWv+9dZWsnmTZ+hRZN30peVekCjc9yMpSHmnCesia4vgM mPCag2waGTjNrI3D1bTtlKCNME4ZTDqEQljo5wQtGKvZ9+W6Afx4N0h9TC59L+rwNFJj Y+NXSWVZuxcB2TtQ/4Wcc8QyP+093LVyzwViEcw70loLYeHg0GEKVFqwnmJ2KP8VU7SM FyoA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=SCtw83DED76Qp8YWiaSLfayfydcx3R2omyzu+4dcE20=; b=ZlwMx8/uJW+kZAO99R8BPpARui/syMozCSTFcw7qjP5xRJuCaI1B7o4vz+RaYwPU4K qAeLWm8cdf62hg+GN+/TP23k8zUpUurpvjg6NFby+bARKe4gQ5ojVIX8gP3Vor8jxusp liGr8hK//rhGJ9u7CScjwOVbjP/0xN5Hz9nR2/QqCkABxOkQbCVNO55fNFIk2q9Kl/Dm AJymY9yFo3+j5Qv5dhGVwpLOTVZAPhMq3KfIKuKja/9SRMom5y5HvsQ2jz5LzZJVW7YK 45NHNZXAX2LFRAI8s2yF52fKdR8Ppq/P54wfNTUof7yEuW1Ffurl8ocgrZiRCZK12PLn XWPw== X-Gm-Message-State: AD7BkJJQ+3bumZOWfKTkmhLPmVqjQOK1f2yjA3CDiRxc7JWGaTgRNo9khNMhKndTjBEeRdlLK4lQrv3XjwsoQg== X-Received: by 10.60.233.35 with SMTP id tt3mr287269oec.52.1458704976013; Tue, 22 Mar 2016 20:49:36 -0700 (PDT) MIME-Version: 1.0 Received: by 10.76.35.166 with HTTP; Tue, 22 Mar 2016 20:49:16 -0700 (PDT) In-Reply-To: References: From: Wojciech Indyk Date: Wed, 23 Mar 2016 04:49:16 +0100 Message-ID: Subject: Re: Hbase schema for time based analytics To: user@hbase.apache.org Content-Type: text/plain; charset=UTF-8 Hi Prem! Look at OpenTSDB http://opentsdb.net/ -- Kind regards/ Pozdrawiam, Wojciech Indyk http://datacentric.pl 2016-03-07 11:26 GMT+01:00 Prem Yadav : > Hi, > we have a use case where we need to get the data for a day/week/month. > > We need additional filters for the data so it will be like "select where > data between and where filter= column=value> > > This is telemetry type data and is heavily written. About 2+TB per day. > > How should we go about the schema? > > Also, can someone point me to a good schema design tutorial? > > Thanks