OK, and then delete the table within HBase as well I assume?
From: James Taylor [mailto:[email protected]] Sent: Tuesday, August 25, 2015 6:18 PM To: user Subject: Re: Error thrown when trying to drop table 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]<mailto:[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]<mailto:[email protected]> | C: 512.423.7447<tel:512.423.7447> | skype: michael.mcallister.ha<mailto:[email protected]> | webex: https://h.a/mikewebex [cid:[email protected]] 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]<mailto:[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]<mailto:[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]<mailto:[email protected]> | C: 512.423.7447<tel:512.423.7447> | skype: michael.mcallister.ha<mailto:[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.
