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 PaulYang
Date Tue, 16 Mar 2010 19:03:11 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 PaulYang.


  SHOW PARTITIONS lists all the existing partitions for a given base table. Partitions are
listed in alphabetical order.
+ It is also possible to specify parts of a partition specification to filter the resulting
list. Note: This feature is only available in version 0.6 (trunk).
+ {{{
+ SHOW PARTITIONS table_name PARTITION(ds='2010-03-03');
+ SHOW PARTITIONS table_name PARTITION(hr='12');
+ SHOW PARTITIONS table_name PARTITION(ds='2010-03-03', hr='12');
+ }}}
  === Show Table/Partitions Extended ===
  SHOW TABLE EXTENDED [IN|FROM database_name] LIKE identifier_with_wildcards [PARTITION(partition_desc)]

View raw message