备份表到oss失败
存算分离：3.3.20-bc0523a
备份语句：
BACKUP SNAPSHOT rx_bd_1000101.dwd_fact_event_se_105001_bak20250401_repo
to wl_qipai_repo
ON (dwd_fact_event_se_105001_bak20250401)
;
报错信息：
SQL 错误 [5064] [42000]: Table: dwd_fact_event_se_105001_bak20250401 can not support backup restore, type: CLOUD_NATIVE
建表语句：
CREATE TABLE dwd_fact_event_se_105001_bak20250401 (
#user_id varchar(65533) NULL COMMENT “用户唯一标识，distinct_id,devicecode组合”,
#create_time datetime NULL COMMENT “数据接入时间”,
#distinct_id varchar(65533) NULL COMMENT “用户唯一标识，一般为OpenID (由CP调用时传入)”,
#devicecode varchar(65533) NULL COMMENT “设备码 (由CP调用时传入)”,
#type varchar(65533) NULL COMMENT “事件类型”,
#time datetime NULL COMMENT “事件发生时间”,
#event varchar(65533) NULL COMMENT “埋点标识 (由CP调用时传入)”,
#uuid varchar(65533) NULL COMMENT “事件UUID”,
#ip varchar(65533) NULL COMMENT “ip地址”,
#cpid bigint(20) NULL COMMENT “CPID”,
#app_id varchar(65533) NULL COMMENT “项目ID”,
#product_id varchar(65533) NULL COMMENT “产品ID”,
#platform_id bigint(20) NULL COMMENT “平台ID 1:安卓, 2：ios, 3:H5, 4:微信小程序”,
#channel_id varchar(65533) NULL COMMENT “渠道ID”,
#sub_channel_id varchar(65533) NULL COMMENT “子渠道ID”,
#1minute varchar(20) NULL COMMENT “时间-每1分钟”,
#5minute varchar(20) NULL COMMENT “时间-每5分钟”,
#10minute varchar(20) NULL COMMENT “时间-每10分钟”,
#1hour varchar(20) NULL COMMENT “时间-每小时”,
#days date NULL COMMENT “日期”,
#year varchar(20) NULL COMMENT “年份”,
#quarter varchar(20) NULL COMMENT “季度”,
#month varchar(20) NULL COMMENT “月份”,
#week varchar(20) NULL COMMENT “周”,
#week_year varchar(20) NULL COMMENT “周所在年”,
#day_of_week varchar(20) NULL COMMENT “星期”,
#day varchar(20) NULL COMMENT “天”,
#calmonth varchar(20) NULL COMMENT “年月”,
#calweek varchar(20) NULL COMMENT “年周”,
#month_last_day varchar(20) NULL COMMENT “是否月末”,
user_id double NULL COMMENT “”,
event_cond_id varchar(65533) NULL COMMENT “事件触发时，对应的控件ID (主要是弹窗类事件，打开时的入口按钮ID/或自动弹出时的弹出条件ID)”,
user_type double NULL COMMENT “”,
game_code double NULL COMMENT “”,
res_358_lv double NULL COMMENT “”,
res_358 double NULL COMMENT “”,
res_17 decimal(34, 4) NULL COMMENT “”,
res_15 decimal(34, 4) NULL COMMENT “”,
res_14 decimal(34, 4) NULL COMMENT “”,
res_403 double NULL COMMENT “”,
res_411 double NULL COMMENT “”,
res_402 double NULL COMMENT “”,
res_451 double NULL COMMENT “”,
res_intcard_day double NULL COMMENT “”,
userfrom double NULL COMMENT “”,
continent_ocean varchar(65533) NULL COMMENT “”,
country_chinese_name varchar(65533) NULL COMMENT “”,
mainland_region varchar(65533) NULL COMMENT “”,
province_name varchar(65533) NULL COMMENT “”,
city_code varchar(65533) NULL COMMENT “”,
city_name varchar(65533) NULL COMMENT “”,
district_code varchar(65533) NULL COMMENT “”,
district_name varchar(65533) NULL COMMENT “”,
carrier_name varchar(65533) NULL COMMENT “”,
country_english_name varchar(65533) NULL COMMENT “”,
country_code_2_letters varchar(65533) NULL COMMENT “”,
longitude varchar(65533) NULL COMMENT “”,
latitude varchar(65533) NULL COMMENT “”,
app_version varchar(65533) NULL COMMENT “”
) ENGINE=OLAP
DUPLICATE KEY(#user_id, #create_time, #distinct_id, #devicecode, #type, #time, #event, #uuid, #ip, #cpid, #app_id, #product_id, #platform_id, #channel_id, #sub_channel_id)
COMMENT “OLAP”
PARTITION BY RANGE(#time)
(PARTITION p20230918 VALUES [(“2023-09-18 00:00:00”), (“2023-09-19 00:00:00”)),
PARTITION p20230919 VALUES [(“2023-09-19 00:00:00”), (“2023-09-20 00:00:00”)))
DISTRIBUTED BY HASH(#uuid, #time) BUCKETS 50
PROPERTIES (
“compression” = “ZSTD”,
“datacache.enable” = “true”,
“datacache.partition_duration” = “30 days”,
“dynamic_partition.enable” = “true”,
“dynamic_partition.end” = “3”,
“dynamic_partition.history_partition_num” = “0”,
“dynamic_partition.prefix” = “p”,
“dynamic_partition.start” = “-3650”,
“dynamic_partition.time_unit” = “DAY”,
“dynamic_partition.time_zone” = “Asia/Shanghai”,
“enable_async_write_back” = “false”,
“replication_num” = “3”,
“storage_volume” = “builtin_storage_volume”
);
麻烦大佬看下什么问题？为什么不能备份？