hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Software Dev <static.void....@gmail.com>
Subject Designing an increment table
Date Fri, 02 May 2014 22:57:09 GMT
We have a table that will house a bunch of increments for our
reporting needs. We will be saving things as number of page views,
searches, interactions, etc. We would like to store attributes along
with these increments such as sex, status of user, country of origin
etc. Would we would like to do is graph this out and then filter out
by any of these attributes. For example

- Over the last 3 weeks, how many page views were from the United States.
- Over the last 3 weeks, how many page views were from the United
States where the user is a male.
- Over the last 3 weeks, how many page views were from the United
States where the user is a male and he was logged in
- Over the last 3 weeks, how many page views were from the United
States where the user is a male and ....

How would I go about designing this table so these questions could be
answered? We will always be including a date range as well as country.
The other attributes such as sex, logged in status may or may not be
included.

Is there a Fuzzy type of filter for columns? If so I think I could
just suffix all the columns with a byte array. The first byte can
denote the sex of the user, the second the status, etc. Would that
work?

Any suggestions?

Mime
View raw message