Vertica doesn't have the fucntion procedure, trigger?
Vertica hasn't had any stored procedure. You can define the SQL expressions as the functions.https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/ExtendingVertica/UDF-SQLFunctions/UsingUser-DefinedSQLFunctions.htm
If you need to implement any business logic on Vertica, please consider to define the User-Defined Extentions.https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/ExtendingVertica/UsingUserDefinedExtensions.htm
Please consider you have the option to run that logic outside Vertica nodes as well.