带子分区查询
gbase>
create table t1 (id int)
partition by range(id)
subpartition by hash(id)
(
partition p0 values less than (100)
( subpartition p0_sp0,
subpartition p0_sp1
) ,
partition p1 values less than (200)
(
subpartition p1_sp0,
subpartition p1_sp1));
Query OK, 0 rows affected (Elapsed: 00:00:00.14)
gbase>
insert into t1 values (1),(2),(3),(4),(5);
Query OK, 5 rows affected (Elapsed: 00:00:00.10)
Records: 5 Duplicates: 0 Warnings: 0
gbase>
insert into t1 values (101),(102),(103),(104),(105);
Query OK, 5 rows affected (Elapsed: 00:00:00.10)
Records: 5 Duplicates: 0 Warnings: 0
gbase>
select * from t1 partition(p0,p1_sp0);
+------+
| id |
+------+
| 2 |
| 4 |
| 1 |
| 3 |
| 5 |
| 102 |
| 104 |
+------+
7 rows in set (Elapsed: 00:00:00.04)
