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