Shushant, Here's one idea, there might be better ways.
Take a look at phoenix it supports secondary indexing: http://phoenix.incubator.apache.org/secondary_indexing.html -John On Sat, May 17, 2014 at 8:34 AM, Shushant Arora <[email protected]>wrote: > Hi > > I have a requirement to query my data base on date and user category. > User category can be Supreme,Normal,Medium. > > I want to query how many new users are there in my table from date range > (2014-01-01) to (2014-05-16) category wise. > > Another requirement is to query how many users of Supreme category are > there in my table Broken down wise month in which they came. > > What should be my key > 1.If i take key as combination of date#category. I cannot query based on > category? > 2.If I take key as category#date I cannot query based on date. > > > Thanks > Shushant. >
