compare different values between the same table
Imagine you have a hp vertica database with some created tables with different values inside.
We want to compare and detect in every table the next actions:
- detect the new values registers inserted in a concrete table
- detect and obtain the modified values registers existing in a concrete table
- detect and obtain the deleted values registres that have been deleted in a concrete table
We will dispose a script batch in sh format that it will execute every five minutes and the main goal of this script batch is detect and obtain all the values inserted, modified and deleted from all existing tables of hp vertica.
However, in hp vertica there is not triggers and for this reason anyone kwnows a technical way in hp vertica to codify and develop for obtaining the desired information.