9710. Basic Queries in Elasticsearch
Elasticsearch

Notes for Elastic Search.

2. Usage

2.1 Creating

POST shop/customer/1

{
  "name": "Johnny",
  "address": "1234 Hillview Ave, Palo Alto",
  "level": "Silver"
}

Response:

{
  "_index": "shop",
  "_type": "customer",
  "_id": "1",
  "_version": 1,
  "result": "created",
  "_shards": {
    "total": 2,
    "successful": 1,
    "failed": 0
  },
  "created": true
}

Create another two users.

POST shop/customer/2

{
  "name": "Sean",
  "address": "1010 Steven Creek Ave, Cupertino",
  "level": "Bronze"
}
POST shop/customer/3

{
  "name": "Norah",
  "address": "340 Lawrence Station Rd, Sunnyvale",
  "level": "Bronze"
}

2.2 Getting

GET shop/customer/1

Response:

{
  "_index": "shop",
  "_type": "customer",
  "_id": "1",
  "_version": 1,
  "found": true,
  "_source": {
    "name": "Johnny",
    "address": "1234 Hillview Ave, Palo Alto",
    "level": "Silver"
  }
}

2.3 Updating

PUT shop/customer/1

{
  "name": "Johnny",
  "address": "1234 Hillview Ave, Palo Alto",
  "level": "Golden"
}

Response:

{
  "_index": "shop",
  "_type": "customer",
  "_id": "1",
  "_version": 2,
  "result": "updated",
  "_shards": {
    "total": 2,
    "successful": 1,
    "failed": 0
  },
  "created": false
}

2.4 Deleting

DELETE shop/customer/3

Response:

{
  "found": true,
  "_index": "shop",
  "_type": "customer",
  "_id": "3",
  "_version": 2,
  "result": "deleted",
  "_shards": {
    "total": 2,
    "successful": 1,
    "failed": 0
  }
}

Search

Get shop/customer/3

Response:

{
  "_index": "shop",
  "_type": "customer",
  "_id": "3",
  "found": false
}

2.5 Searching

a) Search all customers

GET /shop/customer/_search

Response:

{
  "took": 4,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "failed": 0
  },
  "hits": {
    "total": 2,
    "max_score": 1,
    "hits": [
      {
        "_index": "shop",
        "_type": "customer",
        "_id": "2",
        "_score": 1,
        "_source": {
          "name": "Sean",
          "address": "1010 Steven Creek Ave, Cupertino",
          "level": "Bronze"
        }
      },
      {
        "_index": "shop",
        "_type": "customer",
        "_id": "1",
        "_score": 1,
        "_source": {
          "name": "Johnny",
          "address": "1234 Hillview Ave, Palo Alto",
          "level": "Golden"
        }
      }
    ]
  }
}

a) Search the customer named ‘Johnny’

GET /shop/customer/_search?q=name:Johnny

Response:

{
  "took": 3,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "failed": 0
  },
  "hits": {
    "total": 1,
    "max_score": 0.2876821,
    "hits": [
      {
        "_index": "shop",
        "_type": "customer",
        "_id": "1",
        "_score": 0.2876821,
        "_source": {
          "name": "Johnny",
          "address": "1234 Hillview Ave, Palo Alto",
          "level": "Golden"
        }
      }
    ]
  }
}

3. Reference