Select/drop records by partitions

1.  To select records in a table using partitions, use below query.
SELECT * FROM <tableName> PARTITION (<partitionName>);
2. To drop records in a table using partitions, use below query.
ALTER TABLE <tableName> DROP PARTITION <partitionName>;