I am gone a read a csv formated file which has more then 50 field,
by default I want to assign a value "UNKNOWN" to any blank field. how do I easily do it ?
on smaller files I have done
if ![var1] { mutate {update......
but for this long if there is a way to do it for all.
Those would be the names of the columns in the CSV file, that is, the set of fields that you want to set to unknown if they are not present in the CSV. I should have mentioned that you will want to set skip_empty_columns on the csv filter so that the fields do not get created if they are empty.
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.