I have some problems to read CSV and convert the values as float in Array
My Demo Dataset:
215900;216100;216300;216430;
216750;216950;217230;217500;
217780;217930;218100;218250;
My logstash Config:
input {
file {
path => "csvfile.csv"
start_position => "beginning"
sincedb_path => "/dev/null"
}
}
filter {
mutate {
convert => { "message" => "float" }
}
mutate {
split => { "message" => ";" }
}
}
output {
elasticsearch {
hosts => ["http://10.14.100.100:9200","http://10.14.100.101:9200","http://10.14.100.103:9200"]
index => "myindex"
}
stdout {}
}
My Output in ES is:
{
...
"hits" : [
{
"_index" : "myindex",
"_type" : "_doc",
"_id" : "wOcTfsdfssJ8PBIntss",
"_score" : 1.0,
"_source" : {
"message" : [
"222780",
"222930",
"223050",
"223180",
"223330",
...
I would like to have the array as float without quotes, like:
{
...
"hits" : [
{
"_index" : "myindex",
"_type" : "_doc",
"_id" : "wOcTfsdfssJ8PBIntss",
"_score" : 1.0,
"_source" : {
"message" : [
222780.0,
222930.0,
223050.0,
223180.0,
223330.0,
...
Where ist the issue in my configuration?
Thanks