OrientDB使用Lucene的全文索引,并且使用中文分词器

# 创建表

CREATE CLASS Item;

# 创建字段

CREATE PROPERTY Item.text STRING;

#  创建索引（默认英文索引

CREATE INDEX Item.text ON Item(text) FULLTEXT ENGINE LUCENE;

#  插入数据

INSERT INTO Item (text) VALUES ('My sister is coming for the holidays.');



#  创建中文分词器

CREATE INDEX Item.text ON Item(text)
            FULLTEXT ENGINE LUCENE METADATA {
                "analyzer": "org.apache.lucene.analysis.cn.smart.SmartChineseAnalyzer"
            }


#  查询


SELECT FROM Item WHERE SEARCH_CLASS("sister") = true

# 搜索包含两个词的 

SELECT FROM Item WHERE SEARCH_CLASS("+sister +coming") = true

#  包含sister但是不包含 coming
 
SELECT FROM Item WHERE SEARCH_CLASS("+sister -coming") = true


# 通配符

SELECT FROM Item WHERE SEARCH_CLASS('meet*') = true

#  高亮


SELECT FROM City WHERE SEARCH_CLASS("+name:cas*  +description:beautiful", {
    "allowLeadingWildcard": true ,
    "lowercaseExpandedTerms": false,
    "boost": {
        "name": 2
    },
    "highlight": {
        "fields": ["name"],
        "start": "",
        "end": ""
    }
}) = true

SELECT name, $name_hl, description, $description_hl FROM City
WHERE SEARCH_CLASS("+name:cas*  +description:beautiful", {
    "highlight": {
        "fields": ["name", "description"],
        "start": "",
        "end": ""
    }
}) = true


#  指定索引搜索

SELECT FROM City WHERE SEARCH_INDEX("City.name", "cas*") = true

转载于:https://my.oschina.net/zhenruyan/blog/3097262