为了更快的定位您的问题，请提供以下信息，谢谢
【详述】执行以下SQL BE崩溃
select
c_type,
concat(YEAR_ID, WEEK_ID) as id ,
WEEK_ID ,
start_date ,
end_date ,
case
when 2 = 1 then concat(YEAR_ID, “W”, week_id)
else concat(substr(end_date, 1, 4), substr(end_date, 6, 2))
end as week_ids ,
concat(DATE_FORMAT(start_date, ‘%m.%d’), ‘~’, DATE_FORMAT(end_date, ‘%m.%d’)) as time_zh
from
(
select
DISTINCT ‘周’ as c_type ,
t02.WEEK_ID,
YEAR_ID ,
max(day_short_desc) over (partition by t02.week_id) as end_date ,
min(day_short_desc) over (partition by t02.week_id) as start_date
from
(
select
WEEK_ID ,
YEARWEEK_ID
from
dfpv_dim.t_dim_day
where
day_short_desc >= (date_format(now()- INTERVAL 52 week, ‘%Y-%m-%d’))
and day_short_desc <= (date_format(now()- INTERVAL 1 week, ‘%Y-%m-%d’)) )t01
left join (
select
WEEK_ID ,
YEARWEEK_ID ,
YEAR_ID ,
day_short_desc
from
dfpv_dim.t_dim_day )t02 on
t01.YEARWEEK_ID = t02.YEARWEEK_ID
union all
select
DISTINCT ‘周’ as c_type ,
t02.WEEK_ID,
YEAR_ID ,
max(day_short_desc) over (partition by t02.week_id) as end_date ,
min(day_short_desc) over (partition by t02.week_id) as start_date
from
(
select
WEEK_ID ,
YEARWEEK_ID
from
dfpv_dim.t_dim_day
where
day_short_desc = (date_format(now(), ‘%Y-%m-%d’)) )t01
left join (
select
WEEK_ID ,
YEARWEEK_ID ,
YEAR_ID ,
day_short_desc
from
dfpv_dim.t_dim_day
where
day_short_desc <= (date_format(now(), ‘%Y-%m-%d’)) )t02 on
t01.YEARWEEK_ID = t02.YEARWEEK_ID
union all
select
distinct ‘月’ as c_type ,
YEARMONTH_ID as WEEK_ID ,
YEAR_ID ,
YEARMONTH_ID as end_date ,
YEARMONTH_ID as start_date
from
dfpv_dim.t_dim_day
where
YEARMONTH_ID >= date_format(now()- INTERVAL 24 month, ‘%Y-%m’)
and YEARMONTH_ID <= date_format(now(), ‘%Y-%m’) )t01
where
1 = 1
and c_type = ‘月’
order by
id desc
【背景】做过哪些操作？
【业务影响】
【是否存算分离】
【StarRocks版本】例如：3.3.16
【集群规模】例如：3fe+3be
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息，请补充下您的联系方式，例如：社区群4-小李或者邮箱，谢谢
【附件】
query_id:223f80cd-61e4-11f0-a0f4-0ed1a6b7cfca, fragment_instance:223f80cd-61e4-11f0-a0f4-0ed1a6b7cfce
tracker:process consumption: 2794262712
tracker:jemalloc_metadata consumption: 71885016
tracker:query_pool consumption: 766648
tracker:query_pool/connector_scan consumption: 0
tracker:load consumption: 0
tracker:metadata consumption: 68559105
tracker:tablet_metadata consumption: 53049524
tracker:rowset_metadata consumption: 13868951
tracker:segment_metadata consumption: 99959
tracker:column_metadata consumption: 1540671
tracker:tablet_schema consumption: 1555988
tracker:segment_zonemap consumption: 63123
tracker:short_key_index consumption: 1228
tracker:column_zonemap_index consumption: 354559
tracker:ordinal_index consumption: 797152
tracker:bitmap_index consumption: 0
tracker:bloom_filter_index consumption: 0
tracker:compaction consumption: 0
tracker:schema_change consumption: 0
tracker:column_pool consumption: 0
tracker:page_cache consumption: 2206614784
tracker:jit_cache consumption: 0
tracker:update consumption: 51589767
tracker:chunk_allocator consumption: 0
tracker:passthrough consumption: 0
tracker:clone consumption: 0
tracker:consistency consumption: 0
tracker:datacache consumption: 0
tracker:replication consumption: 0
*** Aborted at 1752629290 (unix time) try “date -d @1752629290” if you are using GNU date ***
PC: @ 0x66f1358 starrocks::StringFunctions::concat(starrocks::FunctionContext*, std::vector<std::shared_ptrstarrocks::Column, std::allocator<std::shared_ptrstarrocks::Column > > const&)
*** SIGSEGV (@0x300000002) received by PID 475007 (TID 0x4000684800c0) from PID 2; stack trace: ***
@ 0x400034140418 (/usr/lib64/libpthread-2.28.so+0x10417)
@ 0x71a3fcc google::(anonymous namespace)::FailureSignalHandler(int, siginfo_t*, void*)
@ 0x400033a8c660 os::Linux::chained_handler(int, siginfo_t*, void*)
@ 0x400033a92c38 JVM_handle_linux_signal
@ 0x400033a8385c signalHandler(int, siginfo_t*, void*)
@ 0x400032f8079c ([vdso]+0x79b)
@ 0x66f1358 starrocks::StringFunctions::concat(starrocks::FunctionContext*, std::vector<std::shared_ptrstarrocks::Column, std::allocator<std::shared_ptrstarrocks::Column > > const&)
@ 0x56ac420 starrocks::VectorizedFunctionCallExpr::evaluate_checked(starrocks::ExprContext*, starrocks::Chunk*)
@ 0x4cf8b18 starrocks::ExprContext::evaluate(starrocks::Expr*, starrocks::Chunk*, unsigned char*)
@ 0x4cf8fb0 starrocks::ExprContext::evaluate(starrocks::Chunk*, unsigned char*)
@ 0x3dc14c0 starrocks::pipeline::ProjectOperator::push_chunk(starrocks::RuntimeState*, std::shared_ptrstarrocks::Chunk const&)
@ 0x3e503c0 starrocks::pipeline::PipelineDriver::process(starrocks::RuntimeState*, int)
@ 0x40f76b4 starrocks::pipeline::GlobalDriverExecutor::_worker_thread()
@ 0x339432c starrocks::ThreadPool::dispatch_thread()
@ 0x338c134 starrocks:
:supervise_thread(void*)
@ 0x4000341387c0 (/usr/lib64/libpthread-2.28.so+0x87bf)
@ 0x4000343bbb5c (/usr/lib64/libc-2.28.so+0xdbb5b)
start time: Wed Jul 16 09:39:29 CST 2025, server uptime: 09:39:29 up 54 days, 13:51, 1 user, load average: 0.00, 0.07, 0.15
Ignored unknown config: webserver_num_workers
Ignored unknown config: default_rowset_type
Ignored unknown config: tc_use_memory_min
Ignored unknown config: tc_free_memory_rate
Ignored unknown config: tc_gc_period