Emna1
(Linda)
April 28, 2020, 2:06pm
1
Hi, Please i need to calculate différence of time between two rows in my file
My csv file it looks like this
ent_sort , Date , car
enter, 2020-04-28 05:04:02 , c1
sortie , 2020-04-28 10:04:02 , c1
enter , 2020-04-28 05:04:02 , c3
sortie , 2020-04-28 10:04:02 , c2
enter , 2020-04-28 05:04:02 , c2
sortie , 2020-04-28 12:04:02 , c3
Blockquote
So i want calculate for c1 time différence and for c2 .....please any help?
Badger
April 28, 2020, 4:45pm
2
Use an aggregate filter (see example 5) or an elapsed filter.
Make sure to set pipeline.workers to 1 and disable java_execution .
Emna1
(Linda)
April 29, 2020, 8:00am
3
Hi, i try elapsed filter and i add this two line in logstash.yml
Blockquote
elapsed {
start_tag => "taskStarted"
end_tag => "taskEnded"
add_tag => ["time_elapsed"]
}
Blockquote
pipeline.workers: 1
pipeline.java_execution: false
Blockquote
but i have no result the time différence not exist
Badger
April 29, 2020, 1:13pm
4
How did you add the taskStarted and taskEnded tags to the events? Something like this?...
if [ent_sort] == "sortie" { mutate { add_tag => [ "taskEnded" ] } }
Badger
April 29, 2020, 2:14pm
6
That's checking the value of two different fields.
system
(system)
Closed
May 27, 2020, 4:54pm
9
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.