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 HeYongqiang
Date Wed, 20 Jan 2010 22:42:13 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 HeYongqiang.
http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL?action=diff&rev1=43&rev2=44

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

  {{{
  SHOW TABLE EXTENDED [ IN|FROM database_name] LIKE identifier_with_wildcards [PARTITION(partition_desc)]
  }}}
- SHOW TABLE EXTENDED will list information for all the tables matching the given regular
expression. If a partition specification is present, it will output table information plus
given partition's file system information. Users can not use regular expression for table
name if a partition specification is present. This command's output includes 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.
+ 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.
  
  === Show Functions ===
  {{{

Mime
View raw message