hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jean-Daniel Cryans <jdcry...@apache.org>
Subject Re: Using multiple column families
Date Fri, 09 Sep 2011 23:39:16 GMT
20k rows? If this is your only use case, you don't need HBase :)

If it's 20k rows times a gazillion columns per row, then I would
recommend flattening out the rows instead.

If it's just one small table among others, then you probably won't be
bothered by the multiple families.


On Thu, Sep 8, 2011 at 10:07 PM, Imran M Yousuf <imyousuf@gmail.com> wrote:
> Hi,
> Firstly, I have read in the mailing list before that having more than
> 1 column family is not recommended. I am more interested to know
> whether it is a problem in my use case as well or not.
> I have a strong entitly and it has 6 weak entities all with 1-to-many
> cardinal relationship to the strong entity. Furthermore, they are all
> loaded in mutually exclusive manner, i.e. if A is strong entity and
> its weak entities are P, Q, R, S, T, U in that case no 2 weak entities
> are accessed at once. Moreover their lifecycles are independent of
> each other. My current implementation is I have one column family for
> the strong entity and one for each weak entities. So for a given row I
> only load one column family at a time. The obvious advantages are that
> - deleting strong entity automatically deletes the weak entities as
> they are a single row, delete all of a kind weak entity for a specific
> weak entity is as simple as deleting all cells in a column family for
> a row. Our assumption (pretty high than what we expect) is that we
> will not have more than 20k rows in that table. Under these
> circumstance how bad is it to have 7 column families?
> We would be glad if you would kindly share thoughts and feedback on this issue.
> Thank you,
> --
> Imran M Yousuf
> Entrepreneur & CEO
> Smart IT Engineering Ltd.
> Dhaka, Bangladesh
> Twitter: @imyousuf - http://twitter.com/imyousuf
> Blog: http://imyousuf-tech.blogs.smartitengineering.com/
> Mobile: +880-1711402557

View raw message