DROP TABLE measurement


//创建主表

CREATE TABLE measurement(

    p_day         int not null,

    p_city        varchar not null,

    peaktemp        int,

    unitsales       int

) PARTITION BY LIST (p_city);

//创建一级分区表

CREATE TABLE measurement_c_beijing PARTITION OF measurement

    FOR VALUES IN ('beijing')

    PARTITION BY RANGE (p_day);

    
//创建二级分区表

CREATE TABLE measurement_c_beijing_20191101 PARTITION OF measurement_c_beijing

    FOR VALUES FROM () TO ();

//插入测试数据

insert into measurement values (, 'beijing', ,);//成功

insert into measurement values (, 'beijing', ,);//成功

insert into measurement values (, 'beijing', ,);//失败，因为没有该分区

insert into measurement values (, 'beijing', ,);//失败，同上

select * from measurement