You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-commits@hadoop.apache.org by Apache Wiki <wi...@apache.org> on 2009/07/08 00:57:19 UTC

[Hadoop Wiki] Update of "Hive/LanguageManual/DDL" by ZhengShao

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.

The following page has been changed by ZhengShao:
http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL

------------------------------------------------------------------------------
  === Describe Table/Column ===
  {{{
  DESCRIBE [EXTENDED] table_name[DOT col_name]
+ DESCRIBE [EXTENDED] table_name[DOT col_name ([DOT field_name]|[DOT '$elem$']|[DOT '$key$']|[DOT '$value$'] ]
  }}}
  
  DESCRIBE TABLE shows the list of columns including partition column for the given table. If EXTENDED keyword is specified then it will show all the metadata for the table in Thrift serialized form. This is generally only useful for debugging and not for general use.
  
- If a table has complex column then you can examine the attributes of this column by specifying table_name.complex_col_name. You can specify this recursively to explore the complex column type.
+ If a table has complex column then you can examine the attributes of this column by specifying table_name.complex_col_name (and '$elem$' for array element, '$key$' for map key, and '$value$' for map value). You can specify this recursively to explore the complex column type.
  
  === Describe Partition ===
  {{{