LongWangXX commented on issue #30214:
URL: https://github.com/apache/doris/issues/30214#issuecomment-1903378470
建表脚本如下
CREATE TABLE IF NOT EXISTS t_dess_alarm
(
`date` date COMMENT "日期",
`hours` VARCHAR(100) COMMENT "小时",
`md5` VARCHAR(100) COMMENT "组合md5",
`id` VARCHAR(100) REPLACE COMMENT "告警ID",
`title` VARCHAR(100) REPLACE COMMENT "告警标题",
`type` VARCHAR(100) REPLACE COMMENT "告警大类",
`sub_type` VARCHAR(100) REPLACE COMMENT "告警小类",
`source` VARCHAR(100) REPLACE COMMENT "来源",
`level` VARCHAR(100) MAX COMMENT "告警等级",
`content` String REPLACE COMMENT "内容",
`asset_sign` VARCHAR(100) REPLACE COMMENT "资产录入标记1.录入0.未录入",
`src_ip` VARCHAR(100) REPLACE COMMENT "源IP",
`dst_ip` VARCHAR(100) REPLACE COMMENT "目标IP",
`src_port` VARCHAR(100) REPLACE COMMENT "源端口",
`dst_port` VARCHAR(100) REPLACE COMMENT "目标端口",
`protocol` VARCHAR(100) REPLACE COMMENT "协议",
`deal_status` VARCHAR(100) REPLACE COMMENT "是否处置0.未处置1.处置2.误报3.处置中",
`remark` VARCHAR(100) REPLACE COMMENT "备注",
`cnt` INT SUM COMMENT "告警次数",
`class1` VARCHAR(100) REPLACE COMMENT "大类",
`class2` VARCHAR(100) REPLACE COMMENT "小类",
`mail_sign` VARCHAR(100) REPLACE COMMENT "",
`epid` VARCHAR(100) REPLACE COMMENT "",
`alarm_status` VARCHAR(100) REPLACE COMMENT "",
`device_ip` VARCHAR(100) REPLACE COMMENT "",
`ip` VARCHAR(100) REPLACE COMMENT "",
`src_network_area` VARCHAR(100) REPLACE COMMENT "",
`src_business_area` VARCHAR(100) REPLACE COMMENT "",
`dst_network_area` VARCHAR(100) REPLACE COMMENT "",
`dst_business_area` VARCHAR(100) REPLACE COMMENT "",
`src_asset_type` VARCHAR(100) REPLACE COMMENT "",
`dst_asset_type` VARCHAR(100) REPLACE COMMENT "",
`pos_no` VARCHAR(100) REPLACE COMMENT "储能箱编号",
`product_no` VARCHAR(100) REPLACE COMMENT "产品标识",
`object_no` VARCHAR(100) REPLACE COMMENT "设备名",
`type_ch` VARCHAR(100) REPLACE COMMENT "告警中文类型",
`sub_type_ch` VARCHAR(100) REPLACE COMMENT "告警中文子类型",
`alarm_time` VARCHAR(100) MAX COMMENT "告警时间"
)
AGGREGATE KEY(`date`,`hours`,`md5`)
PARTITION BY RANGE(date)()
DISTRIBUTED BY HASH(md5) buckets 10
PROPERTIES(
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.start" = "-180",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "10",
"replication_num" = "3"
)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
