phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Krishna <>
Subject Re: ALTER table
Date Tue, 12 Jan 2016 06:47:00 GMT
General recommendation is to choose salt number as a small multiple of
region servers. If you are aware of your key distribution you can pre-split
the table in phoenix too along specific split points.

On Monday, January 11, 2016, Ken Hampson <> wrote:

> I ran into this as well just today, and am very interested in the answer.
> HBase itself allows regions to be explicitly split as well as pre-split and
> auto-split. SALT_BUCKETS seems like a pre-split equivalent of sorts, so I
> am interested to see what there may be in terms of auto- and
> explicit-salting.
> Thanks,
> - Ken
> On Mon, Jan 11, 2016 at 6:10 AM Sumit Nigam <
> <javascript:_e(%7B%7D,'cvml','');>> wrote:
>> Hello,
>> SALT_BUCKETS cannot be altered after table creation. I'd like to know
>> from advanced users as to how do we ensure that salt buckets hold up as
>> data grows? I might state salt buckets as say, 8 when I create table and
>> that may hold up for a long time. However, as data is increasing those salt
>> buckets will not be sufficient. Also, the value may not always be optimal
>> for different read/ write load types.
>> Or would specifying initial salt buckets will hold up as long as I make
>> sure I keep adding region servers as I go along?
>> Thanks,
>> Sumit

View raw message