Search code examples
elasticsearchelasticsearch-6

How to find out what is my index sorted by in elasticsearch?


I created new index in elasticsearch (v6) using command:

curl -XPUT -H 'Content-Type: application/json' http://localhost:9200/sorttest -d '
{
    "settings" : {
        "index" : {
            "sort.field" : ["username", "date"], 
            "sort.order" : ["asc", "desc"] 
        }
    },
    "mappings": {
        "_doc": {
            "properties": {
                "username": {
                    "type": "keyword",
                    "doc_values": true
                },
                "date": {
                    "type": "date"
                }
            }
        }
    }
}
'

The response was

{"acknowledged":true,"shards_acknowledged":true,"index":"sorttest"}

Next I checked out generated mapping

curl -XGET localhost:9200/sorttest/_mapping?pretty

And the result was

{
  "sorttest" : {
    "mappings" : {
      "_doc" : {
        "properties" : {
          "date" : {
            "type" : "date"
          },
          "username" : {
            "type" : "keyword"
          }
        }
      }
    }
  }
}

The question is: how can I find out what kind of sorting is set for my index?


Solution

  • Just

    curl -XGET localhost:9200/sorttest?pretty
    

    and you will see:

    "settings" : {
      "index" : {
        ...
        "sort" : {
          "field" : [
            "username",
            "date"
          ],
          "order" : [
            "asc",
            "desc"
          ]
        },
        ...
      }
    }