🚀 DevOps & SRE Certification Program 📅 Starting: 1st of Every Month 🤝 +91 8409492687 🔍 Contact@DevOpsSchool.com

Upgrade & Secure Your Future with DevOps, SRE, DevSecOps, MLOps!

We spend hours on Instagram and YouTube and waste money on coffee and fast food, but won’t spend 30 minutes a day learning skills to boost our careers.
Master in DevOps, SRE, DevSecOps & MLOps!

Learn from Guru Rajesh Kumar and double your salary in just one year.


Get Started Now!

Uncategorised

Elasticsearch Lab#3 – DSL Query Collection Part#1

September 24, 2021 comments off
Returns search hits that match the query defined in the request.
=======================
Request
GET /<index>/_search
POST /<index>/_search
GET /_search
POST /_search
QUERY TERM SPECIFICATION - 2 WAYS
1. QUERY PARAMETERS (Search terms as URL query parameters)
CURL
FULL URL ON BROWSERS
2. REQUEST BODY (Search terms within the URL request body)
=======================================================================================
Search terms as URL query parameters
=======================================================================================
curl -XGET 'localhost:9200/customers/_search?q=wyoming&pretty'
localhost:9200/customers/_search?q=wyoming&pretty
curl -XGET 'localhost:9200/customers/_search?q=wyoming&sort=age:desc&pretty'
curl -XGET 'localhost:9200/customers/_search?q=wyoming&sort=age:asc&pretty'
curl -XGET 'localhost:9200/customers/_search?q=state:kentucky&pretty'
curl -XGET 'localhost:9200/customers/_search?q=state:kentucky&sort=age:asc&pretty'
curl -XGET 'localhost:9200/customers/_search?q=state:kentucky&from=10&size=2&pretty'
curl -XGET 'localhost:9200/customers/_search?q=state:kentucky&pretty'
????
curl -XGET 'localhost:9200/customers/_search?q=wyoming&explain&pretty'
curl -XGET 'localhost:9200/customers/_search?q=state:kentucky&explain&pretty'
=======================================================================================
Searching using the request body
=======================================================================================
curl -XGET 'localhost:9200/customers/_search?pretty' -H 'Content-Type: application/json' -d'
{
"query": { "match_all": {} }
}
'
curl -XGET 'localhost:9200/customers/_search?pretty' -H 'Content-Type: application/json' -d'
{
"query": {}
}
'
curl -XGET 'localhost:9200/customers/_search?pretty=true&q=*:*'
curl -XGET 'localhost:9200/customers/_search?pretty' -H 'Content-Type: application/json' -d'
{
"query": { "match_all": {} },
"size": 3
}
'
curl -XGET 'localhost:9200/customers/_search?pretty' -H 'Content-Type: application/json' -d'
{
"query": { "match_all": {} },
"size": 2
}
'
curl -XGET 'localhost:9200/customers/_search?pretty' -H 'Content-Type: application/json' -d'
{
"query": { "match_all": {} },
"from": 5,
"size": 3
}
'
curl -XGET 'localhost:9200/customers/_search?pretty' -H 'Content-Type: application/json' -d'
{
"query": { "match_all": {} },
"sort": { "age": { "order": "desc" } },
"size": 20
}
'
=======================================================================================
Search Multiple Indices
=======================================================================================
curl -XGET 'localhost:9200/customers,products/_search?pretty'
=======================================================================================
Search Multiple Doc Types
=======================================================================================
curl -XGET 'localhost:9200/products/shoes,laptops/_search?pretty'
=======================================================================================
ACTUAL SEARCH - Query terms and source filtering
=======================================================================================
curl -XGET 'localhost:9200/customers/_search?pretty' -H 'Content-Type: application/json' -d'
{
"query" : {
"term" : { "name" : "gates" }
}
}
'
curl -XGET 'localhost:9200/customers/_search?pretty' -H 'Content-Type: application/json' -d'
{
"query" : {
"term" : { "street" : "chestnut" }
}
}
'
=======================================================================================
Source filtering
=======================================================================================
curl -XGET 'localhost:9200/customers/_search?pretty' -H 'Content-Type: application/json' -d'
{
"_source" : false,
"query" : {
"term" : { "street" : "chestnut" }
}
}
'
curl -XGET 'localhost:9200/customers/_search?pretty' -H 'Content-Type: application/json' -d'
{
"_source" : "st*",
"query" : {
"term" : { "state" : "washington" }
}
}
'
curl -XGET 'localhost:9200/customers/_search?pretty' -H 'Content-Type: application/json' -d'
{
"_source" : ["st*", "*n*"],
"query" : {
"term" : { "state" : "washington" }
}
}
'
curl -XGET 'localhost:9200/customers/_search?pretty' -H 'Content-Type: application/json' -d'
{
"_source": {
"includes": ["st*", "*n*"],
"excludes": [ "*der" ]
},
"query" : {
"term" : { "state" : "washington" }
}
}
'
view raw Elasticsearch-DSL-Query-Collection-Part-1.txt hosted with ❤ by GitHub

Reference

  • Sample Data & Query – https://github.com/devopsschool-demo-labs-projects/elasticsearch

Certification Courses

DevOpsSchool has introduced a series of professional certification courses designed to enhance your skills and expertise in cutting-edge technologies and methodologies. Whether you are aiming to excel in development, security, or operations, these certifications provide a comprehensive learning experience. Explore the following programs:

DevOps Certification, SRE Certification, and DevSecOps Certification by DevOpsSchool

Explore our DevOps Certification, SRE Certification, and DevSecOps Certification programs at DevOpsSchool. Gain the expertise needed to excel in your career with hands-on training and globally recognized certifications.