Elasticsearch prefix query not working on date

Question

I have the following documents in elasticsearch, and I'd like to apply prefix query on logtime field, but nothing would return.

      {
    "_index" : "test",
    "_type" : "fluentd",
    "_id" : "6Cn38mMBMKvgU4HnnURh",
    "_score" : 1.0,
    "_source" : {
      "logtime" : "2018-06-11 03:08:02,117",
      "userid" : "",
      "payload" : "40",
      "qs" : "[['I have a dream, that everybody'], ['the'], ['steins']]"
    }
  }

the prefix query is

curl -X GET "localhost:9200/test/_search" -H 'Content-Type: application/json' -d'{ "query": {"prefix" : { "logtime" : "2018-06-11" }}}'

Could someone help? Thanks a lot.

Do you want to fetch All documents of date 2018-06-11.

Richa
– Richa

2018-06-13 04:36:13 +00:00
Commented Jun 13, 2018 at 4:36 — Richa
– Richa, Commented Jun 13, 2018 at 4:36
@Richa yes, this is my requirement.

Jeff
– Jeff

2018-06-13 04:40:05 +00:00
Commented Jun 13, 2018 at 4:40 — Jeff
– Jeff, Commented Jun 13, 2018 at 4:40

Richa · Accepted Answer · 2018-06-13 05:38:14Z

3

You can use Range Query in that case like

{
 "query": {
  "range": {
  "createdDate": {
    "gte":"2018-06-11",
    "lte": "2018-06-11",
    "format": "yyyy-MM-dd"
    }
   }
  }
 }

Hope it helps.

answered Jun 13, 2018 at 5:38

Richa

7,6796 gold badges30 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

Elasticsearch prefix query not working on date

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