请问有没有 multi_match 对应的sql语句的写法？

[m358807551]

[shi-yuan]

不好意思，目前还不支持multiMatchQuery

[m358807551]

好的。谢谢。

[shi-yuan]

SELECT * FROM test WHERE q=multimatch(query='this is a test',fields='subject^3,message',analyzer='standard',type='best_fields',boost=1.0,slop=0,tie_breaker=0.3,operator='and')

{
  "from": 0,
  "size": 200,
  "query": {
    "bool": {
      "filter": [
        {
          "bool": {
            "must": [
              {
                "multi_match": {
                  "query": "this is a test",
                  "fields": [
                    "message^1.0",
                    "subject^3.0"
                  ],
                  "type": "best_fields",
                  "operator": "AND",
                  "analyzer": "standard",
                  "slop": 0,
                  "prefix_length": 0,
                  "max_expansions": 50,
                  "tie_breaker": 0.3,
                  "zero_terms_query": "NONE",
                  "auto_generate_synonyms_phrase_query": true,
                  "fuzzy_transpositions": true,
                  "boost": 1.0
                }
              }
            ],
            "adjust_pure_negative": true,
            "boost": 1.0
          }
        }
      ],
      "adjust_pure_negative": true,
      "boost": 1.0
    }
  }
}

[fenian7788]

SELECT * FROM test WHERE q=multimatch(query='this is a test',fields='subject^3,message',analyzer='standard',type='best_fields',boost=1.0,slop=0,tie_breaker=0.3,operator='and')
这个fields只允许传2个字段，我传了3个，例如 fields='aa,bb,cc' 被解析成 "fields": [ "aa", "bb,cc" ]

[shi-yuan]

Sorry, @fenian7788 ,fixed