On Kibana Discover, this whole JSON object is stored as message in a string. Is it possible to only extract and store field4, field5, and field7?
I've tried the decode_json_fields processor, but it seems to extract the entire JSON object and all its fields, and this "explosion" of data caused the data size to exceed some limit and the message was not sent to ES instead.
There are probably more than 30 fields int this object.
I can try the drop_fields, do you know if I drop, say, field3b, will it drop all its children (field4 to field7), so I don't have to specify each field?
Ohhh I was thinking you meant 100s of fields.... so I am a bit confused by this statement (I guess you have some other mapping issues / many fields already)
Anyways yes when you drop the parent field it should drop all the children...
Give it a try, you can also do this with an ingest pipeline in Elasticsearch so the logic is centralized.
Since you want just field4, field5 and field7, you could use a rename field on them so you would rename _tmp.field3.field3a.field3b.field4 to field4 for example.
Then after the renames you would remove the entire _tmp field.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.