hbase-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pan, Thomas" <th...@ebay.com>
Subject Re: Scan performance on a big table as combination of multiple logic tables
Date Fri, 17 Feb 2012 18:49:21 GMT

In our case, we have similar updating patterns for completed and live
items. $0.02, -Thomas

On 2/15/12 2:02 PM, "Todd Lipcon" <todd@cloudera.com> wrote:

>Hi Thomas,
>The issue with combining multiple tables into different CFs of one
>table is that the tables will get tied together for flush/compact
>operations. If the workload between them differs significantly you
>might introduce bad inefficiency for one or the other. See HBASE-3149.
>On Wed, Feb 15, 2012 at 1:57 PM, Pan, Thomas <thpan@ebay.com> wrote:
>> Since Hbase is tailored to handle one table very well, we are thinking
>>to put multiple tables into one big table but on different column family
>>sets. Our use case is full table scan against single column value
>>filters. As records from different "logical tables" are at different
>>column families, could we speed up the scan performance by simply
>>checking the column family referenced by these single column value
>>filters first before really going through all the underlying K-V pairs?
>>It would be great if the Hbase code is already coded that way.
>> $0.02,
>> Thomas
>Todd Lipcon
>Software Engineer, Cloudera

View raw message