Introduce data with more lenght than 255 characters in Data Table


Is there any solution to watch data with more than 255 characters from MySQL in a Data Table placed inside a dashboard of Kibana?
I have this response:


Can someone help me with this?

Thank you very much!!

The issue is your mapping - the default keyword fields have ignore_above set to 255. You can set them to much larger values to be able to use the values in aggregations.

Hi flash!

I tried to change that value from Dev Tools but it didn't work for me.
Do you know if i have to stablish that value in my config file?

Thank you for your time!

Can you be more specific what you tried and what happened?

It's ok, i just solved now, i just wanted to create a data table with a column that have questions with more than 255 characters.
What i have done is creating a new index and specify there the ignore_above field to 5000 like in this example:

"mappings": {
"properties": {
"type": "keyword",
"ignore_above": 5000

And then via logstash, send the data to our NAME_OF_THE_INDEX

I hope that anyone with the same issue just find here the solution!

Have a good day.

Right, you need to create a separate index, then move your data over using the reindex API

1 Like

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