elasticsearch - 来自带有多个WHERE子句的SQL语句的 Elasticsearch 查询

Question

我需要基于以下SQL语句的 Elasticsearch 查询

SELECT * FROM documents
WHERE (doc_name like "%test%" OR doc_type like "%test%" OR doc_desc like "%test%) AND
user_id = 1 AND doc_category = "Utilities"

Answer 1

这取决于您的映射，但是您可以开始进行如下操作:

"query": {
    "filtered": {
        "filter": {
            "bool": {
                "must": [
                    {
                        "term": {
                            "user_id": 1
                        }
                    },
                    {
                        "term": {
                            "doc_category": "Utilities"
                        }
                    }
                ]
            }
        },
        "query": {
            "multi_match": {
                "query": "test",
                "fields": ["doc_name", "doc_type", "doc_desc"]
            }
        }
    }
}