Hi all,
I recently created a Phoenix table over a huge existing HBase table (~1TB)
using the following SQL:
CREATE TABLE “table_name" ( PK VARCHAR NOT NULL PRIMARY KEY, "a"."id”
VARCHAR, "a"."created_at" VARCHAR ) DEFAULT_COLUMN_FAMILY = 'a’;
I can’t recall exactly but the command either failed or took too much time that
I interrupted it. However, the Phoenix table still seemed successfully created.
I was able to query against it in SQLLine, build views over it, etc. So I
didn’t worry much.
Then I decided to drop the “created_at” column. Again it took so long a time so
I interrupted it. (probably shouldn’t have). But the column appeared dropped.
Queries and views still work fine. But now I am worried that the Phoenix table
may be invalid after my two interruptions.
Is there any way I can verify its validity. Or any way I can drop **only** the
Phoenix schema (preserve HBase data), and build the table again?
Thanks,
Simon
