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