Example: Emptying a subpartition v16
This example removes the data from a subpartition of the sales
table.
Create the sales
table:
Populate the sales
table:
Query the sales
table to show that the rows were distributed among the subpartitions:
Delete the contents of the 2012_americas
partition:
Query the sales
table to show that the contents of the americas_2012
partition were removed:
The rows were removed, but the structure of the 2012_americas
partition is intact: