How to export table schemas in apache phoenix?

10
votes

I'd like to export the schema of an existing table in apache phoenix. Are there some commands or tools to do the same thing as show create table TABLE_NAME in mysql?

thx

4
hbasephoenix

4 Answers

5
votes

Using the Phoenix sqlline tool: !describe <table>

1
votes

This solution works great.

SELECT column_name
  FROM system.catalog
  WHERE table_name = 'your_table' AND key_seq IS NOT NULL
-1
votes

Apache Phoenix is typically used as a SQL front or interface to a NoSQL DB (like Hadoop). Perhaps it would help if you were more specific about the challenges you are trying to address.

-3
votes

Since "native" HBase is schema-less (you can only specify column families), this is not possible.

Or you could scan some rows to extract columns with types