Search on date string in ElasticSearch

Question

I have date field, which is stored with following mapping:

"RecordedDate": {
                  "type": "string",
                  "analyzer": "DateAndNumber"
               }

Here is analyzer:

 "DateAndNumber": {
                     "pattern": "([/\\-]+)",
                     "type": "pattern"
                  }

When I'm searching with following query:

"query": {
    "query_string": {
        "default_field": "RecordedDate", 
      "query": "RecordedDate:2\\/2\\/1902",
      "default_operator": "and"
}

I've got a lot of irrelevant search results which contains 2 and 1902 terms. E.g: 2/18/1902, 5/2/1902 instead of 2/2/1902.

Is there any way to make the analyzer take term position/offset into account as well?

Michele Palmia · Accepted Answer · 2016-02-24 11:45:27Z

1

You can set auto_generate_phrase_queries to true in the query you suggestef. You can find more details in the docs. If that doesn't work for you, you could also use a phrase query directly - a phrase query does exactly what you're asking for.

If you only have dates in your DateAndNumber field, using a date type for the field might be the best option though.

answered Feb 24, 2016 at 11:45

Michele Palmia

2,4922 gold badges25 silver badges29 bronze badges

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

4 Comments

vmeln Over a year ago

I received query malformed, no field after start_object with auto_generate_phrase_queries set to true. Also, phrase query is not the solution, somebody could search, only part of date 5/1902.

Michele Palmia Over a year ago

the query malformed is not related to the auto_generate clause being added: you probably forgot the outermost query field. as of the issue with part of the query - that will always be the case if you use a normal match query to match dates this way

vmeln Over a year ago

Just put that property in wrong place, sorry. Alas that didn't help. For the match query - I also can't use it, this is case for one field, I've got a lot of ones, and I hope to fix it with analyzer/tokenizer/data type.

vmeln Over a year ago

Just to get rid of misleading information, auto_generate_phrase_queries helped. It works as expected, there was some problems with analyzer.

Collectives™ on Stack Overflow

Search on date string in ElasticSearch

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related