doris 自动分区与动态分区结合试用问题。

Viewed 26
2.1

Version : doris-2.1.7-rc03

BuildInfo : vm-36

BuildTime : Wed, 06 Nov 2024 15:32:04 CST

建表语句：
CREATE TABLE IF NOT EXISTS yq_log (
log_time datetime(3) NOT NULL COMMENT "记录日志时的时间（年月日时分秒）",
host_name VARCHAR(30) NOT NULL DEFAULT "" COMMENT "服务器名称",
app_name VARCHAR(30) NOT NULL DEFAULT "" COMMENT "业务服务",
thread VARCHAR(100) NOT NULL DEFAULT "" COMMENT "线程名",
class_method VARCHAR(200) NULL DEFAULT "" COMMENT "类名.方法名:行号",
line VARCHAR(7) NULL DEFAULT "" COMMENT "行号",
level VARCHAR(30) NULL DEFAULT "" COMMENT "日志级别",
message VARCHAR(65532) NULL DEFAULT "" COMMENT "日志信息"
) ENGINE = olap
DUPLICATE KEY(log_time, host_name, app_name, thread) PARTITION BY RANGE (log_time) (
-- 初始分区可以省略，由动态分区规则自动管理
)
auto partition by range (date_trunc(log_time, 'month'))
(
)
DISTRIBUTED BY HASH(log_time) BUCKETS 16
PROPERTIES(
"replication_num" = "1", -- 副本书为1，多节点可以配置多个
"dynamic_partition.enable" = "true", -- 启用动态分区
"dynamic_partition.time_unit" = "month", -- 分区单位为周
"dynamic_partition.start" = "-72", -- 从当前月开始创建分区
"dynamic_partition.end" = "0", -- Dynamic Partition 不创建分区 自动创建
"dynamic_partition.prefix" = "p", -- 分区前缀
"dynamic_partition.buckets" = "16", -- 分区桶数
"dynamic_partition.create_history_partition" = "false" -- 不创建历史分区
);

提示：
Execution failed: Error Failed to execute sql: org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error in line 14: auto partition by range (date_trunc(log_time, 'month')) ^ Encountered: AUTO Expected

wang1
2 Answers

参考我这个例子改一下

CREATE TABLE IF NOT EXISTS yq_log
(
`log_time` datetime(3) NOT NULL COMMENT "报告生成日期，统一是当月1日的0点。时间戳形式，1970年元旦以来的秒数",
orderid varchar(20) not null comment "订单号",
`cruise_id` int(11) not NULL
)
DUPLICATE KEY(`log_time`, `orderid`,`cruise_id`)
auto partition by range (date_trunc(log_time, 'month'))
(
)
DISTRIBUTED BY HASH(log_time) BUCKETS 16
PROPERTIES(
"replication_num" = "1", -- 副本书为1，多节点可以配置多个
"dynamic_partition.enable" = "true", -- 启用动态分区
"dynamic_partition.time_unit" = "month", -- 分区单位为周
"dynamic_partition.start" = "-72", -- 从当前月开始创建分区
"dynamic_partition.end" = "0", -- Dynamic Partition 不创建分区 自动创建
"dynamic_partition.prefix" = "p", -- 分区前缀
"dynamic_partition.buckets" = "16", -- 分区桶数
"dynamic_partition.create_history_partition" = "false" -- 不创建历史分区
)
黄海军@SelectDB4528

我把log_time 加上'就可以了。谢谢

wang1