17.39. SHOW PARTITIONS
Synopsis
SHOW PARTITIONS FROM table [ WHERE ... ] [ ORDER BY ... ] [ LIMIT ... ]
Description
List the partitions in table
, optionally filtered using the WHERE
clause,
ordered using the ORDER BY
clause and limited using the LIMIT
clause.
These clauses work the same way that they do in a SELECT statement.
Examples
List all partitions in the table orders
:
SHOW PARTITIONS FROM orders;
List all partitions in the table orders
starting from the year 2013
and sort them in reverse date order:
SHOW PARTITIONS FROM orders WHERE ds >= '2013-01-01' ORDER BY ds DESC;
List the most recent partitions in the table orders
:
SHOW PARTITIONS FROM orders ORDER BY ds DESC LIMIT 10;