create table if not exists goods_item (
id bigint,
title string attribute indexed,
is_custom int,
price_discount_rate float,
tags json,
company_id json,
shop_id int,
shelf_at int
)engine=‘rowwise’
charset_table=‘non_cjk,chinese’
morphology=‘jieba_chinese’
stopwords=‘zh,en’
min_stemming_len = ‘2’
index_exact_words=‘1’
jieba_mode =‘full’
jieba_hmm=‘0’
jieba_user_dict_path = ‘/opt/homebrew/var/manticore/user.txt’
自定义分词文件内容：
索引数据
匹配不到 老干妈 这个词，怎么设置才能搜索到 老干妈
Now I find this error: [Wed Apr 16 12:04:28.134 2025] [1137678] WARNING: Unable to load header… Error table ‘/opt/homebrew/var/manticore/goods_item4/goods_item4.7663.sph’: Error initializing Jieba: Error initializing Jieba: unable to read ‘/opt/homebrew/share/manticore/jieba/jieba.dict.utf8’
mysql> create table if not exists goods_item ( id bigint, title string attribute indexed, is_custom int, price_discount_rate float, tags json, company_id json, shop_id int, shelf_at int )engine='rowwise' charset_table='non_cjk,chinese' morphology='jieba_chinese' stopwords='zh,en' min_stemming_len = '2' index_exact_words='1' jieba_mode ='full' jieba_hmm='0';
Query OK, 0 rows affected, 1 warning (1.05 sec)
mysql> show warnings;
+---------+------+------------------------------------------------------------+
| Level | Code | Message |
+---------+------+------------------------------------------------------------+
| warning | 1000 | no morphology, index_exact_words=1 has no effect, ignoring |
+---------+------+------------------------------------------------------------+
1 row in set (0.00 sec)
works for me. Ensure this package is installed:
dpkg -L manticore-language-packs|grep jieba
/usr/share/manticore/jieba
/usr/share/manticore/jieba/user.dict.utf8
/usr/share/manticore/jieba/jieba.dict.utf8
/usr/share/manticore/jieba/idf.utf8
/usr/share/manticore/jieba/hmm_model.utf8
/usr/share/manticore/jieba/stop_words.utf8