Using Kibana 7.16.2 I'm trying to create new simple visualization as table, using aggregation based on nested field and it is not available for selection. Using Dev Tools I can search nested fields.
I use the simplest example from ELK documentation:
Create index:
PUT /drivers
{
"mappings": {
"properties": {
"driver": {
"type": "nested",
"properties": {
"last_name": {
"type": "keyword"
},
"vehicle": {
"type": "nested",
"properties": {
"make": {
"type": "keyword"
},
"model": {
"type": "keyword"
}
}
}
}
}
}
}
}
Add document:
PUT /drivers/_doc/1
{
"driver" : {
"last_name" : "McQueen",
"vehicle" : [
{
"make" : "Powell Motors",
"model" : "Canyonero"
},
{
"make" : "Miller-Meteor",
"model" : "Ecto-1"
}
]
}
}
I can query
GET /drivers/_search
{
"query": {
"nested": {
"path": "driver",
"query": {
"nested": {
"path": "driver.vehicle",
"query": {
"bool": {
"must": [
{ "match": { "driver.vehicle.make": "Powell Motors" } },
{ "match": { "driver.vehicle.model": "Canyonero" } }
]
}
}
}
}
}
}
}
But when I'm trying to see that field in Kibana, it simply doesn't show up
Any idea is appriciated.