hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Hancock <jhancock1...@gmail.com>
Subject Re: hbase key design to efficient query on base of 2 or more column
Date Sun, 18 May 2014 11:33:30 GMT

Here's one idea, there might be better ways.

Take a look at phoenix it supports secondary indexing:


On Sat, May 17, 2014 at 8:34 AM, Shushant Arora

> 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.

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message