Query timestamp range using elasticsearch-dsl-py

Question

I have an elasticsearch range query that I'd like to translate into elasticsearch-dsl:

Elasticsearch Python API

{"range": 
    {"@timestamp": 
        {"gte": 1570258800000, 
         "lte": 1571036400000, 
         "format": "epoch_millis"
        }
     }
 }

Elasticsearch-DSL-Py Query?

from elasticsearch import Elasticsearch
from elasticsearch_dsl import Search

client = Elasticsearch(<connection_details>)

s = Search(using=client, index="my-index") \
    .query("???")

Ashish Tiwari · Accepted Answer · 2019-10-19 16:58:04Z

6

Try this:

from elasticsearch import Elasticsearch
from elasticsearch_dsl import Search

client = Elasticsearch(<connection_details>)

s = Search(using=client, index="my-index") \
    .filter('range' ,  **{'@timestamp': {'gte': 1570258800000 , 'lt': 1571036400000, 'format' : 'epoch_millis'}})

answered Oct 19, 2019 at 16:58

Ashish Tiwari

2,3971 gold badge18 silver badges28 bronze badges

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

1 Comment

Sandeepa Kariyawasam Over a year ago

Is it possible to use string values as starting and ending date? do I need to specify the format if so ?

Honza Král · Accepted Answer · 2019-10-19 02:52:39Z

2

s = s.query('range', **{'@timestamp': {'gte': ...}})

Hope this helps

answered Oct 19, 2019 at 2:52

Honza Král

3,03216 silver badges11 bronze badges

Comments

Prakash2403 · Accepted Answer · 2022-10-27 07:21:18Z

0

You can also supply the date in string format (YYYY-MM-DD). Here's a snippet

from elasticsearch import Elasticsearch
from elasticsearch_dsl import Search

client = Elasticsearch()

date_from = '2022-10-01' # Oct 01, 2022
date_to = '2022-10-05' # Oct 05, 2022

s = Search(using=client)
s = s.query('range', **{'published': {'gte': date_from, 'lte': date_to}})

edited Oct 27, 2022 at 7:21

answered Oct 27, 2022 at 7:19

Prakash2403

12 bronze badges

Collectives™ on Stack Overflow

Query timestamp range using elasticsearch-dsl-py

Elasticsearch Python API

Elasticsearch-DSL-Py Query?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Elasticsearch Python API

Elasticsearch-DSL-Py Query?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related