数据仓库服务 GAUSSDB(DWS)-快速创建时序表:创建时序表（手动设置分区边界）

时间：2024-05-11 08:28:19

创建时序表（手动设置分区边界）

手动指定分区边界的起始值，例如手动设置默认的分区边界时间P1为“2022-05-30 16:32:45”、P2为“2022-05-31 16:56:12”，创建时序表GENERATOR1如下：

    
     
       
       
         CREATE TABLE IF NOT EXISTS GENERATOR1(
genset text TSTag,
manufacturer text TSTag,
model text TSTag,
location text TSTag,
ID bigint TSTag,
voltage numeric TSField,
power bigint TSField,
frequency numeric TSField,
angle numeric TSField,
time timestamptz TSTime) with (orientation=TIMESERIES, period='1 day') distribute by hash(model)
partition by range(time)
(
PARTITION P1 VALUES LESS THAN('2022-05-30 16:32:45'),
PARTITION P2 VALUES LESS THAN('2022-05-31 16:56:12')
);

        

      

    
   

查询当前时间：

    
         select now(); 
             now 
------------------------------- 
2022-05-31 20:36:09.700096+08(1 row)

查询分区以及分区边界：

    
         SELECT relname, boundaries FROM pg_partition where parentid=(SELECT oid FROM pg_class where relname='generator1') order by boundaries ;
   relname   |         boundaries 
-------------+----------------------------
p1          | {"2022-05-30 16:32:45+08"}  
p2          | {"2022-05-31 16:56:12+08"}  
p1654073772 | {"2022-06-01 16:56:12+08"} 
p1654160172 | {"2022-06-02 16:56:12+08"} 
......