Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
HBase >> mail # user >> HBase Schema Design for clickstream data

Copy link to this message
Re: HBase Schema Design for clickstream data
We, at Bloomberg, currently do it the way you just described where each user is represented by a row and each column is a particular click/page view..

From: Mohit Anchlia <[EMAIL PROTECTED]>
Sent: Tuesday, 26 June 2012 1:34 PM
Subject: HBase Schema Design for clickstream data

I am starting out with a new application where I need to store users
clickstream data. I'll have Visitor Id, session id along with other page
related data. I am wondering if I should just key off randomly generated
session id and store all the page related data as columns inside that row
assuming that this would also give good distribution accross region
servers. In a session user could send 100s of HTML requests and get
responses. If someone is already doing this in HBase I would like to learn
more about it as to how they have designed the schema.