create table tableName
(
ID SERIAL,
column1 VARCHAR(12),
column2 TIMESTAMP,
column3 TEXT,
column4 Numeric,
...........
)
WITH (appendonly=true, COMPRESSTYPE=quicklz, OIDS=FALSE, orientation=column)
DISTRIBUTED BY (ID)
PARTITION BY RANGE (column2)
(
START (date '2010-01-01') INCLUSIVE
END (date '2019-12-31') INCLUSIVE
EVERY (INTERVAL '10 day')
);
(
ID SERIAL,
column1 VARCHAR(12),
column2 TIMESTAMP,
column3 TEXT,
column4 Numeric,
...........
)
WITH (appendonly=true, COMPRESSTYPE=quicklz, OIDS=FALSE, orientation=column)
DISTRIBUTED BY (ID)
PARTITION BY RANGE (column2)
(
START (date '2010-01-01') INCLUSIVE
END (date '2019-12-31') INCLUSIVE
EVERY (INTERVAL '10 day')
);
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
