phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Batyrshin Alexander <0x62...@gmail.com>
Subject Re: How to recreate table?
Date Tue, 17 Jan 2017 06:45:11 GMT
I've discovered that i can simple delete schema 
Like this:
delete from SYSTEM.CATALOG where "TABLE_NAME" = 'my_table_name';
Is this action has any consequence?

> On 16 Jan 2017, at 19:51, Josh Elser <josh.elser@gmail.com> wrote:
> 
> You could create a new table with the same schema and then flip the underlying table
out.
> 
> * Rename the existing table to "foo"
> * Create your table via Phoenix with correct schema and desired name
> * Delete underlying HBase table that Phoenix created
> * Rename "foo" to the desired name
> 
> I _think_ that would work.
> 
> Batyrshin Alexander wrote:
>>  Hello,
>> I've recreated HBase table with data, but phoenix doesn't work on it. But i still
see this table in phoenix.
>> How can I recreate pheonix table now?
>> As I know "drop table ... ; create table ..." in phoenix will destroy my HBase table
with data.


Mime
View raw message