External procedures

An external procedure is a script or executable program on a host in your database cluster that you can call from within Vertica.

Enterprise Mode only

An external procedure is a script or executable program on a host in your database cluster that you can call from within Vertica. External procedures cannot communicate back to Vertica.

To implement an external procedure:

  1. Create an external procedure executable file. See Requirements for external procedures.

  2. Enable the set-user-ID(SUID), user execute, and group execute attributes for the file. Either the file must be readable by the dbadmin or the file owner's password must be given with the Administration tools install_procedure command.

  3. Install the external procedure executable file.

  4. Create the external procedure in Vertica.

After a procedure is created in Vertica, you can execute or drop it, but you cannot alter it.

In this section