awk333 opened a new issue, #17826: URL: https://github.com/apache/doris/issues/17826
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version doris 1.2.2，单节点，只是用来测试 ### What's Wrong? 建表语句： create table doris_tbl_user_datatype1 ( id bigint , name varchar(65530) , birthday datetime , ts datetime , arr array<string> , boo boolean ) ENGINE=OLAP UNIQUE KEY(`id`) COMMENT "OLAP" DISTRIBUTED BY HASH(`id`) BUCKETS 3 PROPERTIES ( -- "replication_allocation" = "tag.location.default:3", "replication_num" = "1", "enable_unique_key_merge_on_write" = "true", "compression" = "zstd", "function_column.sequence_col" = 'birthday' ); 插入语句： insert into doris_tbl_user_datatype1 values(111, 'aa', '2023-03-15 12:12:12', '2023-03-15 12:12:12', split_by_string('a,b,c', ','), true); 导致be宕机 be.out日志： F0315 17:55:40.318591 28316 aggregate_function_reader_first_last.h:253] with unknowed type, failed in create_aggregate_function_replace_load and type is: Nullable(Array(Nullable(String))) *** Check failure stack trace: *** @ 0x558fc4962aed google::LogMessage::Fail() @ 0x558fc4965029 google::LogMessage::SendToLog() @ 0x558fc4962656 google::LogMessage::Flush() @ 0x558fc4965699 google::LogMessageFatal::~LogMessageFatal() @ 0x558fc03a4c10 _ZNSt8__detail9__variant17__gen_vtable_implINS0_12_Multi_arrayIPFNS0_21__deduce_visit_resultIvEEOZN5doris10vectorized30create_aggregate_function_lastILb0EEESt10shared_ptrINS6_18IAggregateFunctionEERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEERKSt6vectorIS8_IKNS6_9IDataTypeEESaISM_EERKNS6_5ArrayEbEUlT_T0_E_OSt7variantIJSt17integral_constantIbLb0EESZ_IbLb1EEEES13_EJEEESt16integer_sequenceImJLm1ELm1EEEE14__visit_invokeESX_S13_S13_ @ 0x558fc0397f42 doris::vectorized::create_aggregate_function_last<>() @ 0x558fbfece33f std::_Function_handler<>::_M_invoke() @ 0x558fbf226a3a doris::MemTable::_init_agg_functions() @ 0x558fbf2273c3 doris::MemTable::insert() @ 0x558fbf30dbd6 doris::DeltaWriter::write() @ 0x558fbf820582 doris::TabletsChannel::add_batch<>() @ 0x558fbf8f0c46 doris::LoadChannel::add_batch<>() @ 0x558fbf8f0f93 doris::LoadChannelMgr::add_batch<>() @ 0x558fbf8e1aa0 _ZNSt17_Function_handlerIFvvEZN5doris20PInternalServiceImpl24_tablet_writer_add_blockEPN6google8protobuf13RpcControllerEPKNS1_28PTabletWriterAddBlockRequestEPNS1_27PTabletWriterAddBlockResultEPNS4_7ClosureEEUlvE_E9_M_invokeERKSt9_Any_data @ 0x558fbf6f9265 doris::PriorityThreadPool::work_thread() @ 0x558fc73a4370 execute_native_thread_routine @ 0x7ffb7ea77ea5 start_thread @ 0x7ffb7ed8ab0d __clone @ (nil) (unknown) *** Query id: 0-0 *** *** Aborted at 1678874140 (unix time) try "date -d @1678874140" if you are using GNU date *** *** Current BE git commitID: Unknown *** *** SIGABRT unkown detail explain (@0x6be2) received by PID 27618 (TID 0x7ffa291ca700) from PID 27618; stack trace: *** 0# doris::signal::(anonymous namespace)::FailureSignalHandler(int, siginfo_t*, void*) at /root/doris/be/src/common/signal_handler.h:420 1# 0x00007FFB7ECC2400 in /lib64/libc.so.6 2# gsignal in /lib64/libc.so.6 3# abort in /lib64/libc.so.6 4# 0x0000558FC496D4D9 in /data/starrocks/be/lib/doris_be 5# 0x0000558FC4962AED in /data/starrocks/be/lib/doris_be 6# google::LogMessage::SendToLog() in /data/starrocks/be/lib/doris_be 7# google::LogMessage::Flush() in /data/starrocks/be/lib/doris_be 8# google::LogMessageFatal::~LogMessageFatal() in /data/starrocks/be/lib/doris_be 9# std::__detail::__variant::__gen_vtable_impl<std::__detail::__variant::_Multi_array<std::__detail::__variant::__deduce_visit_result<void> (*)(doris::vectorized::create_aggregate_function_last<false>(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::vector<std::shared_ptr<doris::vectorized::IDataType const>, std::allocator<std::shared_ptr<doris::vectorized::IDataType const> > > const&, doris::vectorized::Array const&, bool)::{lambda(auto:1, auto:2)#1}&&, std::variant<std::integral_constant<bool, false>, std::integral_constant<bool, true> >&&, std::variant<std::integral_constant<bool, false>, std::integral_constant<bool, true> >&&)>, std::integer_sequence<unsigned long, 1ul, 1ul> >::__visit_invoke(doris::vectorized::create_aggregate_function_last<false>(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::vector<std::shared_ptr<doris::vectorized::IDataType const>, std::allocator<std::shared_ptr<dor is::vectorized::IDataType const> > > const&, doris::vectorized::Array const&, bool)::{lambda(auto:1, auto:2)#1}&&, std::variant<std::integral_constant<bool, false>, std::integral_constant<bool, true> >&&, std::variant<std::integral_constant<bool, false>, std::integral_constant<bool, true> >&&) at /var/local/ldb-toolchain/include/c++/11/variant:1013 10# std::shared_ptr<doris::vectorized::IAggregateFunction> doris::vectorized::create_aggregate_function_last<false>(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::vector<std::shared_ptr<doris::vectorized::IDataType const>, std::allocator<std::shared_ptr<doris::vectorized::IDataType const> > > const&, doris::vectorized::Array const&, bool) at /root/doris/be/src/vec/aggregate_functions/aggregate_function_reader_first_last.h:284 11# std::_Function_handler<std::shared_ptr<doris::vectorized::IAggregateFunction> (std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::vector<std::shared_ptr<doris::vectorized::IDataType const>, std::allocator<std::shared_ptr<doris::vectorized::IDataType const> > > const&, doris::vectorized::Array const&, bool), std::shared_ptr<doris::vectorized::IAggregateFunction> (*)(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::vector<std::shared_ptr<doris::vectorized::IDataType const>, std::allocator<std::shared_ptr<doris::vectorized::IDataType const> > > const&, doris::vectorized::Array const&, bool)>::_M_invoke(std::_Any_data const&, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::vector<std::shared_ptr<doris::vectorized::IDataType const>, std::allocator<std::shared_ptr<doris::vectorized::IDataType const> > > const&, doris::vectorized::Array const&, bool&&) at /var/local/ldb-toolchain/include/c++/11/bits/std_function.h:293 12# doris::MemTable::_init_agg_functions(doris::vectorized::Block const*) at /root/doris/be/src/olap/memtable.cpp:117 13# doris::MemTable::insert(doris::vectorized::Block const*, std::vector<int, std::allocator<int> > const&) at /root/doris/be/src/olap/memtable.cpp:197 14# doris::DeltaWriter::write(doris::vectorized::Block const*, std::vector<int, std::allocator<int> > const&) at /root/doris/be/src/olap/delta_writer.cpp:230 15# doris::Status doris::TabletsChannel::add_batch<doris::PTabletWriterAddBlockRequest, doris::PTabletWriterAddBlockResult>(doris::PTabletWriterAddBlockRequest const&, doris::PTabletWriterAddBlockResult*) at /root/doris/be/src/runtime/tablets_channel.cpp:490 16# doris::Status doris::LoadChannel::add_batch<doris::PTabletWriterAddBlockRequest, doris::PTabletWriterAddBlockResult>(doris::PTabletWriterAddBlockRequest const&, doris::PTabletWriterAddBlockResult*) at /root/doris/be/src/runtime/load_channel.h:163 17# doris::Status doris::LoadChannelMgr::add_batch<doris::PTabletWriterAddBlockRequest, doris::PTabletWriterAddBlockResult>(doris::PTabletWriterAddBlockRequest const&, doris::PTabletWriterAddBlockResult*) at /root/doris/be/src/runtime/load_channel_mgr.h:168 18# std::_Function_handler<void (), doris::PInternalServiceImpl::_tablet_writer_add_block(google::protobuf::RpcController*, doris::PTabletWriterAddBlockRequest const*, doris::PTabletWriterAddBlockResult*, google::protobuf::Closure*)::{lambda()#1}>::_M_invoke(std::_Any_data const&) at /var/local/ldb-toolchain/include/c++/11/bits/std_function.h:291 19# doris::PriorityThreadPool::work_thread(int) at /root/doris/be/src/util/priority_thread_pool.hpp:140 20# execute_native_thread_routine in /data/starrocks/be/lib/doris_be 21# start_thread in /lib64/libpthread.so.0 22# clone in /lib64/libc.so.6 ### What You Expected? 可以正常插入array类型的数据 ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
