Re: How to recreate table?

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 <0x62...@gmail.com> wrote: > I've discovered that

Re: How to recreate table?

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

Re: How to recreate table?

Couple of other options: 1) connect with a CURRENT_SCN [1] earlier than any timestamp for your data. For example, if you know you created the table a month ago, then use an SCN value of the epoch time for 1/1/2016. Then issue the DROP TABLE command from that connection and no data will be removed.

Re: How to recreate table?

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_

How to recreate table?

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.