Verify validity of Phoenix table

[Simon Wang <si...@airbnb.com>]

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