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 JohnSichi
Date Thu, 11 Mar 2010 04:29:00 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 JohnSichi.
http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL?action=diff&rev1=51&rev2=52

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

  }}}
  SHOW TABLE EXTENDED will list information for all tables matching the given regular expression.
Users can not use regular expression for table name if a partition specification is present.
This command's output includes basic table information and file system information like totalNumberFiles,
totalFileSize, maxFileSize, minFileSize,lastAccessTime, and lastUpdateTime. If partition is
present, it will output the given partition's file system information instead of table's file
system information.
  
- For a view, SHOW TABLE EXTENDED can be used to retrieve the view's definition.  Two relevant
attributes are provided:  both the original view definition as specified by the user, and
an expanded definition used internally by Hive.
- 
  === Show Functions ===
  {{{
  SHOW FUNCTIONS "a.*"
@@ -345, +343 @@

  
  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.
  
+ For a view, DESCRIBE TABLE EXTENDED can be used to retrieve the view's definition.  Two
relevant attributes are provided:  both the original view definition as specified by the user,
and an expanded definition used internally by Hive.
+ 
+ 
  === Describe Partition ===
  {{{
  DESCRIBE [EXTENDED] table_name partition_spec

Mime
View raw message