There are no reviews yet. Be the first to send feedback to the community and the maintainers!
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
vertica-python
Official native Python client for the Vertica Analytics Database.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.DistributedR
ddR
Standard API for Distributed Data Structures in Rvertica-sql-go
Official native Go client for the Vertica Analytics Database.Graph-Analytics----Triangle-Counting
Use Big data tools such as Vertica, Hadoop and PIG to count triangles in a graph. Experimentally compare their performance.vertica-kubernetes
Operator, container and Helm chart to deploy Vertica in KubernetesVertica-Hadoop-Connector
Vertica Hadoop Connectorawesome-vertica
A curated list of awesome Vertica libraries, tools and resourcesdbt-vertica
Official dbt adapter for VerticaMachine-Learning-Examples
Vertica Machine Learning examples and example data.vertica.dplyr
dblink
A Vertica User Defined Transform function to interact with other databases via ODBCspark-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.VerticaPyLab
Use Docker to install a simple demo Vertica.vertica-containers
Docker containers for building and testing Vertica extensionsUDx-Examples
Vertica User Defined Extension (UDx) examples.vertica-nodejs
Official native node.js client for the Vertica Analytics Database.vertica-grafana-datasource-.2.0
This project defines the official Vertica datasource plugin for Grafana.ODBC-Loader
PSTL
Parallel Streaming Transformation Loadervertica-prometheus-exporter
Official open source Vertica Prometheus Exporterr-dataconnector
Distributed Data Connector R packageVertica-Geospatial
Vertica-Geospatial ExamplesSocial-Media-Connector
client-application-examples
Examples of how to write a client application to connect to verticaVertica-AMI-Packer-Templates
Packer templates and provision scripts for creating Vertica AMIsaws-lambda-vertica-loader
Automatic HP Vertica Database Loader for AWS S3hackathon
A getting started kit for Hackathons using Vertica!vertica-grafana-datasource
Official Vertica datasource plugin for Grafana.grafana-dashboards
Dashboards that can be imported into Grafana that use the Prometheus metrics Vertica exportsvertica.github.io
Vertica Open SourceFlexTable
HPE Vertica Flex Table source code of VMap APIs and parsersvertica-sqlalchemy-dialect
Official Vertica SQLAlchemy dialect to connect Vertica and SQLAlchemy applications.vcluster
Go library to administer a vertica clustercharts
vertica-airbyte
DistributedR-demos
data2ddl
command line tool guessing a table's matching CREATE TABLE statement with optimal data types from a CSV fileintegrators-guide
A community repo for users that integrate with Vertica with provisioning, monitoring, management, storage, clients, loaders, and other tools.vertica-testenv
Docker-based testing environment for Vertica.vertica-highcharts
Love Open Source and this site? Check out how you can help us