I have 2 logs like below :
2018-11-20 04:41:23,873.873 - MainThread - 49102 - INFO views - endTime - 2018-11-20 04:41:23.870460 reqId - id
2018-11-20 04:41:23,863.863 - MainThread - 49102 - INFO views - reqID - id , startTime - 2018-11-20 09:41:23.234
From first statement I need reqId and endTime.
From second statement I need reqId and startTime.
I need to join both the results and retrieve startTime and endTime for each reqId and calculte the time taken.
Can someone please help me to form a query to join the results.
... View more