Like I said before, no it's not ok to drop system tables. If for some reason you don't want the sequence table presplit 256 ways, you can set the phoenix.sequence.saltBuckets to specify how many pre-split regions you'd like it to have (including setting it to 0).
On Sun, Dec 21, 2014 at 5:38 PM, chenwenhui <[email protected]> wrote: > Hi James, > Thanks for your reply. > The SYSTEM.SEQUENCE contains 256 regions by default, it looks like a large > number. > I ever tried to drop the table, but find that the sequence function became > no-effect. My application should not use the sequence function for ever, > are there other side-effect if dropping the SYSTEM.SEQUENCE table? > If existing other side-effect indeed, how to reduce the region number? > Thank again. > > > > > > > At 2014-12-20 15:13:33, "James Taylor" <[email protected]> wrote: >>Hi, >>The system tables store and manage your metadata (i.e. tables, their >>columns, views, sequences, indexes, etc.). You should leave them >>alone. Phoenix manages (reads/writes) to these tables when necessary. >>Thanks, >>James >> >>On Thu, Dec 18, 2014 at 6:30 PM, chenwenhui <[email protected]> wrote: >>> Do nobody almost care these system tables? >>> >>> > > >
