phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: How to recreate table?
Date Wed, 18 Jan 2017 16:30:15 GMT
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 <0x62ash@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.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