0

Need to drop system table in phoenix.

SYSTEM.CATALOG & SYSTEM.SEQUENCE

drop table SYSTEM.CATALOG;

Table undefined. tableName=SYSTEM.CATALOG 

select * from SYSTEM.CATALOG is working

Also not able to drop from habse. (Saying table not disabled exception)

neeraj
  • 890
  • 2
  • 15
  • 22

1 Answers1

1

You could drop SYSTEM.CATALOG in HBase shell.

haosdent
  • 965
  • 2
  • 8
  • 17
  • I tried to drop from HBase shell also .But it is giving table not disabled exception while table is enabled. – neeraj Jul 16 '14 at 09:24
  • Maybe your metadata of table is illegal. How about try this? http://stackoverflow.com/questions/14557742/table-is-neither-enables-nor-disabled-in-hbase – haosdent Jul 16 '14 at 14:09