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 name'
This issue exist in previous version of phoeniex, 2016-10-18 1:38 GMT+08:00 Dong iL, Kim <kim.s...@gmail.com>: > try add system tablespace. > > On Tue, 18 Oct 2016 at 12:41 AM Mich Talebzadeh <mich.talebza...@gmail.com> > 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 table "marketDataHbase"; >> Error: ERROR 1012 (42M03): Table undefined. tableName=marketDataHbase >> (state=42M03,code=1012) >> org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): >> Table undefined. tableName=marketDataHbase >> >> Any ideas what causes it? >> >> Thanks >> >> Dr Mich Talebzadeh >> >> >> >> LinkedIn * >> https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* >> >> >> >> http://talebzadehmich.wordpress.com >> >> >> *Disclaimer:* Use it at your own risk. Any and all responsibility for >> any loss, damage or destruction of data or any other property which may >> arise from relying on this email's technical content is explicitly >> disclaimed. The author will in no case be liable for any monetary damages >> arising from such loss, damage or destruction. >> >> >> >
