DESCRIBE TABLE

Synopsis:

  1. DESCRIBE
  2.     [table identifier | 
  3.     [LIKE pattern]]

single table identifier or double quoted es multi index

SQL LIKE pattern

or

  1. DESC
  2.     [table identifier | 
  3.     [LIKE pattern]]

single table identifier or double quoted es multi index

SQL LIKE pattern

Description: DESC and DESCRIBE are aliases to SHOW COLUMNS.

  1. DESCRIBE emp;
  3.        column       |     type      |    mapping
  4. --------------------+---------------+---------------
  5. birth_date          |TIMESTAMP      |datetime
  6. dep                 |STRUCT         |nested
  7. dep.dep_id          |VARCHAR        |keyword
  8. dep.dep_name        |VARCHAR        |text
  9. dep.dep_name.keyword|VARCHAR        |keyword
  10. dep.from_date       |TIMESTAMP      |datetime
  11. dep.to_date         |TIMESTAMP      |datetime
  12. emp_no              |INTEGER        |integer
  13. first_name          |VARCHAR        |text
  14. first_name.keyword  |VARCHAR        |keyword
  15. gender              |VARCHAR        |keyword
  16. hire_date           |TIMESTAMP      |datetime
  17. languages           |TINYINT        |byte
  18. last_name           |VARCHAR        |text
  19. last_name.keyword   |VARCHAR        |keyword
  20. salary              |INTEGER        |integer