How to write global query in elasticsearch?

Question

I want to create top search query using elasticsearch.

I want to match category_name, brand_name and title from elasticsearch table. The match should be phrase and with or condition.

My query:

$query = [
  "bool" => [
    "must" => [
      ["match" => ["is_published" => 1]],
      [
        "multi_match" => [
          "query" => $searchKey,
          "fields" => ["category_name", "brand_name", "title"]
        ]
      ],
      [
        'nested' => [
          'path' => 'category_with_in_title.parent_cat',
          'query' => [
            'bool' => [
              'must' => [

                ['match' => [
                  'category_with_in_title.parent_cat.status' => 1,
                ]],
              ],
            ],
          ],
        ],
      ],
      [
        'nested' => [
          'path' => 'brand',
          'query' => [
            'bool' => [
              'must' => [
                'match' => [
                  'brand.approved_status' => 1,
                ],
              ],
            ],
          ],
        ],
      ],
      [
        'nested' => [
          'path' => 'default_product_low_price_with_seller.seller_detail',
          'query' => [
            'bool' => [
              'must' => [
                'match' => [
                  'default_product_low_price_with_seller.seller_detail.approve_status' => 1,
                ],
              ],
            ],
          ],
        ],

      ],
      [
        'nested' => [
          'path' => 'default_product_low_price_with_seller',
          'query' => [
            'bool' => [
              'must' => [
                'match' => [
                  'default_product_low_price_with_seller.status' => 1,
                ],
              ],
            ],
          ],
        ],
      ],
    ],

  ],
];

I use multi_match for that but how to use pharse in this query? I have to write whole word to search.

For example :

I want to search the record whose category_name = Tops

I want result if i write "tops" or "top" or "to". But right now I have to write "Tops" the exact word.

Thanks in advance...

Cosmin Ababei · Accepted Answer · 2016-04-12 11:32:50Z

1

You could use match_phrase_prefix, which is the same as match_phrase, except that it allows for prefix matches on the last term in the text.

All that you need to do, is add "type": "phrase_prefix" to your multi_match query, like this:

"multi_match" => [
  "query" => $searchKey,
  "type": "phrase_prefix",
  "fields" => ["category_name", "brand_name", "title"]
]

Let me know if this is what you're looking for.

answered Apr 12, 2016 at 11:32

Cosmin Ababei

7,0722 gold badges22 silver badges35 bronze badges

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

2 Comments

Varun Natraaj Over a year ago

This approach has a limitation. Default max_expansions is 50 and increasing it might affect your query response time. Reference: elastic.co/guide/en/elasticsearch/guide/current/…

David Coder Over a year ago

Thanks sir, but this is not working i am not getting any records

Mysteryos · Accepted Answer · 2016-04-12 12:32:39Z

1

Ideally you should use multi_match with cross_fields type, which will treat all fields as ONE big field and run your query on it. However, due to fuzziness being disabled on these, only the exact match will show.

See Revelant Github Issue https://github.com/elastic/elasticsearch/issues/6866

Hence, my recommendation is to replace multi_match with fuzzy_like_this (elasticsearch version 1.x) or more_like_this (elasticsearch version 2.x).

$query = [
  "bool" => [
    "must" => [
      ["match" => ["is_published" => 1]],
      [
        "fuzzy_like_this" => [
            "fields" => ["category_name", "brand_name", "title"],
            "like_text" => $searchKey
        ]
      ],
      ....

answered Apr 12, 2016 at 12:32

Mysteryos

5,8013 gold badges35 silver badges54 bronze badges

6 Comments

David Coder Over a year ago

Thanks sir it works but I have to write full word to search. For example i want to get records which category_name = Tops then i have to write 'tops' or 'top' to get that records. I am not get any record if I write 'to' (to search tops).

Mysteryos Over a year ago

In the fuzzy_like_this array, add "fuzziness" => 3. This will increase the likelihood of matches. It may also point to the fact that your indexes may not be analyzed. see: elastic.co/guide/en/elasticsearch/guide/current/…

David Coder Over a year ago

Sir may I use query without change the structure to analyzed ?

David Coder Over a year ago

i want to search partial search from sentence but without change the structure

Mysteryos Over a year ago

You'll have to rebuild your index from ground up if you switch the mapping around.

|

Collectives™ on Stack Overflow

How to write global query in elasticsearch?

2 Answers 2

2 Comments

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related