A Log table named log in MaxCompute is a partition table, and the partition key is dt. Anew partition is created daily to store the new data of that day. Now we have one month’s data, starting from dt=’20180101′ to dt=’20180131′, and we may use ________ to delete the data on 20180101.

A Log table named log in MaxCompute is a partition table, and the partition key is dt. Anew partition is created daily to store the new data of that day. Now we have one month’s data, starting from dt=’20180101′ to dt=’20180131′, and we may use ________ to delete the data on 20180101.
A . delete from log where dt=’20180101′
B . truncate table where dt=’20180101′
C . drop partition log (dt=’20180101′)
D . alter table log drop partition(dt=’20180101′)

View Answer

Answer: D