Introduce data with more lenght than 255 characters in Data Table

[pablixelastic]

Hi!

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!!

[flash1293 (Joe Reuter)]

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.

[pablixelastic]

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!

[flash1293 (Joe Reuter)]

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

[pablixelastic]

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:

PUT NAME_OF_THE_INDEX
{
"mappings": {
"properties": {
"THE_COLUMN_WE_HAVE_WITH_MORE_THAN_255_CHARACTERS": {
"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.

[flash1293 (Joe Reuter)]

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