Re: cannot drop a table in Phoenix

[Mich Talebzadeh]

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
*



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.



On 19 October 2016 at 06:08, Divya Gehlot  wrote:

> 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
>>
>> 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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>> *
>>
>>
>>
>> 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.
>>
>>
>>
>
>

Re: cannot drop a table in Phoenix

[Divya Gehlot]

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
>
> 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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> *
>
>
>
> 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.
>
>
>

Re: cannot drop a table in Phoenix

[Yang Zhang]

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 :

> 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 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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>> *
>>
>>
>>
>> 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.
>>
>>
>>
>

Re: cannot drop a table in Phoenix

[Dong iL, Kim]

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 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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> *
>
>
>
> 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.
>
>
>

cannot drop a table in Phoenix

[Mich Talebzadeh]

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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
*



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.