Convert from string to integer

Elastic Stack Logstash
1

Hello.
I need to convert data from string to integer.

I use following syntax:

filter {

if [type] == "log1c"
{
csv
{
columns => [
"ReportDate","ReportTime","UserName","ErpMode","Action","ReportName","QueryType","ReportData","Field1","Field2"
]
separator => ";"
}

csv
{
source => "ReportData"
columns => [
"Uid","ReportAction","ReportDuration","DateOfStart","DateOfFinish"
]
separator => "|"
}

mutate
{
convert => { "ReportDuration" => "integer" }
}

}

But in Kibana i see that field ReportDuration still has string type.

How can I convert data from string to integer?

Thanks in advance.

2

Did you delete the old index before updating the config?

3

Hello. I'm newbie in ELK stack, so could you tell ne how i can do it?

4

Ok.
I'm trying to delete old index:

curl -XDELETE 'http://localhost:9200/ReportDuration/'
{"error":{"root_cause":[{"type":"index_not_found_exception","reason":"no such index","resource.type":"index_or_alias","resource.id":"ReportDuration","index":"ReportDuration"}],"type":"index_not_found_exception","reason":"no such index","resource.type":"index_or_alias","resource.id":"ReportDuration","index":"ReportDuration"},"status":4

But I get error message.

Do I implement right action?

5

Solved.

  1. Delete indexes
    curl -XDELETE 'http://localhost:9200/*'

  2. Load filebeat template again
    curl -XPUT 'http://localhost:9200/_template/filebeat' -d@/temp/filebeat.template.json

  3. Setup this template as default in Kibana.