使用外表从单台SR同步到集群SR 失败

💬 StarRocks 用户问答
#1

报错如下: Insert has filtered data in strict mode, txn_id = 64989 tracking sql = select tracking_log from information_schema.load_tracking_logs where job_id=82147
报错内容：Error: The row is out of partition ranges. Please add a new partition… Row:
源机器版本：3.2.3
目标集群版本：3.2.4
两边表结构字段一致 分区表字段都是date类型fe.log (84.4 MB) fe.warn.log (426.5 KB)

CREATE EXTERNAL TABLE external_synthesize_report
(
ad_id varchar(200) NULL COMMENT “”,
installed_ts bigint(20) NULL DEFAULT “0” COMMENT “”,
app varchar(200) NULL DEFAULT “unknown” COMMENT “”,
day date NULL COMMENT “”,
app_version varchar(200) NULL DEFAULT “unknown” COMMENT “”,
ad_revenue_network varchar(200) NULL DEFAULT “unknown” COMMENT “”,
ad_revenue_unit varchar(200) NULL DEFAULT “unknown” COMMENT “”,
ad_revenue_placement varchar(200) NULL DEFAULT “unknown” COMMENT “”,
ad_type varchar(100) NULL DEFAULT “unknown” COMMENT “”,
scene_name varchar(200) NULL DEFAULT “unknown” COMMENT “”,
statusvpn varchar(10) NULL DEFAULT “unknown” COMMENT “”,
activity_kind varchar(50) NULL DEFAULT “unknown” COMMENT “”,
os_name varchar(200) NULL DEFAULT “unknown” COMMENT “”,
campaign_id varchar(200) NULL DEFAULT “unknown” COMMENT “”,
campaign_name varchar(500) NULL DEFAULT “unknown” COMMENT “”,
creative_id varchar(200) NULL DEFAULT “unknown” COMMENT “”,
creative_name varchar(200) NULL DEFAULT “unknown” COMMENT “”,
created_at bigint(20) NULL COMMENT “”,
country_code varchar(200) NULL DEFAULT “unknown” COMMENT “”,
network_name varchar(200) NULL DEFAULT “unknown” COMMENT “”,
package_name varchar(200) NULL DEFAULT “unknown” COMMENT “”,
idfa varchar(200) NULL DEFAULT “unknown” COMMENT “”,
installs bigint(20) NULL DEFAULT “0” COMMENT “”,
cost decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
channel_cost decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
dau bigint(20) NULL DEFAULT “0” COMMENT “”,
ad_revenue decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
cohort_ad_revenue decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
inapp_pay_revenue decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
inapp_pay_count int(11) NULL DEFAULT “0” COMMENT “”,
impressions bigint(20) NULL DEFAULT “0” COMMENT “”,
impressions_ok bigint(20) NULL DEFAULT “0” COMMENT “”,
time_spent bigint(20) NULL DEFAULT “0” COMMENT “”,
label varchar(65533) NULL DEFAULT “unknown” COMMENT “”,
ad_account_id varchar(200) NULL DEFAULT “unknown” COMMENT “”,
ad_account_name varchar(500) NULL DEFAULT “unknown” COMMENT “”,
pitcher varchar(20) NULL DEFAULT “unknown” COMMENT “”,
principal_id int(11) NULL DEFAULT “0” COMMENT “”,
dept_id int(11) NULL DEFAULT “0” COMMENT “”,
user_type int(11) NULL DEFAULT “0” COMMENT “”,
req_count int(11) NULL DEFAULT “0” COMMENT “”,
match_count int(11) NULL DEFAULT “0” COMMENT “”,
click_count int(11) NULL DEFAULT “0” COMMENT “”,
view_ads_user_count int(11) NULL DEFAULT “0” COMMENT “”,
rpi0 decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
rpi1 decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
rpi2 decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
rpi3 decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
rpi4 decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
rpi5 decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
rpi6 decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
rpi7 decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
rpi14 decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
rpi30 decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
retained_users_d1 int(11) NULL DEFAULT “0” COMMENT “”,
retained_users_d2 int(11) NULL DEFAULT “0” COMMENT “”,
retained_users_d3 int(11) NULL DEFAULT “0” COMMENT “”,
retained_users_d4 int(11) NULL DEFAULT “0” COMMENT “”,
retained_users_d5 int(11) NULL DEFAULT “0” COMMENT “”,
retained_users_d6 int(11) NULL DEFAULT “0” COMMENT “”,
retained_users_d7 int(11) NULL DEFAULT “0” COMMENT “”,
retained_users_d14 int(11) NULL DEFAULT “0” COMMENT “”,
retained_users_d30 int(11) NULL DEFAULT “0” COMMENT “”,
create_time datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT “”,
installed_at varchar(50) NULL DEFAULT “1970-01-01” COMMENT “”,
city_value int(11) NULL DEFAULT “0” COMMENT “”,
adgroup_id varchar(200) NULL DEFAULT “unknown” COMMENT “”,
adgroup_name varchar(200) NULL DEFAULT “unknown” COMMENT “”
)
ENGINE=olap
PARTITION BY date_trunc(‘day’, day)
DISTRIBUTED BY HASH(ad_id, app, day)
PROPERTIES
(
“host” = “1414”,
“port” = “1414”,
“user” = “1414”,
“password” = “1414”,
“database” = “1414”,
“table” = “test”
);

CREATE TABLE test (
ad_id varchar(200) NULL COMMENT “”,
installed_ts bigint(20) NULL DEFAULT “0” COMMENT “”,
app varchar(200) NULL DEFAULT “unknown” COMMENT “”,
day date NULL COMMENT “”,
app_version varchar(200) NULL DEFAULT “unknown” COMMENT “”,
ad_revenue_network varchar(200) NULL DEFAULT “unknown” COMMENT “”,
ad_revenue_unit varchar(200) NULL DEFAULT “unknown” COMMENT “”,
ad_revenue_placement varchar(200) NULL DEFAULT “unknown” COMMENT “”,
ad_type varchar(100) NULL DEFAULT “unknown” COMMENT “”,
scene_name varchar(200) NULL DEFAULT “unknown” COMMENT “”,
statusvpn varchar(10) NULL DEFAULT “unknown” COMMENT “”,
activity_kind varchar(50) NULL DEFAULT “unknown” COMMENT “”,
os_name varchar(200) NULL DEFAULT “unknown” COMMENT “”,
campaign_id varchar(200) NULL DEFAULT “unknown” COMMENT “”,
campaign_name varchar(500) NULL DEFAULT “unknown” COMMENT “”,
creative_id varchar(200) NULL DEFAULT “unknown” COMMENT “”,
creative_name varchar(200) NULL DEFAULT “unknown” COMMENT “”,
created_at bigint(20) NULL COMMENT “”,
country_code varchar(200) NULL DEFAULT “unknown” COMMENT “”,
network_name varchar(200) NULL DEFAULT “unknown” COMMENT “”,
package_name varchar(200) NULL DEFAULT “unknown” COMMENT “”,
idfa varchar(200) NULL DEFAULT “unknown” COMMENT “”,
installs bigint(20) NULL DEFAULT “0” COMMENT “”,
cost decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
channel_cost decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
dau bigint(20) NULL DEFAULT “0” COMMENT “”,
ad_revenue decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
cohort_ad_revenue decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
inapp_pay_revenue decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
inapp_pay_count int(11) NULL DEFAULT “0” COMMENT “”,
impressions bigint(20) NULL DEFAULT “0” COMMENT “”,
impressions_ok bigint(20) NULL DEFAULT “0” COMMENT “”,
time_spent bigint(20) NULL DEFAULT “0” COMMENT “”,
label varchar(65533) NULL DEFAULT “unknown” COMMENT “”,
ad_account_id varchar(200) NULL DEFAULT “unknown” COMMENT “”,
ad_account_name varchar(500) NULL DEFAULT “unknown” COMMENT “”,
pitcher varchar(20) NULL DEFAULT “unknown” COMMENT “”,
principal_id int(11) NULL DEFAULT “0” COMMENT “”,
dept_id int(11) NULL DEFAULT “0” COMMENT “”,
user_type int(11) NULL DEFAULT “0” COMMENT “”,
req_count int(11) NULL DEFAULT “0” COMMENT “”,
match_count int(11) NULL DEFAULT “0” COMMENT “”,
click_count int(11) NULL DEFAULT “0” COMMENT “”,
view_ads_user_count int(11) NULL DEFAULT “0” COMMENT “”,
rpi0 decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
rpi1 decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
rpi2 decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
rpi3 decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
rpi4 decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
rpi5 decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
rpi6 decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
rpi7 decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
rpi14 decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
rpi30 decimal(20, 10) NULL DEFAULT “0” COMMENT “”,
retained_users_d1 int(11) NULL DEFAULT “0” COMMENT “”,
retained_users_d2 int(11) NULL DEFAULT “0” COMMENT “”,
retained_users_d3 int(11) NULL DEFAULT “0” COMMENT “”,
retained_users_d4 int(11) NULL DEFAULT “0” COMMENT “”,
retained_users_d5 int(11) NULL DEFAULT “0” COMMENT “”,
retained_users_d6 int(11) NULL DEFAULT “0” COMMENT “”,
retained_users_d7 int(11) NULL DEFAULT “0” COMMENT “”,
retained_users_d14 int(11) NULL DEFAULT “0” COMMENT “”,
retained_users_d30 int(11) NULL DEFAULT “0” COMMENT “”,
create_time datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT “”,
installed_at varchar(50) NULL DEFAULT “1970-01-01” COMMENT “”,
city_value int(11) NULL DEFAULT “0” COMMENT “”,
adgroup_id varchar(200) NULL DEFAULT “unknown” COMMENT “”,
adgroup_name varchar(200) NULL DEFAULT “unknown” COMMENT “”
) ENGINE=OLAP
UNIQUE KEY(ad_id, installed_ts, app, day, app_version, ad_revenue_network, ad_revenue_unit, ad_revenue_placement, ad_type, scene_name, statusvpn, activity_kind)
PARTITION BY date_trunc(‘day’, day)
DISTRIBUTED BY HASH(ad_id, installed_ts, app, day)
PROPERTIES (
“replication_num” = “1”,
“in_memory” = “false”,
“enable_persistent_index” = “false”,
“replicated_storage” = “true”,
“compression” = “LZ4”
);

京ICP备2022026421号-1