ALTER TABLE table_name DROP [IF EXISTS] PARTITION (partition_spec) [,PARTITION (partition_spec), ...]partition_spec:: partition_column = partition_col_value, partition_column = partition_col_value, ...
table_name: Name of the target table
partition_column: Partitioning column name
partition_col_value: Partitioning column valueALTER TABLE page_view DROP PARTITION (dt='2008-08-08', country='us')ALTER TABLE `page_view` DROPPARTITION (`dt` = '2008-08-08', `country` = 'us'),PARTITION (`dt` = '2008-08-08', `country` = 'us'),PARTITION (`dt` = '2008-08-08', `country` = 'us')
피드백