I have my application log files in way that one entry has 'Start Time' field as timestamp (where as 'End Time' as NA) and another entry has 'End Time' field with timestamp('Start Time' field as NA) which have a unique id(transaction id) as common and those are loaded into Elasticsearch using Logstash(by required grok pattern).
Is it possible to combine them based on a common field and show in Data Table by having both Start Time and End Time fields filled?
For example(columns and log entries):
TransactionID | Method | Start Time | End Time
100 | ReadDatabase | Mon Feb 24 16:46:42 IST 2020 | NA
100 | ReadDatabase | NA | Mon Feb 24 16:47:44 IST 2020
I would like to show the data in Data Table by combining both of them based on Transaction Id
TransactionID | Method | Start Time | End Time
100 | ReadDatabase | Mon Feb 24 16:46:42 IST 2020 | Mon Feb 24 16:47:44 IST 2020
Thanks for the links provided. I've gone through all of them and tried to use aggregate filter.
But seems it's working for few log entries and not for few.
Below is the filter configuration I created for logstash to load the log files data using aggregate.
2020-02-24 16:46:44.402 INFO 9780 --- [http-nio-8080-exec-2] c.v.s.SpringBootTestForLogsApplication : For_Request_Dashboard-100|DatabaseUtils|read|venakta.kodapaka|L0418L|Mon Feb 24 16:46:42 IST 2020|NA|NA|0
2020-02-24 16:46:44.402 INFO 9780 --- [http-nio-8080-exec-2] c.v.s.SpringBootTestForLogsApplication : For_Request_Dashboard-100|DatabaseUtils|read|venakta.kodapaka|L0418L|NA|Mon Feb 24 16:46:44 IST 2020|false|2001
Is anything wrong in the configuration? Or is it expected way to behave like that(few times correct/few times not)?
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.