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

[Apache Wiki <wi...@apache.org>]

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=41&rev2=42

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

  }}}
  SHOW PARTITIONS lists all the existing partitions for a given table. Partitions are listed in alphabetical order.
  
+ === Show Table/Partitions Extended===
+ {{{
+ 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 Functions ===
  {{{
  SHOW FUNCTIONS "a.*"