10

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

Weibo Li
  • 3,565
  • 3
  • 24
  • 36

4 Answers4

4

Using the Phoenix sqlline tool: !describe <table>

kliew
  • 3,073
  • 1
  • 14
  • 25
1

This solution works great.

SELECT column_name
  FROM system.catalog
  WHERE table_name = 'your_table' AND key_seq IS NOT NULL
Evhz
  • 8,852
  • 9
  • 51
  • 69
-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.

Chux Uzoeto
  • 1,324
  • 1
  • 12
  • 19
-3

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

Thomas Decaux
  • 21,738
  • 2
  • 113
  • 124