ElasticSearch regex return no result

Question

I have this query using match type and it returns results.

POST /kibana_sample_data_ecommerce/_search
{
    "query": {
        "match": {
            "customer_first_name": "Mary"
        }
    }
}

But when I use regex type, it return no result.

POST /kibana_sample_data_ecommerce/_search
{
    "query": {
        "regexp": {
            "customer_first_name": "M[a-z]ry"
        }
    }
}

"customer_first_name" : { "type" : "text", "fields" : { "keyword" : { "type" : "keyword", "ignore_above" : 256 } } }, — Steve
– Steve, Commented Oct 2, 2020 at 7:31

Val · Accepted Answer · 2020-10-02 07:34:14Z

1

Since customer_first_name is analyzed, you need to do it like this (see the lowercase m):

POST /kibana_sample_data_ecommerce/_search
{
    "query": {
        "regexp": {
            "customer_first_name": "m[a-z]ry"
        }
    }
}

Or you can also use the keyword sub-field in order to achieve what you want:

POST /kibana_sample_data_ecommerce/_search
{
    "query": {
        "regexp": {
            "customer_first_name.keyword": "M[a-z]ry"
        }
    }
}

answered Oct 2, 2020 at 7:34

Val

218k14 gold badges377 silver badges384 bronze badges

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

Collectives™ on Stack Overflow

ElasticSearch regex return no result

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