database - Vertica 在日期时间 :TIMESTAMPTZ 按周分区

Question

如何在日期时间按周进行分区:TIMESTAMPTZ。

我试过了

CREATE TABLE abc(time_stamp TIMESTAMPTZ NOT NULL) PARTITION BY EXTRACT (week FROM time_stamp);

ERROR 2552:  Cannot use meta function or non-deterministic function in PARTITION BY expression

Answer 1

如果您确信永远不会有同一周超过一年的数据，您只需将 AT TIME ZONE 部分添加到 TIMESTAMPTZ 类型:

CREATE TABLE public.test (
  date      TIMESTAMPTZ NOT NULL
) PARTITION BY WEEK(date AT TIME ZONE 'UTC');

否则，我会建议将 YEAR 添加到分区子句中。