I think you'll need to resort to manually deleting from the SYSTEM.CATALOG table. Something like the following:
DELETE FROM SYSTEM.CATALOG WHERE TENANT_ID IS NULL AND TABLE_SCHEM = 'MYSCHEMA' AND TABLE_NAME = 'MYTABLE'; You'll need to bounce your cluster to cause the server-side cache to be cleared too. On Tue, Aug 25, 2015 at 10:29 AM, Michael McAllister < [email protected]> wrote: > James > > We’re on Phoenix 4.2 on HDP 2.2.6. > > I’ve tried reproducing the problem and I can’t. My issue is specific to > these two tables. When I try recreating the exact same table I can drop it. > I’m willing to do some digging on these tables if it will help you, but in > the end what I’d like to do is get them dropped. > > Michael McAllister > Staff Data Warehouse Engineer | Decision Systems > [email protected] | C: 512.423.7447 | skype: michael.mcallister.ha > <[email protected]> | webex: https://h.a/mikewebex > > > This electronic communication (including any attachment) is confidential. > If you are not an intended recipient of this communication, please be > advised that any disclosure, dissemination, distribution, copying or other > use of this communication or any attachment is strictly prohibited. If you > have received this communication in error, please notify the sender > immediately by reply e-mail and promptly destroy all electronic and printed > copies of this communication and any attachment. > > On Aug 24, 2015, at 10:48 PM, James Taylor <[email protected]> wrote: > > Hi Michael, > What version are you on over there? Can you setup a test that consistently > reproduces the issue? > Thanks, > James > > On Mon, Aug 24, 2015 at 8:20 PM, Michael McAllister < > [email protected]> wrote: > >> Hi >> >> I have an empty table that, when I try and drop, I get an error returned. >> >> I issue a command similar to the following:- >> >> drop table myschema.mytable; >> >> I get the following error:- >> >> 22:17:53 [DROP - 0 row(s), 0.276 secs] [Error Code: 101, SQL State: >> 08000] org.apache.hadoop.hbase.DoNotRetryIOException: MYSCHEMA.MYTABLE: 29 >> at >> org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84) >> at >> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.dropTable(MetaDataEndpointImpl.java:965) >> at >> org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService.callMethod(MetaDataProtos.java:7768) >> at >> org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:6896) >> at >> org.apache.hadoop.hbase.regionserver.HRegionServer.execServiceOnRegion(HRegionServer.java:3420) >> at >> org.apache.hadoop.hbase.regionserver.HRegionServer.execService(HRegionServer.java:3402) >> at >> org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:29998) >> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2078) >> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:108) >> at >> org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:114) >> at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:94) >> at java.lang.Thread.run(Thread.java:745) >> Caused by: java.lang.ArrayIndexOutOfBoundsException: 29 >> at org.apache.phoenix.schema.PTableImpl.init(PTableImpl.java:320) >> at org.apache.phoenix.schema.PTableImpl.<init>(PTableImpl.java:250) >> at org.apache.phoenix.schema.PTableImpl.makePTable(PTableImpl.java:240) >> at >> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.getTable(MetaDataEndpointImpl.java:638) >> at >> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.buildTable(MetaDataEndpointImpl.java:376) >> at >> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.doDropTable(MetaDataEndpointImpl.java:985) >> at >> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.dropTable(MetaDataEndpointImpl.java:939) >> ... 10 more >> ... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: >> 0.276/0.000 sec [0 successful, 0 warnings, 1 errors] >> >> >> Michael McAllister >> Staff Data Warehouse Engineer | Decision Systems >> [email protected] | C: 512.423.7447 | skype: michael.mcallister.ha >> <[email protected]> | webex: https://h.a/mikewebex >> >> <image002.png> >> This electronic communication (including any attachment) is >> confidential. If you are not an intended recipient of this communication, >> please be advised that any disclosure, dissemination, distribution, copying >> or other use of this communication or any attachment is strictly >> prohibited. If you have received this communication in error, please >> notify the sender immediately by reply e-mail and promptly destroy all >> electronic and printed copies of this communication and any attachment. >> >> > >
