You are viewing a plain text version of this content. The canonical link for it is here.

Posted to common-commits@hadoop.apache.org by Apache Wiki <wi...@apache.org> on 2011/01/27 23:18:48 UTC

[Hadoop Wiki] Update of "Hive/LanguageManual/DDL" by JohnSichi

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');