Same thing happened to us as well. We deleted the info from the system table for the corresponding table and then dropped the table from hbase shell.
We are on phoenix 2.2.1 and hbase 94.7 Since it anyways throws a invalid ddl exception, it shouldn't be adding anything to the meta table On Jun 16, 2014 5:12 AM, "Ravi Kiran" <maghamraviki...@gmail.com> wrote: > Hi Russel, > When recreating the table, does it complain of a TABLE_ALREADY_EXIST > exception? > > If possible, can you please confirm if you see the table 'DEV_HET_MEF' > from the zookeeper client ( zkcli.sh) > a ) hbase zkcli -server <host>:<port> > b) ls /hbase/table/ > If so, you can remove it by running rmr /hbase/table/DEV_HET_MEF > > Also ,can you please let me know which version of Phoenix are you using to > help see if I can reproduce the problem. > > Regards > Ravi > > > > On Sun, Jun 15, 2014 at 12:58 PM, Russell Jurney <russell.jur...@gmail.com > > wrote: > >> We created a table with duplicate fields by mistake. Now we are unable >> to drop the table: >> >> >> 0: jdbc:phoenix:hiveapp1> drop table DEV_HET_MEF; >> Error: org.apache.hadoop.hbase.DoNotRetryIOException: DEV_HET_MEF: 28 >> at >> com.salesforce.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:83) >> at >> com.salesforce.phoenix.coprocessor.MetaDataEndpointImpl.dropTable(MetaDataEndpointImpl.java:578) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:606) >> at org.apache.hadoop.hbase.regionserver.HRegion.exec(HRegion.java:5490) >> at >> org.apache.hadoop.hbase.regionserver.HRegionServer.execCoprocessor(HRegionServer.java:3720) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:606) >> at >> org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:320) >> at >> org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1428) >> Caused by: java.lang.ArrayIndexOutOfBoundsException: 28 >> at com.salesforce.phoenix.schema.PTableImpl.init(PTableImpl.java:213) >> at com.salesforce.phoenix.schema.PTableImpl.<init>(PTableImpl.java:181) >> at >> com.salesforce.phoenix.schema.PTableImpl.makePTable(PTableImpl.java:176) >> at >> com.salesforce.phoenix.coprocessor.MetaDataEndpointImpl.getTable(MetaDataEndpointImpl.java:381) >> at >> com.salesforce.phoenix.coprocessor.MetaDataEndpointImpl.buildTable(MetaDataEndpointImpl.java:215) >> at >> com.salesforce.phoenix.coprocessor.MetaDataEndpointImpl.doDropTable(MetaDataEndpointImpl.java:595) >> at >> com.salesforce.phoenix.coprocessor.MetaDataEndpointImpl.dropTable(MetaDataEndpointImpl.java:558) >> ... 12 more (state=08000,code=101) >> >> >> So I go to hbase shell and drop the table there... >> >> disable 'DEV_HET_MEF' >> >> drop 'DEV_HET_MEF' >> >> >> Finally, I scan 'SYSTEM.TABLE' and remove all rows corresponding to >> 'DEV_HET_MEF'. >> >> Normally this works, and the table should be gone! But this time, the >> table can't be recreated. What should I do? I tried restarting HBase, no >> effect. >> >> Thanks! >> -- >> Russell Jurney twitter.com/rjurney russell.jur...@gmail.com datasyndrome. >> com >> > > -- Email from people at capillarytech.com may not represent official policy of Capillary Technologies unless explicitly stated. Please see our Corporate-Email-Policy for details.Contents of this email are confidential. Please contact the Sender if you have received this email in error.
