Re: cannot drop a table in Phoenix

Hi, I sorted this one out by dropping the row from SYSTEM catalog. THanks Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw *

Re: cannot drop a table in Phoenix

Hi Mich, Which version of Phoenix are you using ? Thanks, Divya On 17 October 2016 at 23:41, Mich Talebzadeh wrote: > Hi, > > I have a table marketDataHbase create on Hbase as seen below: > > [image: Inline images 1] > > > Trying to drop it but it cannot find it > >

Re: cannot drop a table in Phoenix

Hi I met the sam problem before. This may happen when you define your table with duplicate column. such as create table test (id integer primary key,c varchar, c varchar ). you can try to delete you table from system.catalog , maybe like delete * from system.catalog where tablename='your table

Re: cannot drop a table in Phoenix

try add system tablespace. On Tue, 18 Oct 2016 at 12:41 AM Mich Talebzadeh wrote: > Hi, > > I have a table marketDataHbase create on Hbase as seen below: > > [image: Inline images 1] > > > Trying to drop it but it cannot find it > > 0: jdbc:phoenix:rhes564:2181> drop