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.
I've discovered that i can simple delete schema
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 <firstname.lastname@example.org> 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:
>> 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.