Hi
I have same AUD_UPDT_TMSTP column in my table HDR and DTL table and I am configuring my data input using select * from both tables' queries like ( HDR.* DTL.* ).
[dbmon-tail://abc/db-cgw]
index = db-cgw-restricted
output.format = kv
output.timestamp = 0
output.timestamp.column = AUD_UPDT_TMSTP
query = SELECT HDR.* ,DTLS.* FROM CGW.MPM_HDR HDR RIGHT OUTER JOIN CGW.MPM_DTLS DTLS ON HDR.HDR_SKEY = DTLS.HDR_SKEY Where {{ HDR.$rising_column$ > ?}}
sourcetype = cgw-mpm-prod
disabled = 0
tail.rising.column = AUD_UPDT_TMSTP
table = db-mpm-prod
Question 1: Column from which table (HDR or DTL) will be used in rising column?
Question 2: How can we specify that rising column of DTL should be used instead of HDR?
thank you
... View more