Hello , I'm using Impala 5.9 and I would like to drop the sub-partitions of a certain partition.
For example I have a table with 2 partitioned columns, Year & Month.
So If I want to drop all the months of a certain Year I have to run the following command 12 times
ALTER TABLE schema.Table DROP IF EXISTS PARTITION (year=2018, month='...')
When I run sth like that :
ALTER TABLE schema.Table DROP IF EXISTS PARTITION (year=2018) in order to drop all the sub-partitions at once It gives me the following error:
<< Items in partition spec must exactly match the partition columns in the table definition: schema.Table (1 vs 2) >>
Can you suggest me a way to run one command and drop many partitions at once ?