I am having two index( index A and index B). Here I need to measure response time of topup of prepaid or postpaid number with help of transaction ID. From index A I can filter where the transaction is prepaid or postpaid,index A contains(customer ID, Type(Prepaid or Postpaid). In indexB we have two logs one is request log and other is response log. With help of customer ID from Index A I need to find the transaction ID from Request log since customer ID is not available in response log. Once we get the transaction ID, we need to substract the time stamp (Response log time- Request log time). Index A. Log pattern---> _timestamp, customerID,type Index B----> contains request and response log. Request log pattern---> timestamp, transactionID, customer ID Response log pattern--->timestamp, transactionID,status. Method to measure --> From index A we need to get customerID and then go to index B to find out the transaction ID from Request log. With help of transactionID need to subtract the timestamp between response and request log from index B Please help us how we can proceed,in SPL query.
... View more