phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jesse <chat2je...@gmail.com>
Subject Re: Buckets VS regions
Date Tue, 20 Aug 2019 01:03:29 GMT
we got some trouble, maybe someone could shed some light on this.

Table has primary key c1, c2 and c3.
Table is set with SALT_BUCKETS=12. Now it has 14 regions.

The table has a record with c1='a', c2='b', c3='c'

If Phoenix query is like:
select * from t where c2='b', it returns some results.

select * from t where c1='a', it returns empty
select * from t where c2='b' and c1='a', it returns empty

select * from t where c3='c', it returns right results
select * from t where c2='b' and c3='c', it returns results

What the heck is going wrong? The system used to work fine.








On Mon, Aug 19, 2019, 5:33 PM James Taylor <jamestaylor@apache.org> wrote:

> It’ll start with 12 regions, but those regions may split as they’re
> written to.
>
> On Mon, Aug 19, 2019 at 4:34 PM jesse <chat2jesse@gmail.com> wrote:
>
>> I have a table is  SALT_BUCKETS = 12, but it has 14 regions, is this
>> right?
>>
>> Thanks
>>
>>
>>

Mime
View raw message