为了更快的定位您的问题，请提供以下信息，谢谢
【详述】对存算分离的表执行特定查询会导致集群的所有cn瞬间全部挂掉
【背景】查询
【业务影响】
【是否存算分离】是
【StarRocks版本】3.2.6
【集群规模】例如：3fe（1 follower+2observer）+3cn（非混布）
【机器信息】fe：8c32g；cn：16c64g
【联系方式】starroks存算分离2群：立
【附件】
- cn.WARN
- cn.out
表结构：
CREATE TABLE ads_nps_totaldownload (
create_time date,
create_week varchar(50),
create_month varchar(50),
create_quarter varchar(50),
create_year varchar(50),
machineid varchar(50),
user_type varchar(50),
device_type varchar(50),
model varchar(50),
activate_date varchar(50),
activate_type varchar(50),
grade varchar(50),
grade_type varchar(50),
buy_channel varchar(50),
buy_type varchar(50),
province varchar(50),
city varchar(50),
region_type varchar(50),
gender varchar(50),
last_watch varchar(50),
osver varchar(50),
appver varchar(50),
operator varchar(50),
satisfied varchar(50),
recommend varchar(50),
nps_type int(11),
recommend_reason,
sentence varchar(65533),
key_word varchar(50),
first_target varchar(50),
second_target varchar(100),
third_target varchar(50),
feedback_target varchar(50),
questionnaire_comment varchar(50),
test varchar(50),
family_revenue varchar(50),
revisit_will varchar(65533),
program varchar(50),
INDEX index1_create_time (create_time) USING BITMAP COMMENT ‘index1_create_time’,
INDEX index1_device (device_type) USING BITMAP COMMENT ‘index1_device’
) ENGINE=OLAP
DUPLICATE KEY(create_time, create_week)
COMMENT “OLAP”
PARTITION BY RANGE(create_time)
(START (“2022-01-01”) END (“2024-05-20”) EVERY (INTERVAL 1 DAY))
DISTRIBUTED BY HASH(create_time, create_week, create_month, device_type, model)
PROPERTIES (
“replication_num” = “1”,
“dynamic_partition.enable” = “true”,
“dynamic_partition.time_unit” = “day”,
“dynamic_partition.time_zone” = “Asia/Shanghai”,
“dynamic_partition.start” = “-2147483648”,
“dynamic_partition.end” = “5”,
“dynamic_partition.prefix” = “p”,
“dynamic_partition.history_partition_num” = “0”,
“datacache.enable” = “true”,
“storage_volume” = “def_volume”,
“enable_async_write_back” = “false”,
“enable_persistent_index” = “false”,
“compression” = “LZ4”
);
查询语句
select
CASE
WHEN first_target = “null” THEN “”
ELSE first_target
END firstTarget,
CASE
WHEN second_target = “null” THEN “”
ELSE second_target
END secondTarget,
CASE
WHEN third_target = “null” THEN “”
ELSE third_target
END thirdTarget,
feedback_target feedbackTarget,
model ,
create_time askTime,
recommend_reason recommendReason,
CASE
when nps_type = 1 then ‘推荐者’
when nps_type = 2 then ‘中立者’
when nps_type = 3 then ‘贬损者’
end npsType
from
ads_nps_totaldownload
WHERE
first_target = ‘产品体验’
and device_type = ‘1’
and second_target = ‘功能多少’
order by
feedback_target desc,
create_time desc,
recommend_reason desc
limit 10 offset 0;
数据样本：
“create_time”,“create_week”,“create_month”,“create_quarter”,“create_year”,“machineid”,“user_type”,“device_type”,“model”,“activate_date”,“activate_type”,“grade”,“grade_type”,“buy_channel”,“buy_type”,“province”,“city”,“region_type”,“gender”,“last_watch”,“osver”,“appver”,“operator”,“satisfied”,“recommend”,“nps_type”,“recommend_reason”,“sentence”,“key_word”,“first_target”,“second_target”,“third_target”,“feedback_target”,“questionnaire_comment”,“test”,“family_revenue”,“revisit_will”,“program”
“2022-01-01”,“2021-12-27/2022-01-02”,“2022-01”,“2022-01/2022-03”,“2022”,null,“1”,“1”,A78,“2021-12-03”,一个月,“10”,小高,null,null,null,null,null,null,null,V1.2.3.4,“1.0.0.0”,null,“8”,null,2,null,null,null,产品体验,功能多少,功能少,负面,null,null,null,null,null
“2022-01-01”,“2021-12-27/2022-01-02”,“2022-01”,“2022-01/2022-03”,“2022”,null,“2”,“1”,A78,“2021-07-04”,六个月,“6年级”,小高,null,null,null,null,null,null,null,V1.2.3.4,“1.0.0.0”,null,“3”,null,3,null,null,null,产品体验,功能多少,功能少,正面,null,null,null,null,null
“2022-01-01”,“2021-12-27/2022-01-02”,“2022-01”,“2022-01/2022-03”,“2022”,null,“2”,“1”,A78,“2021-07-04”,六个月,“4年级”,小高,null,null,null,null,null,null,null,V1.2.3.4,“1.0.0.0”,null,“10”,null,1,null,null,null,产品体验,功能多少,功能多,正面,null,null,null,null,null
“2022-01-01”,“2021-12-27/2022-01-02”,“2022-01”,“2022-01/2022-03”,“2022”,null,“2”,“1”,A78,“2021-12-01”,一个月,“5年级”,小高,null,null,null,null,null,null,null,V1.2.3.4,“1.0.0.0”,null,“10”,null,1,null,null,null,产品体验,功能多少,功能多,正面,null,null,null,null,null
“2022-01-01”,“2021-12-27/2022-01-02”,“2022-01”,“2022-01/2022-03”,“2022”,null,“2”,“1”,A78,“2021-07-06”,一个月,“5年级”,小高,null,null,null,null,null,null,null,V1.2.3.4,“1.0.0.0”,null,“9”,null,2,null,null,null,产品体验,功能多少,功能多,正面,null,null,null,null,null
“2022-01-01”,“2021-12-27/2022-01-02”,“2022-01”,“2022-01/2022-03”,“2022”,null,“1”,“1”,A78,“2021-06-28”,六个月,“7”,小低,null,null,null,null,null,null,null,V1.2.3.4,“1.0.0.0”,null,“9”,null,2,null,null,null,产品体验,功能多少,功能少,负面,null,null,null,null,null
“2022-01-01”,“2021-12-27/2022-01-02”,“2022-01”,“2022-01/2022-03”,“2022”,null,“2”,“1”,A78,“2021-07-02”,六个月,“6年级”,小高,null,null,null,null,null,null,null,V1.2.3.4,“1.0.0.0”,null,“10”,null,1,null,null,null,产品体验,功能多少,功能多,正面,null,null,null,null,null
“2022-01-01”,“2021-12-27/2022-01-02”,“2022-01”,“2022-01/2022-03”,“2022”,null,“2”,“1”,A78,“2021-07-04”,六个月,“5年级”,小高,null,null,null,null,null,null,null,V1.2.3.4,“1.0.0.0”,null,“10”,null,1,null,null,null,产品体验,功能多少,功能多,正面,null,null,null,null,null
“2022-01-01”,“2021-12-27/2022-01-02”,“2022-01”,“2022-01/2022-03”,“2022”,null,“2”,“1”,A78,“2021-07-06”,一个月,初一,初中,null,null,null,null,null,null,null,V1.2.3.4,“1.0.0.0”,null,“9”,null,1,null,null,null,产品体验,功能多少,功能少,正面,null,null,null,null,null
“2022-01-01”,“2021-12-27/2022-01-02”,“2022-01”,“2022-01/2022-03”,“2022”,null,“1”,“1”,A78,“2021-11-05”,一个月,“8”,小高,null,null,null,null,null,null,null,V1.2.3.4,“1.0.0.0”,null,“10”,null,1,null,null,null,"","","","",null,null,null,null,null
“2022-01-01”,“2021-12-27/2022-01-02”,“2022-01”,“2022-01/2022-03”,“2022”,null,“1”,“1”,A78,“2021-10-25”,一个月,“6”,小低,null,null,null,null,null,null,null,V1.2.3.4,“1.0.0.0”,null,“10”,null,3,null,null,null,"","","","",null,null,null,null,null
“2022-01-01”,“2021-12-27/2022-01-02”,“2022-01”,“2022-01/2022-03”,“2022”,null,“1”,“1”,A78,“2021-11-23”,一个月,“15”,未知,null,null,null,null,null,null,null,V1.2.3.4,“1.0.0.0”,null,“10”,null,1,null,null,null,"","","","",null,null,null,null,null
“2022-01-01”,“2021-12-27/2022-01-02”,“2022-01”,“2022-01/2022-03”,“2022”,null,“1”,“1”,A78,“2021-08-21”,一个月,“10”,小高,null,null,null,null,null,null,null,V1.2.3.4,“1.0.0.0”,null,“7”,null,1,null,null,null,"","","","",null,null,null,null,null
“2022-01-01”,“2021-12-27/2022-01-02”,“2022-01”,“2022-01/2022-03”,“2022”,null,“1”,“1”,A78,“2021-06-01”,六个月,“8”,小高,null,null,null,null,null,null,null,V1.2.3.4,“1.0.0.0”,null,“10”,null,1,null,null,null,产品体验,声音效果,通话音质,正面,null,null,null,null,null
“2022-01-01”,“2021-12-27/2022-01-02”,“2022-01”,“2022-01/2022-03”,“2022”,null,“1”,“1”,A78,“2021-06-01”,六个月,“8”,小高,null,null,null,null,null,null,null,V1.2.3.4,“1.0.0.0”,null,“10”,null,1,null,null,null,产品体验,通话质量,通话效果,正面,null,null,null,null,null
“2022-01-01”,“2021-12-27/2022-01-02”,“2022-01”,“2022-01/2022-03”,“2022”,null,“1”,“1”,A78,“2021-07-06”,一个月,“8”,小高,null,null,null,null,null,null,null,V1.2.3.4,“1.0.0.0”,null,“8”,null,2,null,null,null,"","","","",null,null,null,null,null
数据规模：
从20220101到20240520每天一个分区
总共 12812025 条数据
