# Kibana not returning records when aggregating on long string values

**URL:** <https://discuss.elastic.co/t/kibana-not-returning-records-when-aggregating-on-long-string-values/99199>\
**Category:** Kibana\
**Created:** [September 2, 2017, 6:23pm UTC](https://discuss.elastic.co/t/kibana-not-returning-records-when-aggregating-on-long-string-values/99199 "2017-09-02T18:23:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shantanu\_Deshmukh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/shantanu_deshmukh/32/19885_2.png) [@Shantanu\_Deshmukh](https://discuss.elastic.co/u/Shantanu_Deshmukh)\
**Post date:** [September 2, 2017, 6:23pm UTC](https://discuss.elastic.co/t/kibana-not-returning-records-when-aggregating-on-long-string-values/99199/1 "2017-09-02T18:23:03Z")

</div>

I have an index which contains columns like event-type, description etc. event-type field has event types like LOG, ERROR, INFO etc. I am trying to create a data table in Kibana which includes description column too. When event-type is ERROR Kibana doesn't return any record.

The pattern I observed was that in case of ERROR description field contained a very long string like whole error message along with exception stack trace. When description string was smaller record would be returned. Is there any such behaviour with Elasticsearch. What do I need to do in order to be able to pull out even these records?

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [September 4, 2017, 5:42pm UTC](https://discuss.elastic.co/t/kibana-not-returning-records-when-aggregating-on-long-string-values/99199/2 "2017-09-04T17:42:11Z")

</div>

As far as I know there isn't any open issue regarding large string values in Kibana.  
Can you give me more details so that I try to reproduce the issue?  
What version of Kibana are you using? Where are you trying to view the records: Discover page, a Visualization, etc?

---

<div class="post-metadata">

**Author:** ![Shantanu\_Deshmukh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/shantanu_deshmukh/32/19885_2.png) [@Shantanu\_Deshmukh](https://discuss.elastic.co/u/Shantanu_Deshmukh)\
**Post date:** [September 4, 2017, 5:48pm UTC](https://discuss.elastic.co/t/kibana-not-returning-records-when-aggregating-on-long-string-values/99199/3 "2017-09-04T17:48:17Z")

</div>

Yes surely. Below are the details

Kibana version: 5.1.2  
ES version: 5.1.2  
I checking this data on a data table visualisation. I checked in Kibana response window there's no error from ES.

I will attach some screenshots tomorrow for further reference.  
Thanks a lot for responding 🙂

---

<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:** [October 2, 2017, 5:48pm UTC](https://discuss.elastic.co/t/kibana-not-returning-records-when-aggregating-on-long-string-values/99199/4 "2017-10-02T17:48:50Z")

</div>

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