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 05:40:01 GMT
Yes, that seems to be a trick, the issue is only associated a region.

What could be the causes of guidposts not updated?


On Mon, Aug 19, 2019, 6:40 PM venkata subbarayudu <avsrit2005@gmail.com>
wrote:

> Did you try with updating table statistics, it may be because some times
> table guideposts are out of sync
>
> Below is the SQL to update table stats
>          Update statistics table
> By default above executes asynchronously, hence it may take some time to
> update depending on table size
>
> On Tue 20 Aug, 2019, 6:34 AM jesse, <chat2jesse@gmail.com> wrote:
>
>> 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