James, We tried the following steps: 1) Dropped SYSTEM.SEQUENCE table from base 1.1) disable 'SYSTEM.SEQUENCE' 1.2) drop 'SYSTEM.SEQUENCE' 2) Deleted SYSTEM.SEQUENCE meta-data from phoenix system tables (SYSTEM.CATALOG, SYSTEM.STATS) 2.1) delete from SYSTEM.CATALOG where table_name = 'SEQUENCE' and table_schem = 'SYSTEM'; 2.2) delete from SYSTEM.STATS where physical_name like '%SYSTEM.SEQUENCE%' or region_name like '%SYSTEM.SEQUENCE%'; 3) Set phoenix.sequence.saltBuckets property to 1 4) Restarted all region servers and master server
Observations: 1. After Master & Region servers are restarted and the client is reconnected I see SYSTEM.SEQUENCE table is re-created in HBase, but not in Phoenix. Do I need to manually insert the SYSTEM.SEQUENCE table meta-data in SYSTEM.CATALOG table? 2. When I list HDFS folder '/apps/hbase/data/data/default/SYSTEM.SEQUENCE', I see it again created 256 regions. Am I missing any steps above? Thanks, Vamsi Attluri. On Fri, Feb 27, 2015 at 9:51 AM, James Taylor <jamestay...@apache.org> wrote: > I'd recommend dropping the SYSTEM.SEQUENCE table from the HBase shell > (instead of deleting the folder in HDFS). Everything else sounded > fine, but make sure to bounce your cluster and restart your clients > after doing this. > > Thanks, > James > > On Thu, Feb 26, 2015 at 12:28 PM, Vamsi Krishna <vamsi.attl...@gmail.com> > wrote: > > Hi, > > > > From phoenix archives I see that we can drop SYSTEM.SEQUENCE table and > set > > 'phoenix.sequence.saltBuckets' property to '1' to see the SYSTEM.SEQUENCE > > table recreated with 1 salt bucket on cluster restart. > > Reference: > > > http://mail-archives.apache.org/mod_mbox/incubator-phoenix-user/201412.mbox/%3ccaaf1jdi4svigfnqy0h45pm2yhiqinpbphgj3ov69qb6dfvw...@mail.gmail.com%3E > > > > But, we are not able to drop the SYSTEM.SEQUENCE table. > > We are seeing the following error when we try to drop the table: > > DROP TABLE SYSTEM."SEQUENCE"; > > Error: ERROR 1010 (42M01): Not allowed to mutate table. > > tableName=SYSTEM.SEQUENCE (state=42M01,code=1010) > > > > How to drop SYSTEM.SEQUENCE table? > > > > Can we delete "default/SYSTEM.SEQUENCE" folder under HBase data > directory on > > HDFS and delete the SYSTEM.SEQUENCE meta data from SYSTEM.CATALOG, > > SYSTEM.STATS tables using below belete queries? > > > > delete from SYSTEM.CATALOG where table_name = 'SEQUENCE' and table_schem > = > > 'SYSTEM'; > > delete from SYSTEM.STATS where physical_name = 'SYSTEM.SEQUENCE'; > > > > Will this create any other issues? > > > > Thanks, > > Vamsi Attluri. >
