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=83&rev2=84

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

  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.
+ 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.
  

Reply via email to