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:04:32 GMT
And the table is simple and has no index set up.

On Mon, Aug 19, 2019, 6:03 PM jesse <chat2jesse@gmail.com> wrote:

> 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