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

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.

Answer 2

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

Answer 3

Using the Phoenix sqlline tool: !describe <table>