davycun commented on issue #19919:
URL: https://github.com/apache/doris/issues/19919#issuecomment-1697536845
@xiaokang
1、下面是外部数据源表的信息(是postgresql)
CatalogId | 0
+-------------+------------------+------+------+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------------+------+------+---------+-------+
| account_id | INT | No | true | <null> | |
| create_time | DATETIME(6) | No | true | <null> | |
| update_time | DATETIME(6) | No | true | <null> | |
| lng | DOUBLE | Yes | true | <null> | |
| lat | DOUBLE | Yes | true | <null> | |
| ip | TEXT | Yes | true | <null> | |
| id | INT | No | true | <null> | |
| category | TEXT | No | true | <null> | |
| deleted | BOOLEAN | No | true | <null> | |
| extra | JSON | No | true | <null> | |
| geometry | UNSUPPORTED_TYPE | Yes | true | <null> | |
+-------------+------------------+------+------+---------+-------+
2、 查询这个表的json 字段的时候就报错 select extra from my_catalog.my_schema.my_table limit
1;
3、下面执行sql后，backend的异常信息（string column length is too large）
doris-be01-1 | terminate called after throwing an instance of
'doris::Exception'
doris-be01-1 | what(): [E-3113] string column length is too large:
total_length=94751273517062, element_number=1
doris-be01-1 | 0. /root/src/doris/be/src/common/stack_trace.cpp:298:
StackTrace::tryCapture() @ 0x000000000b36ece7 in
/opt/apache-doris/be/lib/doris_be
doris-be01-1 | 1. /root/src/doris/be/src/common/stack_trace.h:0:
doris::get_stack_trace[abi:cxx11]() @ 0x000000000b36d2bd in
/opt/apache-doris/be/lib/doris_be
doris-be01-1 | 2.
/var/local/ldb-toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/unique_ptr.h:173:
doris::Exception::Exception(int, std::basic_string_view<char,
std::char_traits<char> >) @ 0x000000000ae1c7ae in
/opt/apache-doris/be/lib/doris_be
doris-be01-1 | 3.
/var/local/ldb-toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/basic_string.h:187:
doris::Exception::Exception<unsigned long&, unsigned long&>(int,
std::basic_string_view<char, std::char_traits<char> >, unsigned long&, unsigned
long&) @ 0x000000000a8e2818 in /opt/apache-doris/be/lib/doris_be
doris-be01-1 | 4. /root/src/doris/be/src/vec/columns/column_string.h:71:
doris::vectorized::ColumnString::insert(doris::vectorized::Field const&) @
0x000000000c3c725b in /opt/apache-doris/be/lib/doris_be
doris-be01-1 | 5. /root/src/doris/be/src/vec/common/cow.h:402:
doris::vectorized::IDataType::create_column_const(unsigned long,
doris::vectorized::Field const&) const @ 0x000000000d1004a2 in
/opt/apache-doris/be/lib/doris_be
doris-be01-1 | 6. /root/src/doris/be/src/vec/data_types/data_type.cpp:0:
doris::vectorized::IDataType::create_column_const_with_default_value(unsigned
long) const @ 0x000000000d100596 in /opt/apache-doris/be/lib/doris_be
doris-be01-1 | 7.
/var/local/ldb-toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/stl_vector.h:98:
doris::vectorized::JdbcConnector::_cast_string_to_json(doris::SlotDescriptor
const*, doris::vectorized::Block*, int, int) @ 0x000000000e7c2028 in
/opt/apache-doris/be/lib/doris_be
doris-be01-1 | 8.
/var/local/ldb-toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/unique_ptr.h:360:
doris::vectorized::JdbcConnector::get_next(bool*,
std::vector<COW<doris::vectorized::IColumn>::mutable_ptr<doris::vectorized::IColumn>,
std::allocator<COW<doris::vectorized::IColumn>::mutable_ptr<doris::vectorized::IColumn>
> >&, doris::vectorized::Block*, int) @ 0x000000000e7bf7ef in
/opt/apache-doris/be/lib/doris_be
doris-be01-1 | 9. /root/src/doris/be/src/common/status.h:414:
doris::vectorized::NewJdbcScanner::_get_block_impl(doris::RuntimeState*,
doris::vectorized::Block*, bool*) @ 0x000000000e5f3caa in
/opt/apache-doris/be/lib/doris_be
doris-be01-1 | 10. /root/src/doris/be/src/vec/exec/scan/vscanner.cpp:0:
doris::vectorized::VScanner::get_block(doris::RuntimeState*,
doris::vectorized::Block*, bool*) @ 0x000000000e6f8584 in
/opt/apache-doris/be/lib/doris_be
doris-be01-1 | 11. /root/src/doris/be/src/common/status.h:335:
doris::vectorized::ScannerScheduler::_scanner_scan(doris::vectorized::ScannerScheduler*,
doris::vectorized::ScannerContext*,
std::shared_ptr<doris::vectorized::VScanner>) @ 0x000000000e658723 in
/opt/apache-doris/be/lib/doris_be
doris-be01-1 | 12.
/var/local/ldb-toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/shared_ptr_base.h:701:
std::_Function_handler<void (),
doris::vectorized::ScannerScheduler::_schedule_scanners(doris::vectorized::ScannerContext*)::$_1::operator()()
const::{lambda()#3}>::_M_invoke(std::_Any_data const&) @ 0x000000000e6599a1 in
/opt/apache-doris/be/lib/doris_be
doris-be01-1 | 13. /root/src/doris/be/src/util/threadpool.cpp:0:
doris::ThreadPool::dispatch_thread() @ 0x000000000b3ab4bf in
/opt/apache-doris/be/lib/doris_be
doris-be01-1 | 14.
/var/local/ldb-toolchain/bin/../usr/include/pthread.h:562:
doris::Thread::supervise_thread(void*) @ 0x000000000b3a153c in
/opt/apache-doris/be/lib/doris_be
doris-be01-1 | 15. start_thread @ 0x0000000000008ea7 in
/lib/x86_64-linux-gnu/libpthread-2.31.so
doris-be01-1 | 16. clone @ 0x00000000000fddef in
/lib/x86_64-linux-gnu/libc-2.31.so
--
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]
