# Column too large for kibana data table display

**URL:** <https://discuss.elastic.co/t/column-too-large-for-kibana-data-table-display/110424>\
**Category:** Kibana\
**Created:** [December 5, 2017, 9:33pm UTC](https://discuss.elastic.co/t/column-too-large-for-kibana-data-table-display/110424 "2017-12-05T21:33:52Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![kyle\_che](https://avatars.discourse-cdn.com/v4/letter/k/ce73a5/32.png) [@kyle\_che](https://discuss.elastic.co/u/kyle_che)\
**Post date:** [December 5, 2017, 9:33pm UTC](https://discuss.elastic.co/t/column-too-large-for-kibana-data-table-display/110424/1 "2017-12-05T21:33:53Z")

</div>

I'm trying to display a message that is about 1420 characters in a kibana data table. Any reason why this will not display or does anyone have a work around? Any way to do a substring? Below is an example message. I have this problem on both 5.6.1 and 6.0.0.

CassandraDaemon.java:228 - Exception in thread Thread[ReadRepairStage:1829,5,main]  
org.apache.cassandra.exceptions.ReadTimeoutException: Operation timed out - received only 2 responses.  
at org.apache.cassandra.service.DataResolver$RepairMergeListener.close(DataResolver.java:209) ~[cassandra-all-3.11.0.1900.jar:3.11.0.1900]  
at org.apache.cassandra.db.partitions.UnfilteredPartitionIterators$2.close(UnfilteredPartitionIterators.java:203) ~[cassandra-all-3.11.0.1900.jar:3.11.0.1900]  
at org.apache.cassandra.db.transform.BaseIterator.close(BaseIterator.java:92) ~[cassandra-all-3.11.0.1900.jar:3.11.0.1900]  
at org.apache.cassandra.service.DataResolver.compareResponses(DataResolver.java:73) ~[cassandra-all-3.11.0.1900.jar:3.11.0.1900]  
at org.apache.cassandra.service.AsyncRepairCallback$1.runMayThrow(AsyncRepairCallback.java:50) ~[cassandra-all-3.11.0.1900.jar:3.11.0.1900]  
at org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) ~[cassandra-all-3.11.0.1900.jar:3.11.0.1900]  
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0\_151]  
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0\_151]  
at org.apache.cassandra.concurrent.NamedThreadFactory.lambda$threadLocalDeallocator$0(NamedThreadFactory.java:81) ~[cassandra-all-3.11.0.1900.jar:3.11.0.1900]  
at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0\_151]

---

<div class="post-metadata">

**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\
**Post date:** [December 6, 2017, 4:18pm UTC](https://discuss.elastic.co/t/column-too-large-for-kibana-data-table-display/110424/2 "2017-12-06T16:18:18Z")

</div>

Hi Kyle,

Can you be more specific about what happens right now in your Data Table visualization? Are you getting an error? Or just blank?

It looks like my long text gets clipped;

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/6/967290f27b55cca4205db156aa02859c5a641d49.png)

Regards,  
Lee

---

<div class="post-metadata">

**Author:** ![kyle\_che](https://avatars.discourse-cdn.com/v4/letter/k/ce73a5/32.png) [@kyle\_che](https://discuss.elastic.co/u/kyle_che)\
**Post date:** [December 6, 2017, 5:02pm UTC](https://discuss.elastic.co/t/column-too-large-for-kibana-data-table-display/110424/3 "2017-12-06T17:02:09Z")

</div>

My text is long I guess or something is preventing it from displaying. if I update the message field to "blah" ... it will display. Here is the error that I'm receiving.

{  
"took": 344,  
"timed\_out": false,  
"\_shards": {  
"total": 30,  
"successful": 30,  
"skipped": 0,  
"failed": 0  
},  
"hits": {  
"total": 6582,  
"max\_score": 0,  
"hits": []  
},  
"aggregations": {  
"2": {  
"buckets": [  
{  
"4": {  
"doc\_count\_error\_upper\_bound": 0,  
"sum\_other\_doc\_count": 0,  
"buckets": [  
{  
"3": {  
"doc\_count\_error\_upper\_bound": 0,  
"sum\_other\_doc\_count": 0,  
"buckets": [  
{  
"5": {  
"doc\_count\_error\_upper\_bound": 0,  
"sum\_other\_doc\_count": 0,  
"buckets": [  
{  
"key": "Validator.java:268 - Failed creating a merkle tree for [repair #533f2ab0-da10-11e7-a12e-1963ae42fa1d on renopushnotification/archive, [(4760223188970746832,4847851359166670513]]], /10.124.154.153 (see log for details)",  
"doc\_count": 1  
}  
]  
},  
"key": "ERROR",  
"doc\_count": 1333  
}  
]  
},  
"key": "b-gp2-cassdb1-5",  
"doc\_count": 1333  
},  
{  
"3": {  
"doc\_count\_error\_upper\_bound": 0,  
"sum\_other\_doc\_count": 0,  
"buckets": [  
{  
"5": {  
"doc\_count\_error\_upper\_bound": 0,  
"sum\_other\_doc\_count": 0,  
"buckets": [  
{  
"key": "Validator.java:268 - Failed creating a merkle tree for [repair #533f2ab0-da10-11e7-a12e-1963ae42fa1d on renopushnotification/archive, [(4760223188970746832,4847851359166670513]]], /10.124.154.153 (see log for details)",  
"doc\_count": 1  
}  
]  
},  
"key": "ERROR",  
"doc\_count": 1415  
}  
]  
},  
"key": "b-gp2-cassdb1-4",  
"doc\_count": 1415  
},  
{  
"3": {  
"doc\_count\_error\_upper\_bound": 0,  
"sum\_other\_doc\_count": 0,  
"buckets": [  
{  
"5": {  
"doc\_count\_error\_upper\_bound": 0,  
"sum\_other\_doc\_count": 0,  
"buckets": [  
{  
"key": "Validator.java:268 - Failed creating a merkle tree for [repair #533f2ab0-da10-11e7-a12e-1963ae42fa1d on renopushnotification/archive, [(4760223188970746832,4847851359166670513]]], /10.124.154.153 (see log for details)",  
"doc\_count": 1  
}  
]  
},  
"key": "ERROR",  
"doc\_count": 1325  
}  
]  
},  
"key": "b-gp2-cassdb1-3",  
"doc\_count": 1325  
},  
{  
"3": {  
"doc\_count\_error\_upper\_bound": 0,  
"sum\_other\_doc\_count": 0,  
"buckets": [  
{  
"5": {  
"doc\_count\_error\_upper\_bound": 0,  
"sum\_other\_doc\_count": 0,  
"buckets": [  
{  
"key": "Validator.java:268 - Failed creating a merkle tree for [repair #533f2ab0-da10-11e7-a12e-1963ae42fa1d on renopushnotification/archive, [(4760223188970746832,4847851359166670513]]], /10.124.154.153 (see log for details)",  
"doc\_count": 1  
}  
]  
},  
"key": "ERROR",  
"doc\_count": 1256  
}  
]  
},  
"key": "b-gp2-cassdb1-2",  
"doc\_count": 1256  
},  
{  
"3": {  
"doc\_count\_error\_upper\_bound": 0,  
"sum\_other\_doc\_count": 0,  
"buckets": [  
{  
"5": {  
"doc\_count\_error\_upper\_bound": 0,  
"sum\_other\_doc\_count": 0,  
"buckets": [  
{  
"key": "Validator.java:268 - Failed creating a merkle tree for [repair #533f2ab0-da10-11e7-a12e-1963ae42fa1d on renopushnotification/archive, [(4760223188970746832,4847851359166670513]]], /10.124.154.153 (see log for details)",  
"doc\_count": 1  
}  
]  
},  
"key": "ERROR",  
"doc\_count": 1253  
}  
]  
},  
"key": "b-gp2-cassdb1-1",  
"doc\_count": 1253  
}  
]  
},  
"key\_as\_string": "2017-12-05T00:00:00.000-07:00",  
"key": 1512457200000,  
"doc\_count": 6582  
}  
]  
}  
},  
"status": 200  
}

---

<div class="post-metadata">

**Author:** ![kyle\_che](https://avatars.discourse-cdn.com/v4/letter/k/ce73a5/32.png) [@kyle\_che](https://discuss.elastic.co/u/kyle_che)\
**Post date:** [December 6, 2017, 5:03pm UTC](https://discuss.elastic.co/t/column-too-large-for-kibana-data-table-display/110424/4 "2017-12-06T17:03:40Z")

</div>

![image001](https://us1.discourse-cdn.com/elastic/original/3X/6/9/69caf3659e5861dec27a011b48652cbb5c7d8813.png)

5 will display but the rest of the results don't because they are a lot longer or contain something that is not allowing it to display.

Example of text not displaying:

CassandraDaemon.java:228 - Exception in thread Thread[ReadRepairStage:1935,5,main]  
org.apache.cassandra.exceptions.ReadTimeoutException: Operation timed out - received only 2 responses.  
at org.apache.cassandra.service.DataResolver$RepairMergeListener.close(DataResolver.java:209) ~[cassandra-all-3.11.0.1900.jar:3.11.0.1900]  
at org.apache.cassandra.db.partitions.UnfilteredPartitionIterators$2.close(UnfilteredPartitionIterators.java:203) ~[cassandra-all-3.11.0.1900.jar:3.11.0.1900]  
at org.apache.cassandra.db.transform.BaseIterator.close(BaseIterator.java:92) ~[cassandra-all-3.11.0.1900.jar:3.11.0.1900]  
at org.apache.cassandra.service.DataResolver.compareResponses(DataResolver.java:73) ~[cassandra-all-3.11.0.1900.jar:3.11.0.1900]  
at org.apache.cassandra.service.AsyncRepairCallback$1.runMayThrow(AsyncRepairCallback.java:50) ~[cassandra-all-3.11.0.1900.jar:3.11.0.1900]  
at org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) ~[cassandra-all-3.11.0.1900.jar:3.11.0.1900]  
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0\_151]  
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0\_151]  
at org.apache.cassandra.concurrent.NamedThreadFactory.lambda$threadLocalDeallocator$0(NamedThreadFactory.java:81) ~[cassandra-all-3.11.0.1900.jar:3.11.0.1900]  
at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0\_151]

---

<div class="post-metadata">

**Author:** ![kyle\_che](https://avatars.discourse-cdn.com/v4/letter/k/ce73a5/32.png) [@kyle\_che](https://discuss.elastic.co/u/kyle_che)\
**Post date:** [December 6, 2017, 6:48pm UTC](https://discuss.elastic.co/t/column-too-large-for-kibana-data-table-display/110424/5 "2017-12-06T18:48:35Z")

</div>

I updated one of the messages and see that at 258 characters it will not display. Below is the example of 257 characters long.

 ![35 AM](https://us1.discourse-cdn.com/elastic/original/3X/f/2/f2dc8296d2c80e07a7ade42fb57f18f4f4eb68dc.png)

---

<div class="post-metadata">

**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\
**Post date:** [December 6, 2017, 6:55pm UTC](https://discuss.elastic.co/t/column-too-large-for-kibana-data-table-display/110424/6 "2017-12-06T18:55:35Z")

</div>

What browser are you using?

Can you please open the browser's console (F12 on Chrome and some other browsers) and see if there are any errors shown there?

Also, can you look at your mapping for this index and see if there's something like this `"ignore_above": 256` in it?

If you go to the Kibana Dev Tools \> Console you can make a request like  
`GET <your index name>/_mapping`

You might see something like this;

```auto
"address_full": {
        "type": "text",
        "fields": {
          "keyword": {
            "type": "keyword",
            "ignore_above": 256
          }
        }
      }

```

Thanks,  
Lee

---

<div class="post-metadata">

**Author:** ![kyle\_che](https://avatars.discourse-cdn.com/v4/letter/k/ce73a5/32.png) [@kyle\_che](https://discuss.elastic.co/u/kyle_che)\
**Post date:** [December 11, 2017, 4:59pm UTC](https://discuss.elastic.co/t/column-too-large-for-kibana-data-table-display/110424/7 "2017-12-11T16:59:09Z")

</div>

> [@LeeDr](#):
>
> ignore\_above

Ended up being the ignore\_above is 256 .. I changed that to 3000 and it now displays the messages.

---

<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:** [January 8, 2018, 4:59pm UTC](https://discuss.elastic.co/t/column-too-large-for-kibana-data-table-display/110424/8 "2018-01-08T16:59:19Z")

</div>

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