# Nested Type in Kibana

**URL:** <https://discuss.elastic.co/t/nested-type-in-kibana/169980>\
**Category:** Elasticsearch\
**Created:** [February 26, 2019, 10:57am UTC](https://discuss.elastic.co/t/nested-type-in-kibana/169980 "2019-02-26T10:57:38Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![RAM\_NATHAN](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ram_nathan/32/50393_2.png) [@RAM\_NATHAN](https://discuss.elastic.co/u/RAM_NATHAN)\
**Post date:** [February 26, 2019, 10:57am UTC](https://discuss.elastic.co/t/nested-type-in-kibana/169980/1 "2019-02-26T10:57:38Z")

</div>

Hi

I'm using Kibana 5.6.13 and I'm having nested type as below

{  
"test": {  
"mappings": {  
"sessions": {  
"properties": {

```
      "appdata": {
        "type": "nested",
        "properties": {
          "accessType": {
            "type": "text"
          },
          "appname": {
            "type": "keyword"
          },
          "eventtime": {
            "type": "date"
          }
        }
      },
      "uptime": {
        "type": "double"
      },
      "username": {
        "type": "keyword"
      },
      "usersCount": {
        "type": "long"
      }
    }
  }
}

```

}  
}

Data in index as below

"\_source": {  
"sessionid": "3FEBB8F16698434895DC9B2D6E406ED0",  
....  
....  
.....  
"appdata": [  
{  
"accessType": "ag\_app",  
"appname": "first",  
"eventtime": "2019-02-26T16:14:50.275+0530"  
}  
]  
}  
},

I want show this appdata.appname in my Vertical Bar chart. When I selected Terms-\>Field with appdata.appname, Kibana doesnt show any records. How to achieve this???

---

<div class="post-metadata">

**Author:** ![azasypkin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/azasypkin/32/42216_2.png) [@azasypkin](https://discuss.elastic.co/u/azasypkin)\
**Post date:** [February 26, 2019, 11:57am UTC](https://discuss.elastic.co/t/nested-type-in-kibana/169980/2 "2019-02-26T11:57:29Z")

</div>

Hi @RAM_NATHAN,

Unfortunately [Kibana doesn't support aggregation on nested fields](https://www.elastic.co/guide/en/kibana/current/nested-objects.html) yet. You can track the progress in [#1084](https://github.com/elastic/kibana/issues/1084).

Also there is a 3rd-party [KibanaNestedSupportPlugin](https://github.com/ppadovani/KibanaNestedSupportPlugin/) that adds nested field supports for the Kibana. You can check it out.

Best,  
Oleg

---

<div class="post-metadata">

**Author:** ![RAM\_NATHAN](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ram_nathan/32/50393_2.png) [@RAM\_NATHAN](https://discuss.elastic.co/u/RAM_NATHAN)\
**Post date:** [February 28, 2019, 10:28am UTC](https://discuss.elastic.co/t/nested-type-in-kibana/169980/3 "2019-02-28T10:28:45Z")

</div>

Thanks for the reply. Instead of separate plugin, Will it possible to achieve the same with "Include\_In\_Parent"?? I have added the same flag as below

"appdata": {  
"type": "nested",  
"include\_in\_parent": true,  
"properties": {  
"accessType": {  
"type": "text"  
},  
"appname": {  
"type": "keyword"  
},  
"eventtime": {  
"type": "date"  
}  
}

But still Kibana doesnt show any data. Won't this help??

---

<div class="post-metadata">

**Author:** ![RAM\_NATHAN](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ram_nathan/32/50393_2.png) [@RAM\_NATHAN](https://discuss.elastic.co/u/RAM_NATHAN)\
**Post date:** [March 2, 2019, 5:38am UTC](https://discuss.elastic.co/t/nested-type-in-kibana/169980/4 "2019-03-02T05:38:10Z")

</div>

Can you please provide a reply???

---

<div class="post-metadata">

**Author:** ![RAM\_NATHAN](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ram_nathan/32/50393_2.png) [@RAM\_NATHAN](https://discuss.elastic.co/u/RAM_NATHAN)\
**Post date:** [March 4, 2019, 6:45am UTC](https://discuss.elastic.co/t/nested-type-in-kibana/169980/5 "2019-03-04T06:45:57Z")

</div>

Sorry. Please ignore my previous comment. I'm able to achieve with "Include\_in\_parent". I understand that field will be deprecated in future release.  
Other than that does it have any performance issue?? Shouldn't be used for any reason other than deprecation??

---

<div class="post-metadata">

**Author:** ![RAM\_NATHAN](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ram_nathan/32/50393_2.png) [@RAM\_NATHAN](https://discuss.elastic.co/u/RAM_NATHAN)\
**Post date:** [March 8, 2019, 4:51am UTC](https://discuss.elastic.co/t/nested-type-in-kibana/169980/6 "2019-03-08T04:51:59Z")

</div>

Can someone please reply back??

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [March 8, 2019, 8:49am UTC](https://discuss.elastic.co/t/nested-type-in-kibana/169980/7 "2019-03-08T08:49:35Z")

</div>

I believe you can use `copy_to` instead?

---

<div class="post-metadata">

**Author:** ![RAM\_NATHAN](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ram_nathan/32/50393_2.png) [@RAM\_NATHAN](https://discuss.elastic.co/u/RAM_NATHAN)\
**Post date:** [March 8, 2019, 9:10am UTC](https://discuss.elastic.co/t/nested-type-in-kibana/169980/8 "2019-03-08T09:10:44Z")

</div>

Thanks for the reply.. Wont that get deprecated??? . Is it advisable to use copy\_to for nested type in kibana???

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [March 8, 2019, 9:26am UTC](https://discuss.elastic.co/t/nested-type-in-kibana/169980/9 "2019-03-08T09:26:50Z")

</div>

I believe so.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [April 5, 2019, 9:26am UTC](https://discuss.elastic.co/t/nested-type-in-kibana/169980/10 "2019-04-05T09:26:50Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
