elasticsearch spike snippets

gistfile1.txt

PUT db1

PUT db1/table1/_mapping
{ 
    "dynamic_templates": [{
      "non_analyzed_string": {
        "match": "*",
        "match_mapping_type": "string",
        "mapping": {
          "type": "string",
          "index": "not_analyzed"
        }
      }
    }
  ]
}


POST _search
{
    "query": {
        "prefix": 
            { "title": "bbb" }
    }
}

POST _search
{
    "from": 0,
    "size": 5,
    "sort" : [
        { "age" : "desc" }
    ],
    "query": {
        "filtered": {
            "filter": {
                "and" : [
                    {
                        "range" : {
                            "age" : {
                                "gte" : 10,
                                "lte" : 20
                            }
                        }
                    },
                    {
                        "term": {
                            "title": "bbb"
                        }
                    }
                ]
            }
        }
    }
}

POST _search
{
    "sort" : [
        { "title" : "asc" }
    ],
    "query": {
        "match_all": {}
    }
}

POST _search
{
   "query": {
      "match_all": {}
   }
}

POST db1/table1
{
  "title": "bbb",
  "age": 11
}

GET _all

DELETE db1