OK, and then delete the table within HBase as well I assume?
From: James Taylor [mailto:jamestay...@apache.org]
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
mmcallis...@homeaway.commailto:mmcallis...@homeaway.com 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
mmcallis...@homeaway.commailto:mmcallis...@homeaway.com | C:
512.423.7447tel:512.423.7447 | skype:
michael.mcallister.hamailto:zimmk...@hotmail.com | webex:
https://h.a/mikewebex
[cid:image001.png@01D0DFE4.60ED0CF0]
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
jamestay...@apache.orgmailto:jamestay...@apache.org 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
mmcallis...@homeaway.commailto:mmcallis...@homeaway.com 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
mmcallis...@homeaway.commailto:mmcallis...@homeaway.com | C:
512.423.7447tel:512.423.7447 | skype:
michael.mcallister.hamailto:zimmk...@hotmail.com | 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.