我有一个定义如下的源的sql_query
:
sql_query = SELECT \
criteria.item_uuid, \
criteria.user_id, \
criteria.color, \
criteria.selection, \
criteria.item_id, \
home.state, \
item.* \
FROM criteria \
INNER JOIN item USING (item_uuid) \
INNER JOIN user_info home USING (user_id) \
WHERE criteria.item_uuid IS NOT NULL
然后是索引:
index csearch {
source = csearch
path = /usr/local/sphinx/var/data/csearch
docinfo = extern
enable_star = 1
min_prefix_len = 0
min_infix_len = 0
morphology = stem_en
}
但是当我运行indexer --rotate csearch
命令时,会出现以下情况:
indexing index 'csearch'...
WARNING: zero/NULL document_id, skipping
这个想法是,基于其他列的某种组合方式,
item_uuid
列是我想要的标识符。在Postgres中,item_uuid
列是一种uuid类型:也许Sphinx不支持这种类型?无论如何,欢迎提出任何想法。