Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
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.
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
I think you asked the same question in other topic. Check it
Vertica is not a transactional DB and it hasnt triggers and other stuff