【详述】执行类似下面的sql，查询hive外表，be crash
select
a.brand_id,
count(distinct c.skc) skc_cnt,
count(distinct if(c.flag = 1, c.skc, null)) skc_1
from
table1 a
left join (
select
id,
skc,
max(flag) flag
from
table2 a
group by
1,
2
) c on cast(a.id as varchar) = c.id
group by
a.brand_id
【业务影响】
【是否存算分离】
【StarRocks版本】3.4.4
异常栈：tracker:process consumption: 9956460616
tracker:jemalloc_metadata consumption: 203952840
tracker:query_pool consumption: 9484421520
tracker:query_pool/connector_scan consumption: 0
tracker:load consumption: 0
tracker:metadata consumption: 0
tracker:tablet_metadata consumption: 0
tracker:rowset_metadata consumption: 0
tracker:segment_metadata consumption: 0
tracker:column_metadata consumption: 0
tracker:tablet_schema consumption: 0
tracker:segment_zonemap consumption: 0
tracker:short_key_index consumption: 0
tracker:column_zonemap_index consumption: 0
tracker:ordinal_index consumption: 0
tracker:bitmap_index consumption: 0
tracker:bloom_filter_index consumption: 0
tracker:compaction consumption: 0
tracker:schema_change consumption: 0
tracker:page_cache consumption: 0
tracker:jit_cache consumption: 0
tracker:update consumption: 0
tracker:chunk_allocator consumption: 0
tracker:passthrough consumption: 0
tracker:clone consumption: 0
tracker:consistency consumption: 0
tracker:datacache consumption: 0
tracker:poco_connection_pool consumption: 885352
tracker:replication consumption: 0
*** Aborted at 1760003770 (unix time) try “date -d @1760003770” if you are using GNU date ***
PC: @ 0x82452a8 starrocks::AdaptiveSliceHashSet::emplace(starrocks::MemPool*, starrocks::Slice)
*** SIGSEGV (@0xffed05b70000) received by PID 32 (TID 0xfffe99f200c0) from PID 95879168; stack trace: ***
@ 0xffffb37553dc (/usr/lib/aarch64-linux-gnu/libc.so.6+0x853db)
@ 0xe33ce58 google::(anonymous namespace)::FailureSignalHandler(int, siginfo_t*, void*)
@ 0xffffb4b9d850 ([vdso]+0x84f)
@ 0x82452a8 starrocks::AdaptiveSliceHashSet::emplace(starrocks::MemPool*, starrocks::Slice)
@ 0x88b4a14 starrocks::TDistinctAggregateFunction<(starrocks::LogicalType)13, (starrocks::LogicalType)13, starrocks::DistinctAggregateStateV2, (starrocks::AggDistinctType)0, starrocks::Slice>::merge(starrocks::FunctionContext*, starrocks::Column const*, unsigned char*
@ 0x882a970 starrocks::NullableAggregateFunctionUnary<std::shared_ptrstarrocks::AggregateFunction, starrocks::NullableAggregateFunctionState<starrocks::DistinctAggregateStateV2<(starrocks::LogicalType)13, (starrocks::LogicalType)13, int>, false>, false, true, starro
@ 0x9e79868 starrocks::Aggregator::compute_batch_agg_states(starrocks::Chunk*, unsigned long)
@ 0x9fe08cc starrocks::pipeline::AggregateBlockingSinkOperator::push_chunk(starrocks::RuntimeState*, std::shared_ptrstarrocks::Chunk const&)
@ 0x780d020 starrocks::pipeline::PipelineDriver::process(starrocks::RuntimeState*, int)
@ 0xa727de0 starrocks::pipeline::GlobalDriverExecutor::_worker_thread()
@ 0xab4b934 starrocks::ThreadPool::dispatch_thread()
@ 0xab42c1c starrocks:
:supervise_thread(void*)
@ 0xffffb3750398 (/usr/lib/aarch64-linux-gnu/libc.so.6+0x80397)
@ 0xffffb37b9e9c (/usr/lib/aarch64-linux-gnu/libc.so.6+0xe9e9b)