doris 版本是2.1.2
sql语句是 一个 with 子句模式是 select 所有列 from table1 (一堆条件)和另外一个表进行left join 连接类型是colocation join 两个表都是分区表 每个表参与运算的都有90个分区。测试中with子句的结果集是空
fe 报错
024-12-12
09:29:32,812
WARN
(thrift-server-pool-3629|2349029) [Coordinator.updateFragmentExecStatus () :2441] one instance report
382309
query_id=fe1e3133849a4f4a-b20de208efece817 instance_id=0-0, error message: (192.168.184.146)
382310
[CANCELLED [E-3113] string column length is too large: total length=4316351287,
382311
382312
382313
382314
382315
382316
382317
382318
382319
382320
382321
382322
382323
0#
doris:: Exception:: Exception (int,
std: ibasic_string_vlew<char, std::char_traits<char› › const&) at /var/local/ldb_toolchain/bin/../lib/gcc/x86 64-11nux-gnu/11/../../../../include/c
1茶
doris:: Exception: :Exception unsigned long&,
unsigned long&> (int, std::basic_string_view<char, std:: char_traits<char›› const&, unsigned long&, unsigned long&) at /var/local/1db_to
2#
doris: :vectorized::ColumnString:: insert
range_ fron(doris: vectorized:: IColumn const&, unsigned long, unsigned long) at /home/ zcp/repo_center/doris_release/doris/be/sc/vec/columns,
3#
44
dot19: :vectorized; :ColumnVullable;:insert range fron(doris;;vectorized;: [Column const&, unsigned long, unsigned long) at /home/zep/repo_center/doris release/doris/be/sre/vec/commor
5キ
doris:: Status doris: :vectorized: :MutableBlock: :merge_impl<doris::vectorized:: Block&> (doris: :vectorized:: Blocks) at /home/zcp/repo_center/doris release/doris/be/src/vec/common/ cow.! doris:: Status dor1s: :vectorized: Mutableßlock: :merge<doris; :vectorized:: Block&› (doris:: vectorized:: Blocks) at /home/zcp/repo_center/doris release/doris/be/src/vec/core/block.h: 512
6#
doris: :pipeline::HashJoinBuildSinkOperatorX: :sink (doris: :RuntimeState*,
7#
doris: vectorized: :Block*, bool) at /home/zcp/repo center/doris release/doris/be/src/pipeline/exec/hashjoin
doris::pipeline:: PipelineXTask:: execute (bool*) at /home/ zcp/repo
8#
center/doris
_release/doris/be/src/common/status.h: 345
doris: :pipeline::TaskScheduler:: do work(unsigned long) at /home/cp/repo_center/doris release/doris/be/grc/common/status.h: 345
9キ
doris::ThreadPool:: dispatch
thread () at /home/zep/repo_center/doris release/doris/be/src/util/threadpool. cpp: 0
10本
doris: :Thread::supervise thread(void*) at /var/local/ldb
be报错
Query fele3133849a4f4a-b20de208efece817 finished
E-3113] string column length is too large: total length=4316351287, element number=373294
2181686
2181687
0#
doris:: Exception:: Exception (int,
std: basic_string_view<char, std::char_traits<char›› consta) at /var/local/ldb_ toolchain/bin/. /1ib/gcc/x86_64-11nux-gnu/11/../ ../../../include/c
2181688
1#
doris: Exception: :Exception unsigned long&,
unsigned long&> (int, std::basic string view<char,
std:: char_traits › consta, unsigned longe,
from (doris:: vectorized:: IColumn const&,
unsigned longs) at /var/local/1db_t
2181689
2#
2181690
3#
doris:: vectorized:: ColumnString: :insert
2181691
4キ
doris:: vectorized: :ColumNullable: insert range_fron(doris: vectorized; IColumn conste, unsigned long, ungigned long) at /home/ 2cp/repo
unsigned long, unsigned long) at /home/zcp/repo_center/doris_release/doris/be/src/vec/columns
center/doris_release/doris/be/src/vec/comm
doris::Status doris: vectorized: :MutableBlock: :merge_impl<doris: :vectorized::Block&› (doris: :vectorized:: Block&) at /home/zcp/repo_center/doris release/doris/be/src/vec/common/ cow
2181692
5#
doris: :Status doris: :vectorized: :MutableBlock: :merge<doris: :vectorized: :Block&› (doris::vectorized: :Blocks) at /home/zcp/repo_center/doris_release/doris/be/src/vec/core/block.h: 512
2181693
6#
doris::pipeline: :HashJoinBuildSinkOperatorX:: sink (doris::RuntimeState*,
doris: vectorized: :Block*, bool) at /home/zcp/repo center/doris release/doris/be/src/pipeline/exec/hashjoir
2181694
7#
doris: pipeline: :PipelineXTask:: execute (bool*) at /home/zcp/ repo
center/doris release/doris/be/src/common/status.h: 345|
2181695
8#
doris: :pipeline::TaskScheduler::do_work(unsigned long) at /home/zcp/repo_center/doris_release/doris/be/src/common/status.h: 345
2181696
9キ
doris:: ThreadPool:: dispatch
thread () at /home/zep/repo center/doris_release/doris/be/src/util/threadpool.cpp:0
2181697
10#
doris:: Thread:: supervise thread(void*) at /var/local/Idb toolchain/bin/.-/us/include/pthread.h:
尝试过set enable_pipeline_x_engine = false; 和设置set parallel_pipeline_task_num=32 依然报一样的错误