hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tatsuya Kawano <tatsuy...@snowcocoa.info>
Subject Re: HBase 0.20.1 on Ubuntu 9.04: master fails to start
Date Fri, 30 Oct 2009 00:04:40 GMT
> So please take a look at HBase FAQ #10 at http://bit.ly/2RyrI3 , as
> well as the case studies by Evan Liu at http://bit.ly/1eGU2r . They
> will show you how to eliminate the join table.

Sorry, not FAQ #10, but #20. The link above is a direct link to #20,
so you won't miss it.

Thanks,
Tatsuya



On Fri, Oct 30, 2009 at 8:54 AM, Tatsuya Kawano
<tatsuyaml@snowcocoa.info> wrote:
> Hello, Artyom,
>
>> I'll try both:
>> 1. Increase RAM capacity
>> 2. Decrease heap size
>>
>> Also I'll try to optimize table structure.
>
> Good luck!
>
> One more thing about the table structure, is channel_products table a
> kind of join table in SQL world? If so, you could de-normalize the
> table structure and eliminate that table.
>
> Since HBase doesn't provide foreign key index and table join, your
> current implementation of looking up the join table results a full
> table scan of 3 million records, which will take a few seconds to
> complete. If you de-normalize the table structure and eliminate the
> join table, the same query could complete in a few milli-seconds and
> of course consume much much smaller amount of memory.
>
> So please take a look at HBase FAQ #10 at http://bit.ly/2RyrI3 , as
> well as the case studies by Evan Liu at http://bit.ly/1eGU2r . They
> will show you how to eliminate the join table.
>
>
> --
> Tatsuya Kawano (Mr.)
> Tokyo, Japan

Mime
View raw message