Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (nike.apache.org: domain of static.void.dev@gmail.com
 designates 209.85.160.169 as permitted sender)
Message-ID: <4E46BBC7.1050103@gmail.com>
Date: Sat, 13 Aug 2011 11:00:39 -0700
From: Mark <static.void.dev@gmail.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6;
 rv:5.0) Gecko/20110624 Thunderbird/5.0
MIME-Version: 1.0
To: user@hbase.apache.org
Subject: Generic Schema Question
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi all, I'm trying to wrap my head around HBase schema design and I am 
having trouble modeling the following use case:

We store all our use behavior (clicks, searches, page views) in Hadoop 
and we would like to add this into HBase so we can interactively 
"explore" what our users are doing. For example we would like, given an 
IP address get back a list of all searches, page views, clicks etc that 
this user has attempted.

My initial thought for something like this would be to create a table 
"Logs" with a CF "Data" that have qualifiers of "Search", "Click" and 
"View". Each column would have a row with the IP as its key.

Is this along the right lines or am I missing something... sure feels 
like I am. Would anyone please explain how I would accomplish what I am 
looking for.

Thanks