【已记录】doris建表设置索引和分词，分词器设为chinese，在查询时使用特殊符号进行match_all，多次查询，会报错，如何解决

Viewed 82
2.0

doris建表设置索引和分词，分词器设为chinese，在查询时使用特殊符号进行match_all，多次查询，会报错如下错误

Execution failed: Error Failed to execute sql: java.sql.SQLException: (conn=284) errCode = 2, detailMessage = (192.168.7.186)[CANCELLED][INTERNAL_ERROR]failed to initialize storage reader. tablet=5238238.1821460720.4c48dd4543d9484a-0382c1c4af0bbb98, res=[E-6002]Inverted index read null bitmap error occurred, reason=Get file size IO error: [IO_ERROR]failed to get file size /data9/doris/data/data/846/5238238/1821460720/0200000000087d51514e5a4fa799774495b98d4fab744da4_0_5238220.idx: (2), No such file or directory, backend=192.168.7.186 0# doris::vectorized::NewOlapScanner::open(doris::RuntimeState*) at /var/local/ldb-toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/basic_string.h:187 1# doris::vectorized::ScannerScheduler::_scanner_scan(doris::vectorized::ScannerScheduler*, doris::vectorized::ScannerContext*, std::shared_ptr) at /root/src/doris-2.0/be/src/common/status.h:354 2# std::_Function_handler<void (), doris::vectorized::ScannerScheduler::_schedule_scanners(doris::vectorized::ScannerContext*)::$_1::operator()() const::{lambda()#3}>::_M_invoke(std::_Any_data const&) at /var/local/ldb-toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/shared_ptr_base.h:701 3# doris::WorkThreadPool::work_thread(int) at /var/local/ldb-toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/atomic_base.h:646 4# execute_native_thread_routine at /data/gcc-11.1.0/build/x86_64-pc-linux-gnu/libstdc++-v3/include/bits/unique_ptr.h:85 5# start_thread 6# __clone

caopengbo3
2 Answers

能提供建表与查询语句吗？

mink196

建表语句如下：

CREATE TABLE IF NOT EXISTS test.people_file
(
`subject_id` VARCHAR(256) COMMENT '主题ID',
 `value` VARCHAR(128) COMMENT '值',
`name` VARCHAR(64) COMMENT '姓名',
`ywxm` VARCHAR(82) COMMENT '英文姓名',
`sexcode` VARCHAR(1) COMMENT '性别',
`nation` VARCHAR(2) COMMENT '民族',
`age` BIGINT COMMENT '年龄',
`zodiac` VARCHAR(128) COMMENT '生肖',
`constallation` VARCHAR(256) COMMENT '星座',
`birthday` VARCHAR(14) COMMENT '出生日期',
`seq` BIGINT COMMENT '序列',
INDEX value (`value`) USING INVERTED PROPERTIES("parser" = "chinese"),
INDEX data_source (`name`) USING INVERTED PROPERTIES("parser" = "chinese")
)
ENGINE=OLAP
UNIQUE KEY(subject_id,value)
COMMENT '人员'
DISTRIBUTED BY HASH(subject_id) BUCKETS auto
PROPERTIES
(
   "replication_allocation" = "tag.location.default: 2",
   "is_being_synced" = "false",
   "storage_format" = "V2",
   "enable_unique_key_merge_on_write" = "true",
   "light_schema_change" = "true",
   "function_column.sequence_col" = "seq",
   "disable_auto_compaction" = "false",
   "skip_write_index_on_load" = "true",
   "compaction_policy" = "time_series"
);
caopengbo3