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:37:31 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=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.*"

Mime
View raw message