Hi guys,
A part of my project wants me to compare data b/w 2 tables, if comparison is false then store the missing value in different table.
Table A
=======================================================
|timestamp |IPAddress |Value |
=======================================================
|123456789 |192.168.5.2 |2 |
|123456788 |192.168.5.3 |4 |
|123456787 |192.168.5.4 |6 |
|123456786 |192.168.5.5 |8 |
=======================================================
Table B
=======================================================
|timestamp |IPAddress |Value |
========================================================
|123456789 |192.168.5.2 |2 |
|123456788 |192.168.5.3 |4 |
=======================================================
Now if I compare these tables, the 2 missing IPs in table A needs to be saved in Table C.
I need to do these by Kapacitor. Or if you have any better suggestion then it will be great.