9

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,277
  • 2
  • 22
  • 34

4 Answers4

5

Using the Phoenix sqlline tool: !describe <table>

kliew
  • 2,687
  • 1
  • 11
  • 25
0

This solution works great.

SELECT column_name
  FROM system.catalog
  WHERE table_name = 'your_table' AND key_seq IS NOT NULL
Evhz
  • 7,265
  • 7
  • 39
  • 61
-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
  • 882
  • 1
  • 9
  • 16
-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
  • 18,451
  • 2
  • 83
  • 95