vertica/Vertica-Extension-Packages — pull request #17 by aseering (2012-06-22 23:44:28+00:00)
Title: shell_load_package -- UDL shell extension

Adds a UDSource that forks a command and reads and outputs data from that command's stdout.

Adds a UDFilter that forks a command, pipes incoming source data to the command's stdin, and reads and outputs data from the command's stdout.

These take the functionality that you get by piping a string of shell scripts into vsql's "COPY ... FROM STDIN;", and pull that functionality directly into the server. Better performance; better parallelism; simpler to use for people who just want to run a SQL query. Also, works with external tables.