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. http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL?action=diff&rev1=52&rev2=53 -------------------------------------------------- }}} 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)]
