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 <avsrit2...@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, <chat2je...@gmail.com> wrote: > >> And the table is simple and has no index set up. >> >> On Mon, Aug 19, 2019, 6:03 PM jesse <chat2je...@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 <jamestay...@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 <chat2je...@gmail.com> wrote: >>>> >>>>> I have a table is SALT_BUCKETS = 12, but it has 14 regions, is this >>>>> right? >>>>> >>>>> Thanks >>>>> >>>>> >>>>>