User Defined Extensions to the Vertica Analytic Database
HTML C++ C Makefile Python SQLPL Other
Latest commit d065f52 Jul 31, 2015 @aseering aseering Fix heat_map_image prototype to match return type
The "output_rows" parameter could modify the set of returned rows.  Make the logic for this in getPrototype() match the logic in getReturnType().
Permalink
Failed to load latest commit information.
avro_parser Fix the dependencies in the Avro parser's tparty makefile so that it … Dec 7, 2013
compatlib_functions Update READMEs to have correct installation instructions for each pac… Jul 5, 2013
email_package More README tweaks Dec 6, 2013
encryption_package Update READMEs to have correct installation instructions for each pac… Jul 5, 2013
geocode_package Update READMEs to have correct installation instructions for each pac… Jul 5, 2013
heatmap_package Fix heat_map_image prototype to match return type Jul 31, 2015
license Update license info Jun 14, 2012
odbc_loader_package Update READMEs to have correct installation instructions for each pac… Jul 5, 2013
sentiment_analysis Fix dependencies in the sentiment_analysis Makefile Dec 7, 2013
shell_load_package Update READMEs to have correct installation instructions for each pac… Jul 5, 2013
shell_package Update READMEs to have correct installation instructions for each pac… Jul 5, 2013
sms_package Update READMEs to have correct installation instructions for each pac… Jul 5, 2013
strings_package Some performance tweaks to the string functions Feb 26, 2014
tagcloud_package Update READMEs to have correct installation instructions for each pac… Jul 5, 2013
template_package Update template package to reflect new format Nov 22, 2011
tools installer scripts Nov 7, 2011
web_package Update READMEs to have correct installation instructions for each pac… Jul 5, 2013
xml_package Update READMEs to have correct installation instructions for each pac… Jul 5, 2013
.gitignore fixed makefile to properly remove third-party object files Nov 13, 2011
LICENSE.txt Update license info Jun 14, 2012
README.txt Add description of shell_load_package to the README Jun 22, 2012

README.txt

Vertica Extension Packages
Copyright 2011 Vertica, an HP Company

This repository contains extension code (UDx) code to extend the
processing capabilities of the Vertica Analytic Database. 

You need the Vertica SDK to compile these programs and you need the
Vertica Analytic Database to run them.

All code is provided under the license found in LICENSE.txt

IMPORTANT: If you wish to contribute anything to this repository, in
order for us to accept your pull request you MUST sign and send a copy
of the appropriate Contributor License Agreement to Vertica
(contribs@vertica.com):

license/PersonalCLA.pdf: If you are contributing for yourself
license/CorporateCLA.pdf: If you are contributing on behalf of your company

*******************
Submission guidelines:
*******************

Any submission to this repository should contain:

1) A few sentences describing what your function does, written in
English.

2) The complete source code and build commands to build your
function. Ideally you would add your function to one of the existing
packages (listed below), or you can create your own package using the
contents of template_package as a guide.

3) REQUIRED: SQL example/tests showing your function in action. This
script should have sample input, and sample queries that demonstrate
how to use your function. The examples should be placed in
package_dir/examples


*******************
Current packages
*******************

string_functions: 
  Description: string manipulation functions
  Examples: EditDistance, StringTokenizer

web_functions
  Description: web log analysis functions
  Examples: ApacheParser, URIExtractor

compatlib_functions: 
  Description: Oracle compatibility functions (such as CONNECT_BY, TRANSPOSE)

encryption_package: 
  Description: Field level encryption functions

shell_load_package:
  Description: Have COPY fetch data by running commands rather than opening files

template_package: 
  Description: template for new packages

tools:
  scripts to create and install packages (in process)
  Example: ./install_package -p <pkg_name>

*******************
Future packages that need their build system cleaned up
*******************

hive_functions: 
  Description: Partial implementation of UDTs that are shipped with apache Hiv
  Examples: get_json_object, xpathint, etc.
  https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF
  Status: significant usefulness