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 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.el...@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. > > > >
