CREATE TABLE "t_p_range" (
"A" datetime DEFAULT NULL,
"B" varchar(20) DEFAULT NULL
) ENGINE=EXPRESS DISTRIBUTED BY('b')
PARTITION BY RANGE (a)
(PARTITION p_0 VALUES LESS THAN (20200101000000) TABLESPACE = 'sys_tablespace' ENGINE = EXPRESS,
PARTITION p_1 VALUES LESS THAN (20200201000000) TABLESPACE = 'sys_tablespace' ENGINE = EXPRESS);
insert into t_p_range values('2019-10-10','aaa');
insert into t_p_range values('2020-01-10','bbb');
gbase> select * from t_p_range;
+---------------------+------+
| A | B |
+---------------------+------+
| 2019-10-10 00:00:00 | aaa |
| 2020-01-10 00:00:00 | bbb |
+---------------------+------+
2 rows in set (Elapsed: 00:00:00.12)
gbase> select * from t_p_range partition(p_0);
+---------------------+------+
| A | B |
+---------------------+------+
| 2019-10-10 00:00:00 | aaa |
+---------------------+------+
1 row in set (Elapsed: 00:00:00.05)
gbase> select * from t_p_range partition(p_1);
+---------------------+------+
| A | B |
+---------------------+------+
| 2020-01-10 00:00:00 | bbb |
+---------------------+------+
1 row in set (Elapsed: 00:00:00.05)
