Kibana: Composite Aggregation in kibana visualization ?

[florianajir]

Hello,

I'm unable to create a data-table visualization splitting rows by terms on a nested object.

My index is called medias and contain a nested property called tags. My need seems really simple: I want to count each tag in medias index.

But as you can see in the screenshot below, when I enable this terms aggregation, not any data is displayed anymore..

An exemple of media document in my index:

{
  "_index": "medias",
  "_type": "doc",
  "_id": "1234",
  "_score": 1,
  "_source": {
    "tags": [
      {
        "slug": "print",
        "name": "print",
        "created_at": "2016-06-24T13:39:11+0000",
        "updated_at": "2018-02-06T12:49:27+0000",
        "status": "enabled"
      },
      {
        "slug": "pattern",
        "name": "pattern",
        "created_at": "2016-06-06T12:02:34+0000",
        "updated_at": "2018-02-06T12:22:36+0000",
        "status": "enabled"
      }
    ],
    "slug": "1234",
    "type": "woman",
    "look": 23,
    "name": "LOOK23.jpg",
    "created_at": "2018-07-04T12:25:03+0000",
    "updated_at": "2018-07-04T12:25:03+0000",
    "status": "enabled"
  }
}

Please help me, and tell me I'm missing something, I don't found any doc about this purpose..

Thanks

[timroes]

Could you please share the mapping of your index?

[florianajir]

Sure, here it is (thank you for your help) :

{
  "mappings": {
    "doc": {
      "properties": {
        "slug": {
          "type": "keyword"
        },
        "name": {
          "type": "keyword"
        },
        "status": {
          "type": "keyword"
        },
        "created_at": {
          "type": "date"
        },
        "updated_at": {
          "type": "date"
        },
        "type": {
          "type": "keyword"
        },
        "look": {
          "type": "short"
        },
        "tags": {
          "type": "nested",
          "properties": {
            "slug": {
              "type": "keyword"
            },
            "name": {
              "type": "keyword"
            },
            "status": {
              "type": "keyword"
            },
            "created_at": {
              "type": "date"
            },
            "updated_at": {
              "type": "date"
            }
          }
        }
      }
    }
  }
}

[timroes]

Hi,

unfortunately Kibana doesn't support nested types yet (see #1084).
So you need to follow that ticket until nested types are implemented in Kibana.

Cheers,
Tim

[florianajir]

This ticket has been created 4 years ago and the @ppadovani plugin is not compatible with kibana v6.3.
It looks hopeless/deadend

[ppadovani]

@florianajir I have an issue opened to port to 6.3. I generally do not port until someone asks for the version bump. I should have the port done this weekend.