Selection

You can select which partitions to use for SELECT, DELETE, INSERT, REPLACE, UPDATE, LOAD DATA, LOAD XML operations. The partition clause usually follows the table name.

SELECT a, b FROM tbl PARTITION (p1,p2);

DELETE FROM tbl PARTITION (p0, p1) WHERE a=10;