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, 21 Jan 2010 02:09:53 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=46&rev2=47

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

  {{{
  SHOW TABLES identifier_with_wildcards
  }}}
- SHOW TABLES lists all the tables matching the given regular expression. Regular expression
can contain only '*' for any character[s] or '|' for a choice. Examples are 'page_view', 'page_v*',
'*view|page*', all which will match 'page_view' table. Matching tables are listed in alphabetical
order. It is not an error if there are no matching tables found in metastore.
+ SHOW TABLES lists all the base tables and views with names matching the given regular expression.
Regular expression can contain only '*' for any character[s] or '|' for a choice. Examples
are 'page_view', 'page_v*', '*view|page*', all which will match 'page_view' table. Matching
tables are listed in alphabetical order. It is not an error if there are no matching tables
found in metastore.
  
  === Show Partitions ===
  {{{
  SHOW PARTITIONS table_name
  }}}
- SHOW PARTITIONS lists all the existing partitions for a given table. Partitions are listed
in alphabetical order.
+ SHOW PARTITIONS lists all the existing partitions for a given base 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 [IN|FROM database_name] LIKE identifier_with_wildcards [PARTITION(partition_desc)]
  }}}
  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 ===
  {{{

Mime
View raw message