How to write a simple regexp query using elasticsearch in python?

Question

I am trying to write a simple regexp query using elasticsearch in python that just won't work. Can anybody tell me where I'm going wrong ?

result = es.search(index="my-index", body={"query": {"regexp": {"Name": "Vi.*" }}})

The indexed document is a list of names with my name also in it (Vitthal Bhandari). The above query always yields empty results when it should return my name instead. The document is properly indexed and other queries work just fine. For instance a match query gives the required result.

result = es.search(index="my-index", body={"query": {"match": {"Name": "Vitthal" }}})

What is the problem with the regexp query that I'm writing that it won't give any result? Any suggestions?

**EDIT : ** The "Name" mapping is given below :

"Name" : {
          "type" : "text",
          "fields" : {
            "keyword" : {
              "type" : "keyword",
              "ignore_above" : 256
            }
          }
        },

Add a sample document and mapping of name also

Gibbs
– Gibbs

2020-06-23 08:54:02 +00:00
Commented Jun 23, 2020 at 8:54 — Gibbs
– Gibbs, Commented Jun 23, 2020 at 8:54

Gibbs · Accepted Answer · 2020-06-23 09:45:17Z

3

As per your mapping

"Name" : {
          "type" : "text",
          "fields" : {
            "keyword" : {
              "type" : "keyword",
              "ignore_above" : 256
            }
          }
        }

You have default analyzer

To make it work:

{"query": {"regexp": {"Name": "vi.*" }}}

Use lower case.

Reason for Vi.* not working:

regexp is a term query. It is not a full text search query.

Unlike full-text queries, term-level queries do not analyze search terms. Instead, term-level queries match the exact terms stored in a field.

So, it expects terms starting with Vi in the index which is not true as it is analysed and stored as vi..

Reference

answered Jun 23, 2020 at 9:45

Gibbs

23.1k14 gold badges84 silver badges147 bronze badges

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

2 Comments

VITTHAL BHANDARI Over a year ago

Thanks for the solution. It worked. While we're at it can you help me with another thing. The next step in my program is to get the search string as an input from the user, i.e., in above example the string "Vi" is to be taken as input from user at run time. Let's say the string is stored in a variable str. How do I formulate a query using str ?

Gibbs Over a year ago

Please reply to my comment at here

Jozef - Spatialized.io · Accepted Answer · 2020-06-23 09:04:27Z

1

Use

{
  "query": {
    "regexp": {
      "Name": "vi.*"
    }
  }
}

or

{
  "query": {
    "regexp": {
      "Name.keyword": "Vi.*"
    }
  }
}

answered Jun 23, 2020 at 9:04

Jozef - Spatialized.io

17k4 gold badges29 silver badges79 bronze badges

Collectives™ on Stack Overflow

How to write a simple regexp query using elasticsearch in python?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related