phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From venkata subbarayudu <avsrit2...@gmail.com>
Subject Re: Buckets VS regions
Date Tue, 20 Aug 2019 06:16:35 GMT
There are few reasons - around corner cases , starting from a region-split
to any minor compactions during write process, general recommendation is to
not use guide posts for query processing - or - disable guideposts so the
consistency is guaranteed


On Tue, Aug 20, 2019 at 11:10 AM jesse <chat2jesse@gmail.com> wrote:

> 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
>>>>>>
>>>>>>
>>>>>>

-- 
*Venkata Subbarayudu Amanchi.*

Mime
View raw message