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]>
To: [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.