Data Science Master. ElasticSearch and Kibana. Session 4: Querying ElasticSearch

Introduction to the REST API provided by ElasticSearch.

Transcript

1. Querying ElasticSearch Daniel Izquierdo Cortázar dizquierdo@bitergia.com / @dizquierdo Bitergia
2. Outline Introduction ElasticSearch DSL Python Examples Daniel Izquierdo Cortázar Máster en Data Science. ETSII. 2
3. ElasticSearch DSL Two main contexts: Query: looking for matches How well does this document match with this query? Filter: filtering data as in SQL Does this document match with this query? Daniel Izquierdo Cortázar Máster en Data Science. ETSII. 3
4. ElasticSearch DSL And we can match, term or range queries So we can query + match or filter + term. Daniel Izquierdo Cortázar Máster en Data Science. ETSII. 4
5. ElasticSearch DSL Match: accepts text/numerics/dates GET /_search { "query": { "match" : { "message" : "this is a test" } } } Daniel Izquierdo Cortázar Máster en Data Science. ETSII. 5
6. ElasticSearch DSL Term: look for the exact value GET my_index/my_type/_search { "query": { "term": { "status": "open" } } } Daniel Izquierdo Cortázar Máster en Data Science. ETSII. 6
7. ElasticSearch DSL Ranges: numerics and dates GET _search { "query": { "range" : { "date" : { "gte" : "now-1d/d", "lt" : "now/d" } } } } Daniel Izquierdo Cortázar Máster en Data Science. ETSII. 7
8. ElasticSearch DSL Example of use https://github.com/dicortazar/ipython-notebooks/blob/master/teaching/masterdatascience/OPNFV%20Metrics%20with%20E lasticSearch%20DSL.ipynb Daniel Izquierdo Cortázar Máster en Data Science. ETSII. 8