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("???")

score 6 · Accepted Answer · answered Oct 19 '19 at 16:58

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 '19 at 16:58

Ashish Tiwari

1,919
1
14
26

Is it possible to use string values as starting and ending date? do I need to specify the format if so ? – Sandeepa Kariyawasam Apr 01 '22 at 04:37

score 2 · Answer 2 · answered Oct 19 '19 at 02:52

2

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

Hope this helps

answered Oct 19 '19 at 02:52

Honza Král

2,982
14
11

Prakash2403 · Answer 3 · 2022-10-27T07:21:18.203

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 '22 at 07:21

answered Oct 27 '22 at 07:19

Prakash2403

1
2

Query timestamp range using elasticsearch-dsl-py

Elasticsearch Python API

Elasticsearch-DSL-Py Query?

3 Answers3