Hi,
I am trying to add type for my data table columns but it doesnt seem to work.
filter {
if [type] == "statistics" {
csv {
separator => ","
columns => ["Queue","closed successful","closed unsuccessful","merged","new","open","Sum"]
convert => { "closed successful" => "integer" "closed unsuccessful" => "integer" "merged" => "integer" "new" => "integer" "open" => "integer" "Sum" => "integer" }
}
}
}
Here is the mapping result
"logstash-2018.04.17": {
"mappings": {
"doc": {
"Sum.keyword": {
"full_name": "Sum.keyword",
"mapping": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"Sum": {
"full_name": "Sum",
"mapping": {
"Sum": {
"type": "text",
"norms": false,
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
}
}
}
}
}
}
}