How can we achieve below query in elastic?

Elastic Stack Elasticsearch
1

where name='manikesh' and age=35 and company='elastic'?

I know we did not have and operation supported in elastic but do we have it now? what other ways to achieve this?

2

Hi Manikesh,

You can use bool query with must option.

Take reference from
https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-bool-query.html

3

Thanks .. just wanted to understand..when Lucene supports AND operation then why not elastic.. is there any specific reason..

4

Lucene's query parser supports AND operator but under the covers this is translated into Lucene Bool query objects that use MUST. We reflect the Lucene core and not one (of several) query string syntaxes built on this core.

5

This explains everything.. thanks much..

6

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.