3.0.8版本查hive外表报错:[INTERNAL_ERROR][E6] Parameters start = 0, length = 1, are out of bound

Viewed 3

如题,要查的hive表有struct类型的列,直接select * 会报错:
java.sql.SQLException: errCode = 2, detailMessage = (10.xxx.xxx.xxx)[INTERNAL_ERROR][E6] Parameters start = 0, length = 1, are out of bound in ColumnVector::insert_range_from method (data.size() = 0).

0#  doris::Exception::Exception(int, std::basic_string_view<char, std::char_traits<char> > const&) at /root/doris/be/src/common/exception.cpp:0
1#  doris::Exception::Exception<unsigned long&, unsigned long&, unsigned long>(int, std::basic_string_view<char, std::char_traits<char> > const&, unsigned long&, unsigned long&, unsigned long&&) at /var/local/ldb-toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/basic_string.h:187
2#  doris::vectorized::ColumnVector<unsigned char>::insert_range_from(doris::vectorized::IColumn const&, unsigned long, unsigned long) at /root/doris/be/src/vec/columns/column_vector.cpp:298
3#  doris::vectorized::ColumnNullable::insert_range_from(doris::vectorized::IColumn const&, unsigned long, unsigned long) at /root/doris/be/src/vec/common/cow.h:198
4#  doris::Status doris::vectorized::MutableBlock::merge_impl<doris::vectorized::Block&>(doris::vectorized::Block&) at /root/doris/be/src/vec/common/cow.h:132
5#  doris::Status doris::vectorized::MutableBlock::merge<doris::vectorized::Block&>(doris::vectorized::Block&) at /root/doris/be/src/vec/core/block.h:535
6#  doris::vectorized::BlockSerializer::next_serialized_block(doris::vectorized::Block*, doris::PBlock*, int, bool*, bool, std::vector<unsigned int, std::allocator<unsigned int> > const*) at /root/doris/be/src/vec/sink/vdata_stream_sender.cpp:0
7#  doris::pipeline::ExchangeSinkOperatorX::sink(doris::RuntimeState*, doris::vectorized::Block*, bool) at /root/doris/be/src/pipeline/exec/exchange_sink_operator.cpp:412
8#  doris::pipeline::PipelineTask::execute(bool*) at /root/doris/be/src/common/status.h:500
9#  doris::pipeline::TaskScheduler::_do_work(unsigned long) at /root/doris/be/src/common/status.h:391
10# doris::ThreadPool::dispatch_thread() at /var/local/ldb-toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/shared_ptr_base.h:730
11# doris::Thread::supervise_thread(void*) at /var/local/ldb-toolchain/bin/../usr/include/pthread.h:562
12# start_thread
13# __clone

对应的sql语句:
select *
from hive_on_hdfs.dwd.xxxx
where datetime='20260601'
and query like '%前备仓%'
limit 100;
稳定报错,但是直接select字段是可以的

0 Answers