.keyword columns empty in "Discover"

[sspilleman (Sander Spilleman)]

Hi,

I'm indexing quite a few text mappings to alse have a .keyword couterpart with type keyword.

Like:

"country": {
            "type": "text",
            "fields": {
              "keyword": {
                "type": "keyword",
                "ignore_above": 256
              }
            }
          }

When I add the country.keyword as one of the columns, the value is empty. Hence I have to add both "country" AND "country.keyword" columns if want to see the value and have the option to sort on them by clicking on the sort arrow in the column title.... This is rather annoying as it consumes quite some screen estate and its cumbersome to add the country.keyword one as I have to first "show missing fields" before I can select it....

Am I missing something / not doing it right?

Regards,

Sander

[tsullivan (Tim Sullivan)]

You can make your country field mapped as keyword, and have a country.text field mapped as text:

        "country": {
          "type": "keyword",
          "ignore_above": 256,
          "fields": {
            "text": {
              "type": "text"
            }
          }
        }

[tsullivan (Tim Sullivan)]

Depending on your use case, you might not really need that text field though