Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 379182009C5 for ; Mon, 16 May 2016 12:17:26 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 36148160A16; Mon, 16 May 2016 10:17:26 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 7E5D11609B0 for ; Mon, 16 May 2016 12:17:25 +0200 (CEST) Received: (qmail 25954 invoked by uid 500); 16 May 2016 10:17:24 -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 25942 invoked by uid 99); 16 May 2016 10:17:23 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 16 May 2016 10:17:23 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 761F8C25C6 for ; Mon, 16 May 2016 10:17:23 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3.129 X-Spam-Level: *** X-Spam-Status: No, score=3.129 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, FREEMAIL_REPLY=1, HTML_MESSAGE=2, 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: spamd1-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 (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id hLoT40RV5Ij9 for ; Mon, 16 May 2016 10:17:21 +0000 (UTC) Received: from mail-yw0-f174.google.com (mail-yw0-f174.google.com [209.85.161.174]) by mx2-lw-eu.apache.org (ASF Mail Server at mx2-lw-eu.apache.org) with ESMTPS id B95CD5F47C for ; Mon, 16 May 2016 10:17:20 +0000 (UTC) Received: by mail-yw0-f174.google.com with SMTP id x189so6066066ywe.3 for ; Mon, 16 May 2016 03:17:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to; bh=V81fwUmQl89fCnbMN/PbjnGz34gs2713Roy4LCDy19w=; b=J3Px3saQQ0fOZyKlZrmoeH6PkovaEwoNXabV8FT3fDl+z4Cpl148UN6sg5Mo8xHW83 M+IlwpkUD5EtLFCeYV+K+ZBKXkfBntpQuIYlo9LQSxhzinas2PxaOsGXI5aUCc4lBB+s nRkI444iihW3F2788iUqWajZmYd41yKqYIFpSA+u1rQR+hziJDd8FbBweOExzjtiWmS9 ZFkD4q55sRJ8OaMojroyMqlUjIlABW4Cx7cKObW6dXUjFgqwLOi4m7TDBPxsULYP3eeY ANwWvlr8SzWIuyeS9LZMRs4ddVhm7A94FG+MnzcECzM7ocW7H7+xyzqHLRgKxVJkLV5M bThQ== 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:date :message-id:subject:from:to; bh=V81fwUmQl89fCnbMN/PbjnGz34gs2713Roy4LCDy19w=; b=X8yNQvrHXIclgC2SY15Dn6Fwr9knMreci6rsgdaQF6SR2ZSu6EoWuZhNP2bbszo8pu i+14Iw6/+rtd/PbcSFRI3jLgohCoIwcy5If3dKkGxtlHhGcQSNWZYX1FhUAIxAF9z3D+ DBUl4ujPYYx1IJZLyHWEzvv3dpKzlTcOD2vMcsz2ChVEXWNtoSaJgZMUy5GpXF77lr3S ++qae2r0pQIMxFrkyG4gwvhC1SeAufveocug1n1zSMQ/PbAw9dT1DW7KVWe+tkK8LWSG Xn+N/+Kh0CEpTp1jYHj3ajorH6rItXGoLwU5bG74G7Ip6AWcDAby16PpvT2DEr+pP5wb u+Nw== X-Gm-Message-State: AOPr4FVjgiESfUzb7Xm9Qy9cri/F/LaJmEBGEFH0zukKn/zdisou7rOQck/ioq+dO5QbocI9g71csHAWcgtoHA== MIME-Version: 1.0 X-Received: by 10.13.213.9 with SMTP id x9mr14022663ywd.253.1463393839883; Mon, 16 May 2016 03:17:19 -0700 (PDT) Received: by 10.37.32.137 with HTTP; Mon, 16 May 2016 03:17:19 -0700 (PDT) In-Reply-To: References: Date: Mon, 16 May 2016 18:17:19 +0800 Message-ID: Subject: Re: hbase rowkey design From: Heng Chen To: user@hbase.apache.org Content-Type: multipart/alternative; boundary=001a114fad80fe2dab0532f2eddc archived-at: Mon, 16 May 2016 10:17:26 -0000 --001a114fad80fe2dab0532f2eddc Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable In my company, we calculate UV/PV offline in batch, and update every day. If do it online, url + timestamp could be the rowkey. 2016-05-16 18:13 GMT+08:00 =E9=BD=90=E5=BF=A0 : > 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. > >> > > > > -- > centerqi@gmail.com|=E9=BD=90=E5=BF=A0 > --001a114fad80fe2dab0532f2eddc--