表history_t的DDL如下所示,该表一共有多少个分区?

表history_t的DDL如下所示,该表一共有多少个分区?
CREATE TABLE history_t(user_id INT, gmt_create DATETIME, info VARCHAR(20), PRIMARY KEY(user_id, gmt_create))
PARTITION BY RANGE COLUMNS(gmt_create)
SUBPARTITION BY HASH(user_id) SUBPARTITIONS 3
(PARTITION p0 VALUES LESS THAN(‘2024-11-11’),
PARTITION p1 VALUES LESS THAN(‘2025-11-11’),
PARTITION p2 VALUES LESS THAN(‘2026-11-11’),
PARTITION p3 VALUES LESS THAN(‘2027-11-11’));

A. 4
B. 3
C. 7
D. 12

答案:D

2 个赞