How I can get a simple query multimatch text in SQL in Elasticsearch?

Question

How I can get this simple query in Elasticsearch?

SELECT * FROM [mytype] WHERE name = alex AND health = good

I'm really having troubles with its syntax, multi-match queries don't work in my case, what type of query should I use?

nikoshr · Accepted Answer · 2017-02-08 13:25:25Z

1

You can use multiple must clauses in a bool query to combine queries. For example,

{
    "query": {
        "bool": {
            "must": [
                {
                    "term": {"name" : "alex"}
                },
                {
                    "term": {"health" : "good"}
                }
            ]
        }
    }
}

answered Feb 8, 2017 at 13:25

nikoshr

33.4k34 gold badges94 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How I can get a simple query multimatch text in SQL in Elasticsearch?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related