Example - Emptying a Subpartition v11
The example that follows removes the data from a subpartition of the sales
table. Use the following command to create the sales
table:
Populate the sales
table with the command:
Querying the sales
table shows that the rows have been distributed amongst the subpartitions.
To delete the contents of the 2012_americas
partition, invoke the following command:
Now, querying the sales
table shows that the content of the americas_2012
partition has been removed.
While the rows have been removed, the structure of the 2012_americas
partition is still intact.