From user-return-51364-apmail-hbase-user-archive=hbase.apache.org@hbase.apache.org Mon May 16 10:13:59 2016 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 9C6361996F for ; Mon, 16 May 2016 10:13:59 +0000 (UTC) Received: (qmail 12130 invoked by uid 500); 16 May 2016 10:13:57 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 12048 invoked by uid 500); 16 May 2016 10:13:57 -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 12036 invoked by uid 99); 16 May 2016 10:13:56 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 16 May 2016 10:13:56 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 2AE351805D9 for ; Mon, 16 May 2016 10:13:56 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.121 X-Spam-Level: X-Spam-Status: No, score=-0.121 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx2-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id WfPFSKA-Fllq for ; Mon, 16 May 2016 10:13:55 +0000 (UTC) Received: from mail-yw0-f176.google.com (mail-yw0-f176.google.com [209.85.161.176]) by mx2-lw-eu.apache.org (ASF Mail Server at mx2-lw-eu.apache.org) with ESMTPS id C1E645F282 for ; Mon, 16 May 2016 10:13:54 +0000 (UTC) Received: by mail-yw0-f176.google.com with SMTP id g133so156973323ywb.2 for ; Mon, 16 May 2016 03:13:54 -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-transfer-encoding; bh=Ce7PYETMPP3M685nQ4rggTqx7hNL7xZ1ZKlckhB+jSM=; b=j5bTkK77T2QAllY30gt/7oDHvf3fpzDa1t8HFkq9mUQMPX+XdkseG4bEXITiz/IXu9 OiafYlc/82X35u7knfpbFMhe+ilnhDhCdb4VEL/4T/9qdPCZDAKUp4JgHmZyYV/ao8FQ Ixy0xahIPbfYVHYfhdIdBRNbmm1vhD4Tt3BAng5giVIdYWuk9gw7Be3w2YCkud0bPf1a ltGUAGIi9pUHggGwEaydPgfHRDfqNNFkib9ab/078tlB1wegFbL8KyLoFtvJL11gpbfB LkgfZp7bgmds2nwlOYP1F6DWbDCgevDg2/x6gUs9qKEGQcYWYtzhSuDzdGAa2CofpKcb /kkA== 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:content-transfer-encoding; bh=Ce7PYETMPP3M685nQ4rggTqx7hNL7xZ1ZKlckhB+jSM=; b=K7FR8/4m4ZfG096yK2eTdmk7UeNMFSE2oktspQ3k7Ntf3A+a8D6xI9F7s91FmORjiJ nMuCVrgWCjP0SaZWPNXRAes4U30pQq3ZLdr/RKJmDiFINWoGd91yz2dtP/VXvxIq+8c/ 8bPzxC4+sL8OEaZH+fpcjtuPlUZ/lPSOLrHhg8UNjIg8uBNU8HG5/HZ+td/poz3LD3QZ RwqJxGa3x4aiUaZyyDOb0kMhIBWmsm8Ik0muWhBLSE0RdU9ku3C9AFef3mhOu0GKlkLk hKBzTe6OM3HO0XBn5tXcgrLKXVD42soMjH5WRnSxOUYkKmNsn3g/MYdrXCjXeg35YZR1 bE7Q== X-Gm-Message-State: AOPr4FUFS9Q1ymzH3LIL+t6qWUoDEixPZBPDDTAFojtTQr19rE5w+vGtT0fBBclba6giB+XZuPaJB/LrZMazrg== X-Received: by 10.129.75.215 with SMTP id y206mr15190309ywa.32.1463393633894; Mon, 16 May 2016 03:13:53 -0700 (PDT) MIME-Version: 1.0 Received: by 10.37.116.131 with HTTP; Mon, 16 May 2016 03:13:34 -0700 (PDT) In-Reply-To: References: From: =?UTF-8?B?6b2Q5b+g?= Date: Mon, 16 May 2016 18:13:34 +0800 Message-ID: Subject: Re: hbase rowkey design To: user@hbase.apache.org Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Yes, like google analytics. 2016-05-16 17:48 GMT+08:00 Heng Chen : > You want to calculate UV/PV online? > > 2016-05-16 16:46 GMT+08:00 =E9=BD=90=E5=BF=A0 : > >> I have very large log(50T per day), >> >> My log event as follows >> >> url,visitid,requesttime >> >> http://www.aaa.com?a=3Db&c=3Dd&e=3Df, 1, 1463387380 >> http://www.aaa.com?a=3Db&c=3Dd&e=3Dfa, 1, 1463387280 >> http://www.aaa.com?a=3Db&c=3Dd&e=3Dfa, 2, 1463387280 >> http://www.aaa.com?a=3Db&c=3Dd&e=3Dfab, 2, 1463387280 >> http://www.aaa.com?a=3Db&c=3Dd&e=3Df, 1, 1463387380 >> >> >> When a user enters a part of the url, and returns the >> uv(UniqueVisitor) pv(PageView)=E3=80=82 >> >> for example >> >> input: e=3Df* >> >> output: uv=3D2,pv=3D5, >> >> input: e=3Dfa >> >> output:uv=3D2,pv=3D3 >> >> How to design rowkey? >> >> Thanks. >> --=20 centerqi@gmail.com|=E9=BD=90=E5=BF=A0