Elasticsearch - query for keyword value

Question

ES 7.8, mapping:

    "id": {
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 300
        },
        "lower_case_sort": {
          "type": "keyword",
          "ignore_above": 10,
          "normalizer": "case_insensitive_sort"
        }
      }
    }

How can I search my index and get id.keyword and id.lower_case_sort values? All I can get is id value

Val · Accepted Answer · 2020-07-23 08:47:00Z

2

You can retrieve the actual terms that have been indexed in sub-fields using docvalue_fields (only works for non-text fields).

For instance, if you index this

POST test/_doc
{
  "id": "ONE two"
}

You can retrieve the actual doc values using:

GET test/_search
{
  "docvalue_fields": ["id.keyword", "id.lower_case_sort"]
}

And you'll get this:

"hits" : [
  {
    "_index" : "test",
    "_type" : "_doc",
    "_id" : "bZ3NenMBfUaK6xUNT7vB",
    "_score" : 1.0,
    "_source" : {
      "id" : "ONE two"
    },
    "fields" : {
      "id.lower_case_sort" : [
        "one two"
      ],
      "id.keyword" : [
        "ONE two"
      ]
    }
  }
]

As you can see, you get

the original value in _source.id
the indexed doc values for each sub-field in fields.id.keyword and fields.id.lower_case_sort

edited Jul 23, 2020 at 8:47

answered Jul 23, 2020 at 8:38

Val

218k14 gold badges377 silver badges384 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ByeBye Over a year ago

only works for non-text fields ? ah ok, keyword is not text

Val Over a year ago

What I meant was only on fields that are not of type text

Collectives™ on Stack Overflow

Elasticsearch - query for keyword value

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related