Yes, the consequences could be bad as you're bypassing the API that drops a table (which does more than just update the SYSTEM. CATALOG). Please see the recommendations in the previous emails.

On Mon, Jan 16, 2017 at 10:45 PM Batyrshin Alexander <> wrote:
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 <> 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.