为了更快的定位您的问题,请提供以下信息,谢谢
【详述】问题详细描述 创建oss 备份后无法恢复到本地
【背景】做过哪些操作?创建仓库,备份后执行恢复报错
【StarRocks版本】例如:3.15
【集群规模】例如:3fe(1 follower+2observer)+3be(fe与be混部)
【表模型】例如:聚合模型
【导入或者导出方式】例如:Flink
CREATE REPOSITORY tjn
WITH BROKER
ON LOCATION “oss://sr-back/”
PROPERTIES(
“fs.oss.accessKeyId” = “",
“fs.oss.accessKeySecret” = "”,
“fs.oss.endpoint” = “oss-cn-beijing.aliyuncs.com”
);
BACKUP SNAPSHOT st_status.tjn20231211type
TO tjn
on (st_stats_visitor_type);
RESTORE SNAPSHOT st_status.tjn20231210type
FROM st_buck_test
ON (st_stats_visitor_type)
PROPERTIES (
“backup_timestamp”=“2023-12-10-13-08-29-012”
);
CREATE TABLE IF NOT EXISTS st_stats_visitor_type
(
pv
int(11) DEFAULT “0” COMMENT “pv总数”,
uv
int(11) DEFAULT “0” COMMENT “uv总数”,
ip
int(11) DEFAULT “0” COMMENT “ip总数”,
vv
int(11) DEFAULT “0” COMMENT “会话总数”,
bounce
int(11) DEFAULT “0” COMMENT “跳出总数”,
duration
int(11) DEFAULT “0” COMMENT “浏览时长”,
date
DATE COMMENT ‘创建时间-日期’,
month
int DEFAULT “0” COMMENT ‘创建时间-月’,
hour
int DEFAULT “0” COMMENT ‘创建时间-时’,
week
int DEFAULT “0” COMMENT ‘创建时间-周’,
star_time
datetime COMMENT “统计时间”,
end_time
datetime COMMENT “统计时间”,
domain_id
bigint(20) COMMENT “网站ID”,
user_id
bigint(20) COMMENT “用户id”,
referer_type
tinyint(4) COMMENT “来路类型,1:直接访问,2:搜索引擎,3:外部链接”,
referer_domain
varchar(255) COMMENT “来路域名,直接访问为空,搜索引擎为引擎id,外部链接为外部域名”,
province
varchar(64) COMMENT “省”,
city
varchar(64) COMMENT “城市”,
country
varchar(64) COMMENT “国家”,
client_type
tinyint(4) DEFAULT “0” COMMENT “客户端类型,0为电脑端,1为移动端”,
type
tinyint(4) COMMENT “访客类型:0为新访客,1为老访客”
) ENGINE=OLAP
DUPLICATE KEY(pv
, uv
, ip
, vv
, bounce
, duration
)
COMMENT “访客类型统计表”
PARTITION BY RANGE (star_time) (
START ("2023-09-01") END ("2030-01-01") EVERY (INTERVAL 1 DAY)
)
DISTRIBUTED BY HASH(domain_id
)
PROPERTIES (
“replication_num” = “3”,
“in_memory” = “false”,
“enable_persistent_index” = “false”,
“replicated_storage” = “true”,
“compression” = “ZSTD”
);