Is there any event based operations in Vertica?
Posted: Thu Feb 07, 2013 7:14 am
Hi,
We have TRIGGERS in Oracle to handle the event based operations, Is there anything like that in Vertica?
I read somewhere that Vertica doesnt have a Programming Language capablities like PL/SQL... in this case how can we achieve Trigger functionality here.
Lets say i have a scenario that i am Inserting records through an ETL tool and i have to generate a Sequence number on the fly from Database...?
how can i achieve this?
looking for valuable inputs.
Thanks,
Jagadeesh.
We have TRIGGERS in Oracle to handle the event based operations, Is there anything like that in Vertica?
I read somewhere that Vertica doesnt have a Programming Language capablities like PL/SQL... in this case how can we achieve Trigger functionality here.
Lets say i have a scenario that i am Inserting records through an ETL tool and i have to generate a Sequence number on the fly from Database...?
how can i achieve this?
looking for valuable inputs.
Thanks,
Jagadeesh.