数据仓库服务 GaussDB(DWS)-PARTITION:RANGE_N with comma separated values

时间：2025-02-12 15:05:07

RANGE_N with comma separated values

输入：

CREATE TABLE orders10    (storeid INTEGER NOT NULL    ,productid INTEGER NOT NULL    ,orderdate DATE NOT NULL    ,totalorders INTEGER NOT NULL)    PRIMARY INDEX (storeid, productid)      PARTITION BY ( RANGE_N(totalorders BETWEEN *, 100, 1000 AND *) );

输出：

CREATE TABLE orders10    (storeid INTEGER NOT NULL    ,productid INTEGER NOT NULL    ,orderdate DATE NOT NULL    ,totalorders INTEGER NOT NULL)DISTRIBUTE BY HASH (storeid, productid) PARTITION BY RANGE (totalorders)   ( PARTITION Orders10_0 END (100),     PARTITION Orders10_1 END (1000),     PARTITION Orders10_2 END (MAXVALUE)   );

上一篇：数据仓库服务 GaussDB(DWS)-PARTITION:RANGE_N在字符串列的分区

下一篇：数据仓库服务 GaussDB(DWS)-PARTITION:RANGE_N with * for start-date