elasticsearch - search with regex involving space

Question

I want to perform searching using regular expression involving whitespace in elasticsearch. I have already set my field to not_analyzed. And it's mapping is just like

"type1": {
   "properties": {
      "field1": {
         "type": "string",
         "index": "not_analyzed",
         "store": true
      }
   }
}

And I input two value for test,

"field1":"XXX YYY ZZZ"
"field1":"XXX ZZZ YYY"

And i do some case using regex query /XXX YYY/
(I want to use this query to find record1 but not record2)

{
    "query": {
        "query_string": {
           "query": "/XXX YYY/"
        }
    }
}

But it return 0 results.

However if I search without using regex (without the forward slash '/'), both record1 and record2 are returned.

Is that in elasticsearch, i cannot search using regex query involving space?

read this stackoverflow.com/a/25316837/3087680

Amen
– Amen

2019-05-18 11:29:16 +00:00
Commented May 18, 2019 at 11:29 — Amen
– Amen, Commented May 18, 2019 at 11:29

Jens Egholm · Accepted Answer · 2015-10-04 13:47:14Z

1

What you need is a ''term'' query that doesn't tokenise the search query by breaking it down into smaller parts. More about the term query here: https://www.elastic.co/guide/en/elasticsearch/reference/2.0/query-dsl-term-query.html

There's a special breed of term queries that allows you to use regexes called regexp queries. That should match any whitespaces as well: https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-regexp-query.html

answered Oct 4, 2015 at 13:47

Jens Egholm

2,7103 gold badges24 silver badges35 bronze badges

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

Comments

Val · Accepted Answer · 2015-10-05 03:34:16Z

0

You can keep using your query string, but your regexp is just missing a tiny part, i.e. the .* at the end. If you run that you'll get the single result you expect.

{
    "query": {
        "query_string": {
           "query": "/XXX YYY.*/"
        }
    }
}

answered Oct 5, 2015 at 3:34

Val

218k14 gold badges377 silver badges384 bronze badges

4 Comments

Tabbernaut Over a year ago

This does not work for my use-case. "/XXX YYY.*/" will match a string like XXX YYY blah blah blah. However, "/XXX YYY .* something else/" will not match XXX YYY blah blah something else... No clue yet as to why...

Val Over a year ago

@Tabbernaut feel free to create a new question for your specific issue

Tabbernaut Over a year ago

Figured out a way: "/XXX YYY.*/" AND "/.*something else/" works. It just can't be done in a single clause, I guess.

Val Over a year ago

@Tabbernaut not sure about your use case, feel free to create a new question

bittusarkar · Accepted Answer · 2015-10-04 14:17:20Z

-1

You can use regexp queries to achieve this. Mind you, the query performance may be slow. The below query will search for all documents in which the value of field1 contains "XXX YYY".

POST <index_name>/type1/_search
{
   "query": {
      "regexp": {
         "field1": ".*XXX YYY.*"
      }
   }
}

answered Oct 4, 2015 at 14:17

bittusarkar

6,3674 gold badges36 silver badges51 bronze badges

2 Comments

AbtPst Over a year ago

i dont think that recognizes the space character. i also tried \s but that did not work

bittusarkar Over a year ago

@AbtPst Why do you say that? Note that the field "field1" is marked as "not_analyzed". That will result in Elasticsearch not tokenizing around whitespaces. So my query will work.

Collectives™ on Stack Overflow

elasticsearch - search with regex involving space

3 Answers 3

Comments

4 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related