phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Yang Zhang <zhang.yang...@gmail.com>
Subject Re: cannot drop a table in Phoenix
Date Wed, 19 Oct 2016 02:44:56 GMT
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.same@gmail.com>:

> try add system tablespace.
>
> On Tue, 18 Oct 2016 at 12:41 AM Mich Talebzadeh <mich.talebzadeh@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.
>>
>>
>>
>

Mime
View raw message