hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Hadoop Wiki] Update of "Hive/LanguageManual/DDL" by spookysam
Date Tue, 19 Apr 2011 14:38:20 GMT
Dear Wiki user,

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

The "Hive/LanguageManual/DDL" page has been changed by spookysam.
http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL?action=diff&rev1=85&rev2=86

--------------------------------------------------

  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 columns for the given table.
If the 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 and [[http://itshumour.blogspot.com/2010/06/twenty-hilarious-funny-quotes.html
Funny Quotes]]
+ DESCRIBE TABLE shows the list of columns including partition columns for the given table.
If the 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 and [[http://itshumour.blogspot.com/2010/06/twenty-hilarious-funny-quotes.html|Funny
Quotes]]
  
  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.
  

Mime
View raw message