How to export table schemas in apache phoenix?

Question

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

Answer 1

This solution works great.

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

Answer 2

Using the Phoenix sqlline tool: !describe <table>