• Stars
    star
    119
  • Rank 281,499 (Top 6 %)
  • Language
    HTML
  • License
    Other
  • Created over 12 years ago
  • Updated over 1 year ago

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

User Defined Extensions (UDX) to the Vertica Analytic Database
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
([email protected]):

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
  
bandpass package:
  Bandpass filters implemented as Python UDxes.

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

More Repositories

1

vertica-python

Official native Python client for the Vertica Analytics Database.
Python
373
star
2

VerticaPy

VerticaPy is a Python library that exposes sci-kit like functionality to conduct data science projects on data stored in Vertica, thus taking advantage Vertica’s speed and built-in analytics and machine learning capabilities.
Python
211
star
3

DistributedR

R
163
star
4

ddR

Standard API for Distributed Data Structures in R
R
117
star
5

vertica-sql-go

Official native Go client for the Vertica Analytics Database.
Go
59
star
6

Graph-Analytics----Triangle-Counting

Use Big data tools such as Vertica, Hadoop and PIG to count triangles in a graph. Experimentally compare their performance.
Java
49
star
7

Vertica-Hadoop-Connector

Vertica Hadoop Connector
Java
38
star
8

vertica-kubernetes

Operator, container and Helm chart to deploy Vertica in Kubernetes
Go
38
star
9

awesome-vertica

A curated list of awesome Vertica libraries, tools and resources
27
star
10

Machine-Learning-Examples

Vertica Machine Learning examples and example data.
Python
24
star
11

dbt-vertica

Official dbt adapter for Vertica
Python
23
star
12

vertica.dplyr

R
22
star
13

dblink

A Vertica User Defined Transform function to interact with other databases via ODBC
C++
20
star
14

spark-connector

This component acts as a bridge between Spark and Vertica, allowing the user to either retrieve data from Vertica for processing in Spark, or store processed data from Spark into Vertica.
Scala
18
star
15

VerticaPyLab

Use Docker to install a simple demo Vertica.
Jupyter Notebook
14
star
16

vertica-containers

Docker containers for building and testing Vertica extensions
Shell
14
star
17

vertica-grafana-datasource-.2.0

This project defines the official Vertica datasource plugin for Grafana.
JavaScript
12
star
18

UDx-Examples

Vertica User Defined Extension (UDx) examples.
C++
12
star
19

ODBC-Loader

C++
11
star
20

PSTL

Parallel Streaming Transformation Loader
Java
10
star
21

vertica-prometheus-exporter

Official open source Vertica Prometheus Exporter
Go
7
star
22

r-dataconnector

Distributed Data Connector R package
C++
7
star
23

Vertica-Geospatial

Vertica-Geospatial Examples
HTML
7
star
24

Social-Media-Connector

Java
5
star
25

client-application-examples

Examples of how to write a client application to connect to vertica
C++
4
star
26

Vertica-AMI-Packer-Templates

Packer templates and provision scripts for creating Vertica AMIs
Shell
4
star
27

aws-lambda-vertica-loader

Automatic HP Vertica Database Loader for AWS S3
JavaScript
4
star
28

hackathon

A getting started kit for Hackathons using Vertica!
Python
4
star
29

vertica-grafana-datasource

Official Vertica datasource plugin for Grafana.
TypeScript
3
star
30

grafana-dashboards

Dashboards that can be imported into Grafana that use the Prometheus metrics Vertica exports
Python
2
star
31

vertica.github.io

Vertica Open Source
HTML
2
star
32

FlexTable

HPE Vertica Flex Table source code of VMap APIs and parsers
C++
2
star
33

vertica-sqlalchemy-dialect

Official Vertica SQLAlchemy dialect to connect Vertica and SQLAlchemy applications.
Python
2
star
34

charts

1
star
35

vertica-airbyte

Python
1
star
36

DistributedR-demos

CSS
1
star
37

data2ddl

command line tool guessing a table's matching CREATE TABLE statement with optimal data types from a CSV file
C
1
star
38

integrators-guide

A community repo for users that integrate with Vertica with provisioning, monitoring, management, storage, clients, loaders, and other tools.
SCSS
1
star
39

vertica-testenv

Docker-based testing environment for Vertica.
Shell
1
star
40

vertica-highcharts

Python
1
star