The initial row key design would result in hot spot (w.r.t. writes) Is user id part of row key ?
Have you looked at Sematext's HBaseWD library ? Lastly, Apache Phoenix may fit your needs. On Tue, Apr 29, 2014 at 3:25 PM, Software Dev <[email protected]>wrote: > Hey all. I have some questions regarding row key and column design. > > We want to calculate some metrics based on our page views broken down > by minute, day, month and year. We also want this broken down country > and have the ability to filter by some other attributes such as the > sex of the user or whether or not the user is logged in... or both! > > So we have the initial row key design as > > YYYY > YYYYMMDD > YYYYMMDDHH > YYYYMMDDHHSS >
