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=81&rev2=82
--------------------------------------------------
}}}
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).
+ It is also possible to specify parts of a partition specification to filter the resulting
list. Note: This feature is only available starting in version 0.6.
{{{
SHOW PARTITIONS table_name PARTITION(ds='2010-03-03');
SHOW PARTITIONS table_name PARTITION(hr='12');
|