HP Vertica® 6.1.x Documentation
Printing Full Books
Syntax Conventions
New Features
New Features and Changes in HP Vertica 6.1.x
New Features and Changes in HP Vertica 6.1 SP3 (6.1.3)
Improved Performance When a Node Fails
New MC System-Level Charts
Hadoop Connector Supports MapR
New Features and Changes in HP Vertica 6.1 SP2 (6.1.2)
Enterprise Edition and Community Edition License Changes
HP Vertica End User License Agreement (EULA)
R Language Pack Improvements
Management Console Enhancements in 6.1.2
Using MC with the Community Edition
Community Edition Support for an AWS Cluster
New and Modified System Tables in 6.1.2
New Features and Changes in HP Vertica 6.1 SP1 (6.1.1)
Improved Diagnostics Collection
New Configuration Parameters
New SEARCH_PATH User Setting
Changes in the HP Vertica Catalog Directory
Statistics Gathering When Node is Down
MC Database Naming Requirement Changes
Grant/Revoke Privileges on all Objects Within a Schema
Backup and Restore Changes
Query Run-Time Priority Changes
Improved Performance When Inserting Data into Segmented Projections
Improved Performance for COMMIT Operations
COPY FROM VERTICA and EXPORT TO VERTICA Improvements
DROP_PARTITION Updates
New EXPORT_STATISTICS Argument
PURGE_TABLE Behavior Change
ALTER TABLE Updates
New System Table Column Identifiers
Monitoring Real-time Data in Query Plan Paths
New and Modified System Tables in 6.1.1
New Features and Changes in HP Vertica 6.1.0
EXPORT_OBJECTS and EXPORT_CATALOG Changes
Database Designer Improvements
New Hardware Verification Tests
Management Console Enhancements in 6.1.0
HP Vertica 6.1.x AMI on AWS
Privileges Required For Database Operations
Authenticating Users With Ident
New LDAP Client Authentication Options
Reduced Network Latency for Locking and Commits
Storage Location Updates
Storage Location Functions
CREATE TABLE LIKE Statement
New INTERSECT and EXCEPT Clauses for Set Operations
SQL WITH Clause Support
Improved Statistics Collection
Outer Join Improvements for Large Inputs
Analytic Functions Using PARTITION BY Run in Parallel
Subquery DELETE/UPDATE Enhancements
CLEAR_PROFILING Function Change
Improved Performance for the UNION Clause
User Defined Function Binary Compatibility
ADO.NET Connection Pooling
HP Vertica Hadoop Connector Version for Hadoop 2.0/CDH4
New Hadoop Distributed File System Connector
New and Modified System Tables in 6.1.0
Deprecated Functionality
Retired Functionality Table
Concepts Guide
The HP Vertica Approach
HP Vertica Components
Column Store Architecture with FlexStore
Architecture of the HP Vertica Cluster
Data Encoding and Compression
High Availability and Recovery
High Availability Through Projections
Hybrid Storage Model
Logical Schema
Physical Schema
How Projections are Created
Anatomy of a Projection
Projection Concepts
Projection Performance
Projection Segmentation
Projection Naming
Database Setup
Database Connections
The Administration Tools
Management Console
Management Console Architecture
Management Console Security
Management Console Home Page
The Database Designer
K-Safety
Database Security
Data Loading and Modification
Workload Management
SQL Overview
About Query Execution
Transactions
Automatic Rollback
Savepoints
READ COMMITTED Isolation
SERIALIZABLE Isolation
International Languages and Character Sets
Unicode Character Encoding
Locales
String Functions
Character String Literals
Extending HP Vertica
User-Defined SQL Functions
User Defined Extensions and User Defined Functions
Get Started
Installation Guide
Installation Overview and Checklist
About HP Vertica-created Linux Users and their Privileges
Before You Install HP Vertica
Platform Requirements and Recommendations
Configuring Hardware and Installing Linux
Install Linux
Allocate Swap Space
Disable CPU Frequency Scaling
Configure the I/O Scheduler
Prepare Disk Storage Locations
Disk Space Requirements for HP Vertica
Disk Space Requirements for Management Console
Specifying Disk Storage Location During Installation
Specifying Disk Storage Location During Database Creation
Specifying Disk Storage Location on MC
Configuring Disk Usage to Optimize Performance
Using Shared Storage With HP Vertica
Verify sudo and Allow Passwordless SSH Access for dbadmin
Verify pam_limits.so
Update tzdata Package and Set the Default Time Zone
Set the Host Locale (language)
Verify That NTP daemon is Running
Remove nonessential applications
Configuring the Network
Define the Loopback Address
Configure Host Name Resolution
Check Subnet Masks
Disable Firewalls
Optionally Run Spread on Separate Control Network
Provide root SSH Access to the Cluster
Ensure Ports are Available
Ensure That /dev/pts is Mounted
Installing HP Vertica
Installing HP Vertica Using the Command Line
Back Up Existing Databases
Download and Install the HP Vertica Install Package
Run the Install Script
About the install_vertica Script
Installing HP Vertica Silently
Installing HP Vertica on Amazon Web Services (AWS)
Creating an HP Vertica Cluster Using MC
Prepare the Hosts
Create a Private Key File
Use MC's Cluster Installation Wizard
Validate Hosts and Create the Cluster
Create a Database on a Cluster
Installing and Configuring Management Console
Before You Install MC
Installing MC
Configuring MC
After You Install HP Vertica
Install the License Key
Verify Kernel and User Parameters Were Set
Optionally Install vsql Client Application on Non-cluster Hosts
Install the HP Vertica-Ganglia Monitoring Package
Resolve SUSE Spread Configuration Issues
Changing the IP Addresses of an HP Vertica Cluster
Install HP Vertica Documentation
Installing Client Drivers
Extend Your Installation Using HP Vertica Packages
Upgrading HP Vertica
Upgrading HP Vertica to a New Version
Upgrading Your HP Vertica License
Upgrading MC
Uninstalling HP Vertica
Uninstalling HP Vertica
Uninstalling MC
Troubleshooting the HP Vertica Install
Validation Scripts
vcpuperf
vioperf
vnetperf
Enable Port 5433
Enable Secure Shell (SSH) Logins
Increase Free Memory
Increase Maximum Number of Files Open
Increase max_map_count Parameter
Set Up Time Synchronization
Manage Large Grouped ROS Containers
Appendix: Time Zones
Using Time Zones With HP Vertica
Africa
America
Antarctica
Asia
Atlantic
Australia
Etc/GMT
Europe
Indian
Pacific
Getting Started Guide
Getting Started Overview
HP Vertica Virtual Analytics Platform
Installing the Example Database
VMart Example Database
Public Schema
inventory_fact
customer_dimension
date_dimension
employee_dimension
product_dimension
promotion_dimension
shipping_dimension
vendor_dimension
warehouse_dimension
Store Schema
store_orders_fact
store_sales_fact
store_dimension
Online_Sales Schema
online_sales_fact
call_center_dimension
online_page_dimension
VMart Sample Queries
vmart_query_01.sql
vmart_query_02.sql
vmart_query_03.sql
vmart_query_04.sql
vmart_query_05.sql
vmart_query_06.sql
vmart_query_07.sql
vmart_query_08.sql
vmart_query_09.sql
Tutorial: Setting up an Example Database
Step 1: Set Up the Example Environment
Step 2: Create the Example Database
Create the Example Database Using the Administration Tools
Create the Example Database Using Management Console
Step 3: Define the Database Schema
Step 4: Load the Data
Step 5: Create a Comprehensive Design
Step 6: Connect to the Database and Run a Simple Query
Step 7: Test the Optimized Design
Step 8: (Optional) Generate Custom Data Files
Running Simple Queries
Cleanup Procedure
Administration Tools Keystrokes
Notes for Remote Terminal Users
Administrator's Guide
Administration Overview
Configuring the Database
Configuration Procedure
Prepare Disk Storage Locations
Specifying Disk Storage Location During Installation
Configuring Disk Usage to Optimize Performance
Using Shared Storage With HP Vertica
Viewing Database Storage Information
Disk Space Requirements for HP Vertica
Disk Space Requirements for Management Console
Prepare the Logical Schema Script
Prepare Data Files
Prepare Load Scripts
Create an Optional Sample Query Script
Create an Empty Database
Creating a Database Name and Password
Create an Empty Database Using MC
Create a Database Using Administration Tools
Create the Logical Schema
Perform a Partial Data Load
Test the Database
Optimize Query Performance
Complete the Data Load
Test the Optimized Database
Set Up Incremental (Trickle) Loads
Implement Locales for International Data Sets
Specify the Default Locale for the Database
Override the Default Locale for a Session
Best Practices for Working with Locales
Change Transaction Isolation Levels
Implement Security
Configuration Parameters
Configuring HP Vertica Settings Using MC
Configuring HP Vertica at the Command Line
General Parameters
Tuple Mover Parameters
Epoch Management Parameters
Monitoring Parameters
Profiling Parameters
Security Parameters
Internationalization Parameters
Data Collector Parameters
Kerberos Authentication Parameters
Designing a Logical Schema
Using Multiple Schemas
Multiple Schema Examples
Creating Schemas
Specifying Objects in Multiple Schemas
Setting Search Paths
Creating Objects that Span Multiple Schemas
Tables in Schemas
About Base Tables
About Temporary Tables
Using Named Sequences
Creating Sequences
Altering Sequences
Distributed Sequences
Loading Sequences
Dropping Sequences
Implementing Views
Creating Views
Using Views
Designing a Physical Schema
Using Database Designer
Design Types
Comprehensive Design
Query-specific Design
Creating a Comprehensive Design Using Database Designer
Replicated and Segmented Projections
Creating a Query-specific Design Using Database Designer
Deploying Designs
Deploying Designs Using Database Designer
Deploying Designs Manually
Creating Custom Designs
The Design Process
Planning Your Design
Design Requirements
Determining the Number of Projections to Use
Designing for K-Safety
Designing for Segmentation
Design Fundamentals
Writing and Deploying Custom Projections
Anatomy of a Projection
Designing Superprojections
Designing Replicated Projections for K-Safety
Designing Segmented Projections for K-Safety
Projection Design for Merge Operations
Maximizing Projection Performance
Choosing Sort Orders for Low-Cardinality Predicates
Choosing Sort Orders for High-Cardinality Predicates
Prioritizing Column Access Speed
Projection Examples
New K-Safe=2 Database
Adding Node to a Database
Managing Licenses
Understanding HP Vertica Licenses
Installing or Upgrading a License Key
New HP Vertica License Installations
HP Vertica License Renewals or Upgrades
Viewing Your License Status
Calculating the Database Size
Monitoring Database Size for License Compliance
Implementing Security
Implementing Client Authentication
Password Authentication
Profiles
Password Expiration
Account Locking
Password Guidelines
About External Authentication
How to Create Authentication Records
Authentication record format
Authentication Record Formatting Rules
Configuring LDAP Authentication
Configuring Ident Authentication
Example authentication records
How to Modify Authentication Records
Implementing Kerberos Authentication
Configuring authentication through Kerberos and GSS
Implementing SSL
SSL Prerequisites
Generating certifications and keys
Generating Certifications and Keys for MC
Importing a new certificate to MC
Distributing certifications and keys
Configuring SSL
Configuring SSL for ODBC clients
Configuring SSL for JDBC clients
Requiring SSL for client connections
Managing Users and Privileges
About Database Users
Types of database users
DBADMIN user
Object owner
PUBLIC user
Creating a database user
Changing a user's password
Locking/unlocking a user's database access
About MC Users
Creating an MC user
Managing MC users
About Database Privileges
Default privileges for all users
Privileges required for common database operations
Privileges that can be granted on objects
Database privileges
Schema privileges
Table privileges
Projection privileges
View privileges
Sequence privileges
External procedure privileges
User-defined function privileges
Library privileges
Resource pool privileges
Storage location privileges
Role, profile, and user privileges
Metadata privileges
I/O privileges
Comment privileges
Transaction privileges
Session privileges
Tuning privileges
Granting and revoking privileges
About superuser privileges
About schema owner privileges
About object owner privileges
How to grant privileges
How to revoke privileges
Privilege ownership chains
Modifying privileges
Changing a table owner
Changing a sequence owner
Viewing privileges granted on objects
About Database Roles
Types of database roles
DBADMIN role
PSEUDOSUPERUSER role
PUBLIC role
Default roles for database users
Using database roles
Role hierarchy
Creating database roles
Deleting database roles
Granting privileges to roles
Revoking privileges from roles
Granting access to database roles
Revoking access from database roles
Granting administrative access to a role
Revoking administrative access from a role
Enabling roles
Disabling roles
Viewing enabled and available roles
Viewing named roles
Viewing a user's role
About MC Privileges and Roles
MC configuration privileges
SUPER role (mc)
ADMIN role (mc)
IT role (mc)
NONE role (mc)
MC database privileges
ADMIN role (db)
IT role (db)
USER role (db)
Granting database access to MC users
Mapping an MC user to a database user's privileges
Adding multiple MC users to a database
How to find out an MC user's database role
Adding multiple users to MC-managed databases
MC mapping matrix
Using the Administration Tools
Using the Administration Tools Interface
K-Safety Support in Administration Tools
Notes for Remote Terminal Users
Using the Administration Tools Help
Password Authentication
Distributing Changes Made to the Administration Tools Metadata
Administration Tools and Management Console
Administration Tools Reference
Viewing Database Cluster State
Connecting to the Database
Starting the Database
Stopping the Database
Restarting HP Vertica on Host
Configuration Menu Item
Creating a Database
Dropping a Database
Viewing a Database
Setting the Restart Policy
Advanced Tools Menu Options
Rolling Back Database to the Last Good Epoch
Stopping HP Vertica on Host
Killing the HP Vertica Process on Host
Upgrading an Enterprise or Evaluation License Key
Managing Clusters
Using the Administration Tools
Administration Tools Metadata
Writing Administration Tools Scripts
Using Management Console
Connecting to MC
Managing Client Connections on MC
Managing Database Clusters on MC
Create an Empty Database Using MC
Import an Existing Database Into MC
Using MC on an AWS Cluster
Managing MC Settings
Changing MC or Agent Ports
How to Change the Agent Port
How to Change the MC Port
Backing Up MC
Troubleshooting Management Console
Viewing the MC Log
Exporting the User Audit Log
Restarting MC
Resetting MC to Pre-configured State
Avoiding MC Self-Signed Certificate Expiration
Operating the Database
Starting and Stopping the Database
Starting the Database
Stopping the Database
Working with the HP Vertica Index Tool
Running the Reindex Option
Running the CheckCRC Option
Handling CheckCRC Errors
Running the Checksort Option
Viewing Index Tool
Working with Tables
Creating Base Tables
Creating a Table Like Another
Creating Temporary Tables
Creating External Tables
Validating External Tables
External Table Support
Using External Tables
Altering Table Definitions
Exclusive ALTER TABLE clauses
Using consecutive ALTER TABLE commands
Adding table columns
Updating associated table views
Altering table columns
Adding columns with a default derived expression
Changing a column's data type
Adding constraints on columns
Dropping a table column
Moving a table to another schema
Changing a table owner
Changing a sequence owner
Renaming tables
Updating Tables with Records from Other Tables
Dropping and Truncating Tables
About Constraints
Adding Constraints
Primary Key Constraints
Foreign Key Constraints
Unique Constraints
Not NULL Constraints
Dropping Constraints
Enforcing Primary Key and Foreign Key Constraints
Analyzing Constraints (Detecting Constraint Violations)
Fixing Constraint Violations
Reenabling Error Reporting
Working with Table Partitions
Defining partitions
Dropping partitions
Partitioning and segmenting data
Partitioning and data storage
Managing partitions
Partitioning, repartitioning, and reorganizing tables
Auto partitioning
Eliminating Partitions
Moving Partitions
Restoring Archived Partitions
Bulk Loading Data
Checking Data Format Before or After Loading
Performing the Initial Database Load
Using Load Scripts
Using COPY and COPY LOCAL
Transforming Data During Loads
Specifying COPY FROM Options
Choosing a Load Method
Specifying How COPY Loads Data
Interpreting Last Column End of Row Values
Loading UTF-8 Format Data
Loading Native Varchar Data
Loading Binary Data
Loading Fixed-Width Format Data
Ignoring Columns and Fields in the Load File
Loading Data into Pre-join Projections
Using Parallel Load Streams
Using the Parallel Load Library
Checking COPY Metrics
Controlling Load Exceptions and Rejections
Specifying an Exceptions File (EXCEPTIONS)
Specifying a Rejected Data File (REJECTED DATA)
COPY Exception and Rejected Data Files
COPY LOCAL Exception and Rejection Files
Referential Integrity Load Violation
Trickle Loading Data
Using INSERT, UPDATE, and DELETE
WOS Overflow
Copying and Exporting Data
Exporting Data
Importing Data
Using Public and Private IP Networks
Identify the Public Network to HP Vertica
Identify the Database or Node(s) used for Import/Export
Using EXPORT Functions
Exporting the Catalog
Exporting Tables
Exporting Objects
Bulk Deleting and Purging Data
Best Practices for DELETE and UPDATE
Performance Considerations for DELETE and UPDATE Queries
Optimizing DELETEs and UPDATEs for Performance
Purging Deleted Data
Setting a Purge Policy
Manually Purging Data
Managing the Database
Load Balancing
Configuring HP Vertica Nodes
Set Up the Loopback Interface
Disable Address Resolution Protocol (ARP)
Configuring the Directors
Install the HP Vertica IPVS Load Balancer Package
Configure the HP Vertica IPVS Load Balancer
Connecting to the Virtual IP (VIP)
Monitoring Shared Node Connections
Determining Where Connections Are Going
IPVS Troubleshooting Tips
Keepalived Troubleshooting Tips
Managing Nodes
Elastic Cluster
Scaling Factor Defaults
Viewing Scaling Factor Settings
Setting the Scaling Factor
Local Data Segmentation
Enabling and Disabling Local Segmentation
Elastic Cluster Best Practices
Monitoring Elastic Cluster Rebalancing
Adding Nodes
Adding Hosts to a Cluster
Adding Nodes to a Database
Removing Nodes
Lowering the K-Safety Level to Allow for Node Removal
Removing Nodes from a Database
Removing Hosts from a Cluster
Replacing Nodes
Replacing a Node Using the Same Name and IP Address
Replacing a Failed Node Using a Different Name and IP Address
Replacing a Functioning Node Using a Different Name and IP Address
Using the Administration Tools to Replace Nodes
Using the Management Console to Replace Nodes
Rebalancing Data Across Nodes
Rebalancing Data Using the Administration Tools UI
Rebalancing Data Using MC
Rebalancing Data Using SQL Functions
Redistributing Configuration Files to Nodes
Changing the IP Addresses of an HP Vertica Cluster
Stopping and Starting Nodes on MC
Managing Disk Space
Adding Disk Space to a Node
Replacing Failed Disks
Catalog and Data Files
Understanding the Catalog Directory
Reclaiming Disk Space from Deleted Records
Rebuilding a Table
Managing Tuple Mover Operations
Understanding the Tuple Mover
Moveout
Mergeout
Tuning the Tuple Mover
Managing Workload Resources
The Resource Manager
Resource Manager Impact on Query Execution
Resource Pool Architecture
Monitoring Resource Pools and Resource Usage by Queries
User Profiles
Target Memory Determination for Queries in Concurrent Environments
Managing Resources at Query Run Time
Setting Run-Time Priority for the Resource Pool
Changing Run-Time Priority of a Running Query
Restoring Resource Manager Defaults
Best Practices for Managing Workload Resources
Basic Principles for Scalability and Concurrency Tuning
Guidelines for Setting Pool Parameters
Setting a Run-Time Limit for Queries
Using User-defined Pools and User-Profiles for Workload Management
Scenario: Periodic Batch Loads
Scenario: The CEO Query
Scenario: Preventing Run-away Queries
Scenario: Restricting Resource Usage of Ad hoc Query Application
Scenario: Setting a Hard Limit on Concurrency For An Application
Scenario: Handling Mixed Workloads (Batch vs. Interactive)
Scenario: Setting Priorities on Queries Issued by Different Users
Scenario: Continuous Load and Query
Scenario: Prioritizing Short Queries at Run Time
Scenario: Dropping the Runtime Priority of Long Queries
Tuning the Built-in Pools
Scenario: Restricting HP Vertica to Take Only 60% of Memory
Scenario: Tuning for Recovery
Scenario: Tuning for Refresh
Scenario: Tuning Tuple Mover Pool Settings
Reducing Query Run-time
Managing System Resource Usage
Managing Sessions
Managing Load Streams
Working With Storage Locations
Viewing Storage Locations and Policies
Adding Storage Locations
Altering Storage Location Use
Altering Location Labels
Creating Storage Policies
Moving Data Storage Locations
Clearing Storage Policies
Measuring Storage Performance
Setting Storage Performance
Dropping Storage Locations
Retiring Storage Locations
Restoring Retired Storage Locations
Backing Up and Restoring the Database
Understanding VBR Terminology
When to Back up the Database
Backup Directory Structure and Contents
Using Hard File Link Local Backups
Viewing and Removing Backups
Configuring Remote Backup Hosts
Configuring Hard Link Local Backup Hosts
Generating the vbr.py Configuration File
Configuring Required VBR Parameters
Configuring Advanced VBR Parameters
Configuring the Hard Link Local VBR Parameter
Example Backup Configuration File
Creating Full and Incremental Backups
Creating Schema and Table Backups
Creating Hard Link Local Backups
Interrupting the Backup Utility
Restoring Full Database Backups
Restoring Schema and Table Backups
Restoring Hard Link Local Backups
Copying the Database to Another Cluster
Restoring to the Same Cluster
Backup and Restore Utility Reference
VBR Utility Reference
VBR Configuration File Reference
Recovering the Database
Failure Recovery
Restarting HP Vertica on a Host
Restarting the Database
Recovering the Cluster from a Backup
Monitoring Recovery
Exporting a Catalog
Best Practices for Disaster Recovery
Monitoring HP Vertica
Monitoring Log Files
Rotating Log Files
Monitoring Process Status (ps)
Monitoring Linux Resource Usage
Monitoring Disk Space Usage
Monitoring Database Size for License Compliance
Monitoring Shared Node Connections
Monitoring Elastic Cluster Rebalancing
Monitoring Parameters
Monitoring Events
Event logging mechanisms
Event severity types
Event data
Configuring event reporting
Configuring reporting for syslog
Configuring reporting for SNMP
Configuring event trapping for SNMP
Verifying SNMP configuration
Event reporting examples
Using System Tables
Retaining Monitoring Information
Enabling and disabling Data Collector
Viewing current data retention policy
Configuring data retention policies
Working with data collection logs
Monitoring Data Collection components
Querying Data Collector tables
Configuring PROJECTION_REFRESHES History
Monitoring Query Plan Profiles
Monitoring Partition Reorganization
Monitoring Resource Pools and Resource Usage by Queries
Monitoring Recovery
Monitoring HP Vertica Using MC
Viewing MC Home Page
Monitoring Same-name Databases on MC
Monitoring the Database Cluster
Monitoring Cluster Nodes
Monitoring Cluster CPU/Memory
Monitoring Cluster Performance
Monitoring System Resources
Monitoring Query Activity
Monitoring Internal Sessions
Monitoring User Sessions
Monitoring System Memory Usage
Monitoring System Bottlenecks
Monitoring Node Activity
Monitoring MC-managed Database Messages
Searching MC-managed Database Messages
Exporting MC-managed Database Messages and Logs
Monitoring MC User Activity
Monitoring HP Vertica Using Ganglia
Ganglia Architecture
Ganglia Prerequisites
Required Packages for a Ganglia Installation
Installing the HP Vertica Monitoring Package
RHEL5
SuSE SLE 10 and SLE 11
Servers without Internet Access
Configuring Ganglia
Installing Gmond on All Nodes
Configuring Gmetad on the Monitoring Node
Configuring Gmond on All Nodes
About the gmond.conf file
Edit the gmond.conf file
Multicast IP Support
Configuring the Vertica Monitoring Package
Configuring and Starting lighttpd
Configuring Vertica Extension Files
Edit the vertica-dashboard.xml file
Edit the verticadefines.php file [Optional]
Add a cron job
Upgrading the Vertica Monitoring Package
Uninstalling HP Vertica-Ganglia
Analyzing Workloads
Getting Tuning Recommendations Through an API
Getting Tuning Recommendations Through MC
Understanding WLA Triggering Conditions
Collecting Database Statistics
Statistics Used by the Query Optimizer
How Statistics are Collected
How statistics are computed
How statistics are reported
Determining when statistics were last updated
Reacting to stale statistics
Canceling statistics collection
Best practices for statistics collection
Using Diagnostic Tools
Determining Your Version of HP Vertica
Collecting Diagnostics (scrutinize Command)
Diagnostics (scrutinize) syntax
How to run scrutinize
How scrutinize collects/packages diagnostics
How to upload scrutinize results to support
Examples for the scrutinize command
Collecting Diagnostics (diagnostics Command)
Exporting a Catalog
Exporting Profiling Data
Understanding Query Plans
How to Obtain a Query Plan
How to Save a Query Plan
About EXPLAIN output
Viewing Cost and Rows Path
Viewing Statistics Query Plan Output
Viewing Projection Path
Viewing Join Path
Viewing path ID path
Viewing filter path
Viewing the GROUPBY PIPELINED and GROUPBY HASH path
Viewing sort path
Viewing limit path
Viewing data redistribution path
Viewing analytic function path
Viewing merge path
Linking EXPLAIN plan to error messages and profiling information
Profiling Database Performance
How to Determine if Profiling is Enabled
How to Enable Profiling for the Current Session
How to Disable Profiling for the Current Session
How to Enable Profiling for all Sessions
How to Disable Profiling for all Sessions
How to Clear Profiling Data
About Real-time Profiling
How to Profile a Single Statement
How to View Profiling Data
How to View Real-time Profiling Data
Profiling Query Plan Profiles
How to Get Query Plan Status for Small Queries
How to Get Query Plan Status for Large Queries
Improving Readability of QUERY_PLAN_PROFILES Output
Managing Query Profiling Data
Reacting to Suboptimal Query Plans
How to Label Queries for Profiling
About Locales
Locale Specification
Long Form
Short Form
Supported Locales
Locale Restrictions and Workarounds
Loading Representative Data
Appendix: Binary File Formats
Creating Native Binary Format Files
Programmer's Guide
HP Vertica Client Libraries
Client Driver and Server Version Compatibility
Installing the HP Vertica Client Drivers
Driver Prerequisites
ODBC Prerequisites
Microsoft Connectivity Pack/ADO.NET Prerequisites
Python Prerequisites
Perl Prerequisites
PHP Prerequisites
Installing the Client Drivers
Installing Driver Managers Linux and other UNIX-like Platforms
Installing ODBC Drivers on Linux, Solaris, AIX, and HP-UX
Installing the Client RPM on Red Hat and SUSE
Installing JDBC Driver on Linux, Solaris, AIX, and HPUX
Installing ODBC/JDBC Client Drivers and vsql Client on Windows
Installing the Microsoft Connectivity Pack and ADO.NET Driver on Windows
Modifying the Java CLASSPATH
Installing the JDBC Driver on Macintosh OS X
Installing the ODBC Driver on Macintosh OS X
Upgrading the HP Vertica Client Drivers
Using Legacy Drivers
Creating an ODBC Data Source Name (DSN)
Creating an ODBC DSN for Linux, Solaris, AIX, and HP-UX
Testing a DSN Using isql
Creating an ODBC DSN for Windows Clients
Setting Up a DSN
Testing a DSN Using Excel 2007
Editing DSN Entries
Creating an ODBC DSN for Macintosh OS X Clients
DSN Parameters
Setting DSN Parameters
Additional ODBC Driver Configuration Settings
Location of the Additional Driver Settings
Additional Parameter Settings
Programming ODBC Client Applications
ODBC Architecture
ODBC Feature Support
Updating ODBC Client Code from Previous Driver Versions
DSN Parameter Changes
Function Changes
New Additional Driver Information
HP Vertica-specific ODBC Header File
Connecting to HP Vertica
Prompting Windows Users for Missing Connection Parameters
Setting the Locale for ODBC Sessions
AUTOCOMMIT and ODBC Transactions
Retrieving Data through ODBC
Handling NULL Values in ODBC
Loading Data through ODBC
Using a Single Row Insert
Using Prepared Statements
Using Batch Inserts
Tracking Load Status
Error Handling During Batch Loads
Using the COPY Statement
Streaming Data from the Client Using COPY LOCAL
Programming JDBC Client Applications
JDBC Feature Support
Updating JDBC Client Code from Previous Driver Versions
Driver Package and Interface Name Changes
Converting from PGConnection to VerticaConnection
Converting from PGStatement to VerticaStatement
Connection Property Changes
Creating and Configuring a Connection
JDBC Connection Properties
Setting and Getting Connection Property Values
Setting the Locale for JDBC Sessions
Changing the Transaction Isolation Level
Using a Pooling Data Source
JDBC Data Types
HP Vertica Numeric Data Alias Conversion
Using Intervals with JDBC
Executing Queries Through JDBC
Loading Data Through JDBC
Using a Single Row Insert
Batch Inserts Using JDBC Prepared Statements
Loading Batches Directly into ROS
Error Handling During Batch Loads
Identifying Accepted and Rejected Rows
Rolling Back Batch Loads on the Server
Bulk Loading Using the COPY Statement
Streaming Data via JDBC
Using VerticaCopyStream
Using COPY LOCAL with JDBC
Programming ADO.NET Applications
Updating ADO.NET Client Code from Previous Driver Versions
Setting the Locale for ADO.NET Sessions
Connecting to the Database
Using SSL: Installing Certificates on Windows
Opening and Closing the Database Connection (ADO.NET)
ADO.NET Connection Properties
Configuring Log Properties (ADO.Net)
Querying the Database using ADO.NET
Inserting Data (ADO.NET)
Using Parameters
Creating and Rolling Back Transactions
Setting the Transaction Isolation Level
Reading Data (ADO.Net)
Loading Data Through ADO.Net
Using the HP Vertica Data Adapter
Using Batch Inserts and Prepared Statements
Loading Batches Directly into ROS
Streaming Data via ADO.NET
Streaming from the Client via VerticaCopyStream
Using Copy with ADO.NET
Handling Messages (ADO.NET)
Getting Table Metadata (ADO.Net)
ADO.NET Data Types
Microsoft Connectivity Pack
Microsoft Business Intelligence Development Studio (BIDS) plugin and Visual Studio Shell Integration
Microsoft SSAS, SSIS, and SSRS Components
Data Type Limitations in SSIS
Programming Python Client Applications
Configuring the ODBC Run-time Environment on Linux
Querying the Database Using Python
Programming Perl Client Applications
Perl Client Prerequisites
Connecting to HP Vertica Using Perl
Setting ODBC Connection Parameters in Perl
Setting Perl DBI Connection Attributes
Connecting from Perl Without a DSN
Executing Statements Using Perl
Batch Loading Data Using Perl
Using COPY LOCAL to Load Data in Perl
Querying HP Vertica Using Perl
Conversions between Perl and HP Vertica Data Types
Perl Unicode Support
Programming PHP Client Applications
PHP Unicode Support
Querying the Database Using PHP
Using vsql
Installing the vsql Client
vsql Notes for Windows Users
Connecting From the Administration Tools
Connecting from the Command Line
Command Line Options
Connecting From a Non-Cluster Host
Meta-Commands
! [ COMMAND ]
?
a
b
c (or \connect) [ dbname [ username ] ]
C [ STRING ]
cd [ DIR ]
The \d [ PATTERN ] meta-commands
d [ PATTERN ]
df [ PATTERN ]
dj [ PATTERN ]
dn [ PATTERN ]
dp [ PATTERN ]
ds [ PATTERN ]
dS [ PATTERN ]
dt [ PATTERN ]
dT [ PATTERN ]
dtv [ PATTERN ]
du [ PATTERN ]
dv [ PATTERN ]
e \edit [ FILE ]
echo [ STRING ]
f [ string ]
g
H
h \help
i FILE
l
locale
o
p
password [ USER ]
pset NAME [ VALUE ]
q
qecho [ STRING ]
r
s [ FILE ]
set [ NAME [ VALUE [ ... ] ] ]
t
T [ STRING ]
timing
unset [ NAME ]
w [ FILE ]
x
z
Variables
AUTOCOMMIT
DBNAME
ECHO
ECHO_HIDDEN
ENCODING
HISTCONTROL
HISTSIZE
HOST
IGNOREEOF
ON_ERROR_STOP
PORT
PROMPT1 PROMPT2 PROMPT3
QUIET
SINGLELINE
SINGLESTEP
USER
VERBOSITY
VSQL_HOME
Prompting
Command Line Editing
vsql Environment Variables
Locales
Files
Exporting Data Using vsql
Copying Data Using vsql
Output Formatting Examples
Writing Queries
Historical (Snapshot) Queries
Temporary Tables
SQL Queries
Subqueries
Subqueries Used in Search Conditions
Logical Operators AND and OR
In Place of an Expression
Comparison Operators
LIKE Pattern Matching
ANY (SOME) and ALL
EXISTS and NOT EXISTS
IN and NOT IN
Subqueries in the SELECT List
WITH Clauses in SELECT
Noncorrelated and Correlated Subqueries
Flattening FROM Clause Subqueries and Views
Subqueries in UPDATE and DELETE Statements
Subquery Examples
Subquery Restrictions
Joins
The ANSI Join Syntax
Join Conditions vs. Filter Conditions
Inner Joins
Equi-joins and Non Equi-Joins
Natural Joins
Cross Joins
Outer Joins
Range Joins
Pre-join Projections and Join Predicates
Join Notes and Restrictions
Using SQL Analytics
How Analytic Functions Work
Analytic Functions versus Aggregate Functions
The Window OVER() Clause
Window Partitioning
Window Ordering
Window Framing
Windows with a Physical Offset (ROWS)
Windows with a Logical Offset (RANGE)
Reporting Aggregates
Naming Windows
Analytic Query Examples
Calculating a Median Value
Getting Price Differential for Two Stocks
Calculating the Moving Average
Avoiding GROUPBY HASH with Projection Design
Getting Latest bid and ask Results
Event-based Windows
Sessionization with Event-based Windows
Using Time Series Analytics
Gap Filling and Interpolation (GFI)
Constant Interpolation
The TIMESERIES Clause and Aggregates
Linear Interpolation
GFI Examples
When Time Series Data Contains Null Values
Event Series Joins
Sample Schema for Event Series Joins Examples
Writing Event Series Joins
Event Series Pattern Matching
Optimizing Query Performance
First Steps for Improving Query Performance
Optimizing Encoding to Improve Query Performance
Improving the Compression of FLOAT Columns
Using Run Length Encoding (RLE) to Improve Query Performance
Optimizing Projections for Queries with Predicates
Optimizing GROUP BY Queries
Avoiding GROUPBY HASH with Projection Design
Avoiding Resegmentation During GROUP BY Optimization with Projection Design
Optimizing DISTINCT in a SELECT Query List
Optimizing JOIN Queries
Hash Joins vs. Merge Joins
Optimizing for Merge Joins
Using Equality Predicates to Optimize Joins
Specifying INNER and OUTER Tables to Optimize Joins
Avoiding Resegmentation During Joins
Optimizing ORDER BY Queries
Pre-sorting Projections to Optimize ORDER BY Clauses
Optimizing SQL-99 Analytic Functions
Avoiding Single-Node Execution by Avoiding Empty OVER() Clauses
NULL Placement by Analytic Functions
Designing Tables to Minimize Run-Time Sorting of NULL Values in Analytic Functions
Optimizing LIMIT Queries with ROW_NUMBER Predicates
Optimizing INSERT-SELECT Operations
Optimizing INSERT-SELECT Queries for Tables with Pre-join Projections
Optimizing INSERT-SELECT Queries by Matching Sort Orders
Avoiding Resegmentation of INSERT-SELECT Queries
Optimizing DELETE and UPDATE Queries
Performance Considerations for DELETE and UPDATE Queries
Optimizing DELETEs and UPDATEs for Performance
Using External Procedures
Implementing External Procedures
Requirements for External Procedures
Installing External Procedure Executable Files
Creating External Procedures
Executing External Procedures
Dropping External Procedures
Using User-Defined SQL Functions
Creating User-Defined SQL Functions
Altering and Dropping User-Defined SQL Functions
Managing Access to SQL Functions
Viewing Information About User-Defined SQL Functions
Migrating Built-in SQL Functions
Developing and Using User Defined Functions
How UDFs Work
User Defined Extensions and User Defined Functions
Types of UDFs
Fenced Mode
Setting up a UDF Development Environment
The HP Vertica SDK
The HP Vertica SDK API Documentation
Developing a User Defined Function in C++
HP Vertica C++ SDK Data Types
Developing a User Defined Scalar Function
UDSF Requirements
UDSF Class Overview
Subclassing ScalarFunction
Subclassing ScalarFunctionFactory
Setting Null Input and Volatility Behavior
Deploying and Using UDSFs
Developing a User Defined Transform Function in C++
UDTF Requirements
UDTF Class Overview
Subclassing TransformFunction
Subclassing TransformFunctionFactory
Creating Multi-phase UDTFs
Deploying and Using User Defined Transforms
Using PARTITION AUTO to Process Local Data
Developing a user Defined Aggregate Function
User Defined Aggregate Function Requirements
UDAF Class Overview
Subclassing Aggregate Function
Subclassing AggregateFunctionFactory
User Defined Aggregate - Complete Example
Developing a User Defined Analytic Function
User Defined Analytic Function Requirements
UDAnF Class Overview
Subclassing AnalyticFunction
Subclassing AnalyticFunctionFactory
Deploying and Using User Defined Analytic Functions
Developing User Defined Load (UDL) Functions
UDL Source
Subclassing SourceFactory
Subclassing UDSource
UDL Filter
Subclassing FilterFactory
Subclassing UDFilter
UDL Parser
Subclassing ParserFactory
Subclassing UDParser
Compiling Your UDF
Handling Different Numbers and Types of Arguments
User Defined Function Overloading
Creating a Polymorphic UDF
UDF Parameters
Defining the Parameters Your UDF Accepts
Getting Parameter Values in UDFs
Calling UDFs with Parameters
UDF Resource Use
Allocating Resources
Allocating Resources with the SDK Macros
Informing HP Vertica of Resource Requirements
Setting Memory Limits for Fenced Mode UDFs
How Resource Limits Are Enforced
Handling Errors
Handling Cancel Requests
Exiting When the Calling Query Has Been Canceled
Implementing the Cancel Callback Function
UDF Debugging Tips
Developing a User Defined Function in R
User Defined Functions in R Notes and Limitations
Installing/Upgrading the R Language Pack for HP Vertica
R Packages
Using the HP Vertica SDK R Examples
Creating R Functions
Example R Scalar Function
Setting Null Input and Volatility Behavior for R Functions
Using Parameters in R
Polymorphic Functions in R
Logistic Regression in R using GLM
Updating UDF Libraries
UDF Library Compatibility with New Server Versions
Determining if a UDF Signature Has Changed
Deploying A New Version of Your UDF Library
Listing the UDxs Contained in a Library
Using the Hadoop Connector
Prerequisites
How Hadoop and HP Vertica Work Together
Hadoop Connector Features
Hadoop Connector Installation Procedure
Accessing HP Vertica Data from Hadoop
Selecting HP VerticaInputFormat
Setting the Query to Retrieve Data from HP Vertica
Using a Simple Query to Extract Data from HP Vertica
Using a Parameterized Query and Parameter Lists
Using a Query to Retrieve Parameter Values for a Parameterized Query
Writing a Map Class that Processes HP Vertica Data
Writing Data to HP Vertica from Hadoop
Configuring Hadoop to Output to HP Vertica
Defining the Output Table
Writing the Reduce Class
Passing Parameters to the Hadoop Connector at Run Time
Example Hadoop Connector Application
Compiling and Running the Example Application
Using Hadoop Streaming with HP Vertica's Hadoop Connector
Accessing HP Vertica from Pig
Using the Hadoop Distributed File System Connectors
HDFS Connector Requirements
Secure HDFS Connector Requirements
Installing and Configuring Kerberos on Your HP Vertica Cluster
Preparing Keytab Files for the Secure HDFS Connector
Testing Your Hadoop WebHDFS Configuration
Installing the HDFS Connector Package
Loading the HDFS User Defined Source
Loading Data Using the Standard HDFS Connector
Loading Data Using the Secure HDFS Connector
Creating an External Table Based on HDFS Files
HDFS Connector Troubleshooting Tips
Using Informatica PowerCenter
Installing the HP Vertica Plug-in for PowerCenter
Registering the Plug-in's Metadata
Preparing the PowerCenter Client
Copying the Plug-in Library on the Server
Using the HP Vertica Plug-in for PowerCenter
Configuring PowerCenter to Read Data from HP Vertica
Setting PowerCenter's Buffer Size
Resolving a Message Involving a Missing DLL
Appendix: Error Codes
SQLSTATEs and Error Codes
HP Vertica SQLSTATE List
Warning Messages Associated with SQLSTATE 01000
Warning Messages Associated with SQLSTATE 01006
Warning Messages Associated with SQLSTATE 01007
Warning Messages Associated with SQLSTATE 01V01
Error Messages Associated with SQLSTATE 08000
Error Messages Associated with SQLSTATE 08001
Error Messages Associated with SQLSTATE 08003
Error Messages Associated with SQLSTATE 08006
Error Messages Associated with SQLSTATE 08V01
Error Messages Associated with SQLSTATE 0A000
Error Messages Associated with SQLSTATE 0B000
Error Messages Associated with SQLSTATE 0LV01
Error Messages Associated with SQLSTATE 22000
Error Messages Associated with SQLSTATE 22001
Error Messages Associated with SQLSTATE 22003
Error Messages Associated with SQLSTATE 22004
Error Messages Associated with SQLSTATE 22007
Error Messages Associated with SQLSTATE 22008
Error Messages Associated with SQLSTATE 22009
Error Messages Associated with SQLSTATE 2200B
Error Messages Associated with SQLSTATE 2200D
Error Messages Associated with SQLSTATE 22011
Error Messages Associated with SQLSTATE 22012
Error Messages Associated with SQLSTATE 22015
Error Messages Associated with SQLSTATE 22019
Error Messages Associated with SQLSTATE 2201B
Error Messages Associated with SQLSTATE 2201G
Error Messages Associated with SQLSTATE 22021
Error Messages Associated with SQLSTATE 22023
Error Messages Associated with SQLSTATE 22025
Error Messages Associated with SQLSTATE 22906
Error Messages Associated with SQLSTATE 22V02
Error Messages Associated with SQLSTATE 22V03
Error Messages Associated with SQLSTATE 22V04
Error Messages Associated with SQLSTATE 22V0B
Error Messages Associated with SQLSTATE 22V21
Error Messages Associated with SQLSTATE 22V23
Error Messages Associated with SQLSTATE 22V24
Error Messages Associated with SQLSTATE 23502
Error Messages Associated with SQLSTATE 23503
Error Messages Associated with SQLSTATE 23505
Error Messages Associated with SQLSTATE 25V01
Error Messages Associated with SQLSTATE 28000
Error Messages Associated with SQLSTATE 2BV01
Error Messages Associated with SQLSTATE 40V01
Error Messages Associated with SQLSTATE 42501
Error Messages Associated with SQLSTATE 42601
Error Messages Associated with SQLSTATE 42602
Error Messages Associated with SQLSTATE 42611
Error Messages Associated with SQLSTATE 42622
Error Messages Associated with SQLSTATE 42701
Error Messages Associated with SQLSTATE 42702
Error Messages Associated with SQLSTATE 42703
Error Messages Associated with SQLSTATE 42704
Error Messages Associated with SQLSTATE 42710
Error Messages Associated with SQLSTATE 42712
Error Messages Associated with SQLSTATE 42723
Error Messages Associated with SQLSTATE 42725
Error Messages Associated with SQLSTATE 42803
Error Messages Associated with SQLSTATE 42804
Error Messages Associated with SQLSTATE 42809
Error Messages Associated with SQLSTATE 42830
Error Messages Associated with SQLSTATE 42846
Error Messages Associated with SQLSTATE 42883
Error Messages Associated with SQLSTATE 42939
Error Messages Associated with SQLSTATE 42P20
Error Messages Associated with SQLSTATE 42V01
Error Messages Associated with SQLSTATE 42V02
Error Messages Associated with SQLSTATE 42V03
Error Messages Associated with SQLSTATE 42V04
Error Messages Associated with SQLSTATE 42V06
Error Messages Associated with SQLSTATE 42V07
Error Messages Associated with SQLSTATE 42V08
Error Messages Associated with SQLSTATE 42V09
Error Messages Associated with SQLSTATE 42V10
Error Messages Associated with SQLSTATE 42V11
Error Messages Associated with SQLSTATE 42V13
Error Messages Associated with SQLSTATE 42V15
Error Messages Associated with SQLSTATE 42V16
Error Messages Associated with SQLSTATE 42V17
Error Messages Associated with SQLSTATE 42V18
Error Messages Associated with SQLSTATE 42V21
Error Messages Associated with SQLSTATE 42V25
Error Messages Associated with SQLSTATE 42V26
Error Messages Associated with SQLSTATE 53000
Error Messages Associated with SQLSTATE 53100
Error Messages Associated with SQLSTATE 53200
Error Messages Associated with SQLSTATE 54000
Error Messages Associated with SQLSTATE 54001
Error Messages Associated with SQLSTATE 54011
Error Messages Associated with SQLSTATE 54023
Error Messages Associated with SQLSTATE 55000
Error Messages Associated with SQLSTATE 55006
Error Messages Associated with SQLSTATE 55V02
Error Messages Associated with SQLSTATE 55V03
Error Messages Associated with SQLSTATE 55V04
Error Messages Associated with SQLSTATE 57014
Error Messages Associated with SQLSTATE 57V01
Error Messages Associated with SQLSTATE 57V03
Error Messages Associated with SQLSTATE 58030
Error Messages Associated with SQLSTATE 58V01
Error Messages Associated with SQLSTATE V1001
Error Messages Associated with SQLSTATE V1002
Error Messages Associated with SQLSTATE V1003
Error Messages Associated with SQLSTATE V2000
Error Messages Associated with SQLSTATE V2001
Error Messages Associated with SQLSTATE VC001
Error Messages Associated with SQLSTATE VD001
Error Messages Associated with SQLSTATE VP000
Error Messages Associated with SQLSTATE VP001
Error Messages Associated with SQLSTATE VX001
Error Messages Associated with SQLSTATE VX002
Error Messages Associated with SQLSTATE VX003
SQL Reference Manual
SQL Overview
System Limits
SQL Language Elements
Keywords and Reserved Words
Keywords
Reserved Words
Identifiers
Literals
Number-type Literals
String Literals
Character String Literals
Dollar-quoted String Literals
Unicode String Literals
VARBINARY String Literals
Extended String Literals
Date/Time Literals
Time Zone Values
Day of the Week Names
Month Names
Interval Values
interval-literal
interval-qualifier
Operators
Binary Operators
Boolean Operators
Comparison Operators
Data Type Coercion Operators (CAST)
Date/Time Operators
Mathematical Operators
NULL Operators
String Concatenation Operators
Expressions
Aggregate Expressions
CASE Expressions
Column References
Comments
Date/Time Expressions
NULL Value
Numeric Expressions
Predicates
BETWEEN-predicate
Boolean-predicate
column-value-predicate
IN-predicate
INTERPOLATE
join-predicate
LIKE-predicate
NULL-predicate
SQL Data Types
Binary Data Types
Boolean Data Type
Character Data Types
Date/Time Data Types
DATE
DATETIME
INTERVAL
Displaying or omitting interval units in output
Specifying units on input
How the interval-qualifier affects output units
Specifying precision
Casting with intervals
Processing signed intervals
Processing interval-literals without units
Using INTERVALYM for INTERVAL YEAR TO MONTH
Operations with intervals
Fractional seconds in interval units
interval-literal
interval-qualifier
SMALLDATETIME
TIME
TIME AT TIME ZONE
TIMESTAMP
TIMESTAMP AT TIME ZONE
Numeric Data Types
DOUBLE PRECISION (FLOAT)
INTEGER
NUMERIC
Numeric data type overflow
Data Type Coercion
Data Type Coercion Chart
SQL Functions
Aggregate Functions
AVG [Aggregate]
BIT_AND
BIT_OR
BIT_XOR
CORR
COUNT [Aggregate]
COVAR_POP
COVAR_SAMP
MAX [Aggregate]
MIN [Aggregate]
REGR_AVGX
REGR_AVGY
REGR_COUNT
REGR_INTERCEPT
REGR_R2
REGR_SLOPE
REGR_SXX
REGR_SXY
REGR_SYY
STDDEV [Aggregate]
STDDEV_POP [Aggregate]
STDDEV_SAMP [Aggregate]
SUM [Aggregate]
SUM_FLOAT [Aggregate]
VAR_POP [Aggregate]
VAR_SAMP [Aggregate]
VARIANCE [Aggregate]
Analytic Functions
window_partition_clause
window_order_clause
window_frame_clause
named_windows
AVG [Analytic]
CONDITIONAL_CHANGE_EVENT [Analytic]
CONDITIONAL_TRUE_EVENT [Analytic]
COUNT [Analytic]
CUME_DIST [Analytic]
DENSE_RANK [Analytic]
EXPONENTIAL_MOVING_AVERAGE [Analytic]
FIRST_VALUE [Analytic]
LAG [Analytic]
LAST_VALUE [Analytic]
LEAD [Analytic]
MAX [Analytic]
MEDIAN [Analytic]
MIN [Analytic]
NTILE [Analytic]
PERCENT_RANK [Analytic]
PERCENTILE_CONT [Analytic]
PERCENTILE_DISC [Analytic]
RANK [Analytic]
ROW_NUMBER [Analytic]
STDDEV [Analytic]
STDDEV_POP [Analytic]
STDDEV_SAMP [Analytic]
SUM [Analytic]
VAR_POP [Analytic]
VAR_SAMP [Analytic]
VARIANCE [Analytic]
Date/Time Functions
ADD_MONTHS
AGE_IN_MONTHS
AGE_IN_YEARS
CLOCK_TIMESTAMP
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
DATE_PART
DATE
DATE_TRUNC
DATEDIFF
DAY
DAYOFMONTH
DAYOFWEEK
DAYOFWEEK_ISO
DAYOFYEAR
DAYS
EXTRACT
GETDATE
GETUTCDATE
HOUR
ISFINITE
JULIAN_DAY
LAST_DAY
LOCALTIME
LOCALTIMESTAMP
MICROSECOND
MIDNIGHT_SECONDS
MINUTE
MONTH
MONTHS_BETWEEN
NEW_TIME
NEXT_DAY
NOW [Date/Time]
OVERLAPS
QUARTER
ROUND [Date/Time]
SECOND
STATEMENT_TIMESTAMP
SYSDATE
TIME_SLICE
TIMEOFDAY
TIMESTAMPADD
TIMESTAMPDIFF
TIMESTAMP_ROUND
TIMESTAMP_TRUNC
TRANSACTION_TIMESTAMP
TRUNC [Date/Time]
WEEK
WEEK_ISO
YEAR
YEAR_ISO
Formatting Functions
TO_BITSTRING
TO_CHAR
TO_DATE
TO_HEX
TO_TIMESTAMP
TO_TIMESTAMP_TZ
TO_NUMBER
Template Patterns for Date/Time Formatting
Template Pattern Modifiers for Date/Time Formatting
Template Patterns for Numeric Formatting
Geospatial Package SQL Functions
Geospatial SQL Functions
BB_WITHIN
BEARING
CHORD_TO_ARC
DWITHIN
ECEF_CHORD
ECEF_x
ECEF_y
ECEF_z
ISLEFT
KM2MILES
LAT_WITHIN
LL_WITHIN
LLD_WITHIN
LON_WITHIN
MILES2KM
RADIUS_LON
RADIUS_M
RADIUS_N
RADIUS_R
RADIUS_Ra
RADIUS_Rc
RADIUS_Rv
RADIUS_SI
RAYCROSSING
WGS84_a
WGS84_b
WGS84_e2
WGS84_f
WGS84_if
WGS84_r1
IP Conversion Functions
INET_ATON
INET_NTOA
V6_ATON
V6_NTOA
V6_SUBNETA
V6_SUBNETN
V6_TYPE
Mathematical Functions
ABS
ACOS
ASIN
ATAN
ATAN2
CBRT
CEILING (CEIL)
COS
COT
DEGREES
DISTANCE
DISTANCEV
EXP
FLOOR
HASH
LN
LOG
MOD
MODULARHASH
PI
POWER (or POW)
RADIANS
RANDOM
RANDOMINT
ROUND
SIGN
SIN
SQRT
TAN
TRUNC
WIDTH_BUCKET
NULL-handling Functions
COALESCE
IFNULL
ISNULL
NULLIF
NULLIFZERO
NVL
NVL2
ZEROIFNULL
Pattern Matching Functions
EVENT_NAME
MATCH_ID
PATTERN_ID
Regular Expression Functions
ISUTF8
REGEXP_COUNT
REGEXP_INSTR
REGEXP_LIKE
REGEXP_REPLACE
REGEXP_SUBSTR
Sequence Functions
NEXTVAL
CURRVAL
LAST_INSERT_ID
String Functions
ASCII
BIT_LENGTH
BITCOUNT
BITSTRING_TO_BINARY
BTRIM
CHARACTER_LENGTH
CHR
CONCAT
DECODE
GREATEST
GREATESTB
HEX_TO_BINARY
HEX_TO_INTEGER
INET_ATON
INET_NTOA
INITCAP
INITCAPB
INSERT
INSTR
INSTRB
ISUTF8
LEAST
LEASTB
LEFT
LENGTH
LOWER
LOWERB
LPAD
LTRIM
MD5
OCTET_LENGTH
OVERLAY
OVERLAYB
POSITION
POSITIONB
QUOTE_IDENT
QUOTE_LITERAL
REPEAT
REPLACE
RIGHT
RPAD
RTRIM
SPACE
SPLIT_PART
SPLIT_PARTB
STRPOS
STRPOSB
SUBSTR
SUBSTRB
SUBSTRING
TO_BITSTRING
TO_HEX
TRANSLATE
TRIM
UPPER
UPPERB
V6_ATON
V6_NTOA
V6_SUBNETA
V6_SUBNETN
V6_TYPE
System Information Functions
CURRENT_DATABASE
CURRENT_SCHEMA
CURRENT_USER
DBNAME (function)
HAS_TABLE_PRIVILEGE
SESSION_USER
USER
USERNAME
VERSION
Timeseries Functions
TS_FIRST_VALUE
TS_LAST_VALUE
URI Encode/Decode Functions
URI_PERCENT_DECODE
URI_PERCENT_ENCODE
HP Vertica Meta-functions
Alphabetical List of HP Vertica Meta-functions
ADD_LOCATION
ADVANCE_EPOCH
ALTER_LOCATION_USE
ALTER_LOCATION_LABEL
ANALYZE_CONSTRAINTS
ANALYZE_HISTOGRAM
ANALYZE_STATISTICS
ANALYZE_WORKLOAD
AUDIT
AUDIT_LICENSE_SIZE
AUDIT_LICENSE_TERM
CANCEL_REBALANCE_CLUSTER
CANCEL_REFRESH
CHANGE_CURRENT_STATEMENT_RUNTIME_PRIORITY
CHANGE_RUNTIME_PRIORITY
CLEAR_CACHES
CLEAR_DATA_COLLECTOR
CLEAR_PROFILING
CLEAR_PROJECTION_REFRESHES
CLEAR_RESOURCE_REJECTIONS
CLEAR_OBJECT_STORAGE_POLICY
CLOSE_SESSION
CLOSE_ALL_SESSIONS
CURRENT_SCHEMA
DATA_COLLECTOR_HELP
DISABLE_DUPLICATE_KEY_ERROR
DISABLE_ELASTIC_CLUSTER
DISABLE_LOCAL_SEGMENTS
DISABLE_PROFILING
DISPLAY_LICENSE
DO_TM_TASK
DROP_LOCATION
DROP_PARTITION
DROP_STATISTICS
DUMP_CATALOG
DUMP_LOCKTABLE
DUMP_PARTITION_KEYS
DUMP_PROJECTION_PARTITION_KEYS
DUMP_TABLE_PARTITION_KEYS
ENABLE_ELASTIC_CLUSTER
ENABLE_LOCAL_SEGMENTS
ENABLE_PROFILING
EVALUATE_DELETE_PERFORMANCE
EXPORT_CATALOG
EXPORT_OBJECTS
EXPORT_STATISTICS
EXPORT_TABLES
FLUSH_DATA_COLLECTOR
GET_AHM_EPOCH
GET_AHM_TIME
GET_COMPLIANCE_STATUS
GET_AUDIT_TIME
GET_CURRENT_EPOCH
GET_DATA_COLLECTOR_POLICY
GET_LAST_GOOD_EPOCH
GET_NUM_ACCEPTED_ROWS
GET_NUM_REJECTED_ROWS
GET_PROJECTION_STATUS
GET_PROJECTIONS, GET_TABLE_PROJECTIONS
HAS_ROLE
IMPORT_STATISTICS
INTERRUPT_STATEMENT
INSTALL_LICENSE
LAST_INSERT_ID
MAKE_AHM_NOW
MARK_DESIGN_KSAFE
MEASURE_LOCATION_PERFORMANCE
MERGE_PARTITIONS
MOVE_PARTITIONS_TO_TABLE
PARTITION_PROJECTION
PARTITION_TABLE
PURGE
PURGE_PARTITION
PURGE_PROJECTION
PURGE_TABLE
REBALANCE_CLUSTER
REENABLE_DUPLICATE_KEY_ERROR
REFRESH
RESTORE_LOCATION
RETIRE_LOCATION
SET_AHM_EPOCH
SET_AHM_TIME
SET_AUDIT_TIME
SET_DATA_COLLECTOR_POLICY
SET_LOCATION_PERFORMANCE
SET_LOGLEVEL
SET_SCALING_FACTOR
SET_OBJECT_STORAGE_POLICY
SHUTDOWN
SLEEP
START_REBALANCE_CLUSTER
START_REFRESH
Catalog Management Functions
DUMP_CATALOG
EXPORT_CATALOG
EXPORT_OBJECTS
INSTALL_LICENSE
MARK_DESIGN_KSAFE
Cluster Scaling Functions
CANCEL_REBALANCE_CLUSTER
DISABLE_ELASTIC_CLUSTER
DISABLE_LOCAL_SEGMENTS
ENABLE_ELASTIC_CLUSTER
ENABLE_LOCAL_SEGMENTS
REBALANCE_CLUSTER
SET_SCALING_FACTOR
START_REBALANCE_CLUSTER
Constraint Management Functions
ANALYZE_CONSTRAINTS
DISABLE_DUPLICATE_KEY_ERROR
LAST_INSERT_ID
REENABLE_DUPLICATE_KEY_ERROR
Data Collector Functions
CLEAR_DATA_COLLECTOR
DATA_COLLECTOR_HELP
FLUSH_DATA_COLLECTOR
GET_DATA_COLLECTOR_POLICY
SET_DATA_COLLECTOR_POLICY
Database Management Functions
CLEAR_RESOURCE_REJECTIONS
DUMP_LOCKTABLE
DUMP_PARTITION_KEYS
EXPORT_TABLES
HAS_ROLE
SET_CONFIG_PARAMETER
SET_LOGLEVEL
SHUTDOWN
Epoch Management Functions
ADVANCE_EPOCH
GET_AHM_EPOCH
GET_AHM_TIME
GET_CURRENT_EPOCH
GET_LAST_GOOD_EPOCH
MAKE_AHM_NOW
SET_AHM_EPOCH
SET_AHM_TIME
License Management Functions
AUDIT
AUDIT_LICENSE_SIZE
AUDIT_LICENSE_TERM
GET_AUDIT_TIME
GET_COMPLIANCE_STATUS
DISPLAY_LICENSE
SET_AUDIT_TIME
Partition Management Functions
DROP_PARTITION
DUMP_PROJECTION_PARTITION_KEYS
DUMP_TABLE_PARTITION_KEYS
MERGE_PARTITIONS
MOVE_PARTITIONS_TO_TABLE
PARTITION_PROJECTION
PARTITION_TABLE
PURGE_PARTITION
Profiling Functions
CLEAR_PROFILING
DISABLE_PROFILING
ENABLE_PROFILING
Projection Management Functions
EVALUATE_DELETE_PERFORMANCE
GET_PROJECTION_STATUS
GET_PROJECTIONS, GET_TABLE_PROJECTIONS
REFRESH
START_REFRESH
Purge Functions
PURGE
PURGE_PARTITION
PURGE_PROJECTION
PURGE_TABLE
Session Management Functions
CANCEL_REFRESH
CLOSE_ALL_SESSIONS
CLOSE_SESSION
GET_NUM_ACCEPTED_ROWS
GET_NUM_REJECTED_ROWS
INTERRUPT_STATEMENT
Statistic Management Functions
ANALYZE_HISTOGRAM
ANALYZE_STATISTICS
DROP_STATISTICS
EXPORT_STATISTICS
IMPORT_STATISTICS
Storage Management Functions
ADD_LOCATION
ALTER_LOCATION_USE
ALTER_LOCATION_LABEL
CLEAR_OBJECT_STORAGE_POLICY
DROP_LOCATION
MEASURE_LOCATION_PERFORMANCE
RESTORE_LOCATION
RETIRE_LOCATION
SET_LOCATION_PERFORMANCE
SET_OBJECT_STORAGE_POLICY
Tuple Mover Functions
DO_TM_TASK
Workload Management Functions
ANALYZE_WORKLOAD
CHANGE_CURRENT_STATEMENT_RUNTIME_PRIORITY
CHANGE_RUNTIME_PRIORITY
CLEAR_CACHES
SLEEP
SQL Statements
ALTER FUNCTION
ALTER LIBRARY
ALTER PROJECTION RENAME
ALTER NETWORK INTERFACE
ALTER PROFILE
ALTER PROFILE RENAME
ALTER RESOURCE POOL
ALTER ROLE RENAME
ALTER SCHEMA
ALTER SEQUENCE
ALTER SUBNET
ALTER TABLE
table-constraint
ALTER USER
ALTER VIEW
BEGIN
COMMENT ON Statements
COMMENT ON COLUMN
COMMENT ON CONSTRAINT
COMMENT ON FUNCTION
COMMENT ON LIBRARY
COMMENT ON NODE
COMMENT ON PROJECTION
COMMENT ON SCHEMA
COMMENT ON SEQUENCE
COMMENT ON TABLE
COMMENT ON TRANSFORM FUNCTION
COMMENT ON VIEW
COMMIT
CONNECT
COPY
Parameters
COPY Option Summary
Notes
Examples
See Also
COPY LOCAL
COPY FROM VERTICA
CREATE EXTERNAL TABLE AS COPY
CREATE FUNCTION Statements
CREATE AGGREGATE FUNCTION
CREATE ANALYTIC FUNCTION
CREATE FILTER
CREATE FUNCTION (SQL Functions)
CREATE FUNCTION (UDF)
CREATE PARSER
CREATE SOURCE
CREATE TRANSFORM FUNCTION
CREATE LIBRARY
CREATE NETWORK INTERFACE
CREATE PROCEDURE
CREATE PROFILE
CREATE PROJECTION
encoding-type
hash-segmentation-clause
range-segmentation-clause
CREATE RESOURCE POOL
Built-in Pools
Built-in Pool Configuration
CREATE ROLE
CREATE SCHEMA
CREATE SEQUENCE
CREATE SUBNET
CREATE TABLE
column-definition (table)
column-name-list (table)
column-constraint
table-constraint
hash-segmentation-clause (table)
range-segmentation-clause (table)
CREATE TEMPORARY TABLE
column-definition (temp table)
column-name-list (temp table)
hash-segmentation-clause (temp table)
range-segmentation-clause (temp table)
CREATE USER
CREATE VIEW
DELETE
DISCONNECT
DROP AGGREGATE FUNCTION
DROP FUNCTION
DROP SOURCE
DROP FILTER
DROP PARSER
DROP LIBRARY
DROP NETWORK INTERFACE
DROP PROCEDURE
DROP PROFILE
DROP PROJECTION
DROP RESOURCE POOL
DROP ROLE
DROP SCHEMA
DROP SEQUENCE
DROP SUBNET
DROP TABLE
DROP TRANSFORM FUNCTION
DROP USER
DROP VIEW
END
EXPLAIN
EXPORT TO VERTICA
GRANT Statements
GRANT (Database)
GRANT (Procedure)
GRANT (Resource Pool)
GRANT (Role)
GRANT (Schema)
GRANT (Sequence)
GRANT (Storage Location)
GRANT (Table)
GRANT (User Defined Extension)
GRANT (View)
INSERT
MERGE
PROFILE
RELEASE SAVEPOINT
REVOKE Statements
REVOKE (Database)
REVOKE (Procedure)
REVOKE (Resource Pool)
REVOKE (Role)
REVOKE (Schema)
REVOKE (Sequence)
REVOKE (Storage Location)
REVOKE (Table)
REVOKE (User Defined Extension)
REVOKE (View)
ROLLBACK
SAVEPOINT
ROLLBACK TO SAVEPOINT
SELECT
EXCEPT Clause
FROM Clause
table-reference
table-primary
joined-table
GROUP BY Clause
HAVING Clause
INTERSECT Clause
INTO Clause
LIMIT Clause
MATCH Clause
MINUS Clause
OFFSET Clause
ORDER BY Clause
TIMESERIES Clause
UNION Clause
WHERE Clause
WINDOW Clause
WITH Clause
SET DATESTYLE
SET ESCAPE_STRING_WARNING
SET INTERVALSTYLE
SET LOCALE
SET ROLE
SET SEARCH_PATH
SET SESSION AUTOCOMMIT
SET SESSION CHARACTERISTICS
SET SESSION MEMORYCAP
SET SESSION RESOURCE_POOL
SET SESSION RUNTIMECAP
SET SESSION TEMPSPACECAP
SET STANDARD_CONFORMING_STRINGS
SET TIME ZONE
Time Zone Names for Setting TIME ZONE
SHOW
START TRANSACTION
TRUNCATE TABLE
UPDATE
HP Vertica System Tables
V_CATALOG Schema
ALL_TABLES
COLUMNS
COMMENTS
CONSTRAINT_COLUMNS
DATABASES
DUAL
ELASTIC_CLUSTER
EPOCHS
FOREIGN_KEYS
GRANTS
LICENSE_AUDITS
NODES
ODBC_COLUMNS
PASSWORDS
PRIMARY_KEYS
PROFILE_PARAMETERS
PROFILES
PROJECTION_CHECKPOINT_EPOCHS
PROJECTION_COLUMNS
PROJECTION_DELETE_CONCERNS
PROJECTIONS
RESOURCE_POOL_DEFAULTS
RESOURCE_POOLS
ROLES
SCHEMATA
SEQUENCES
STORAGE_LOCATIONS
SYSTEM_COLUMNS
SYSTEM_TABLES
TABLE_CONSTRAINTS
TABLES
TYPES
USER_AUDITS
USER_FUNCTIONS
USER_PROCEDURES
USERS
VIEW_COLUMNS
VIEWS
V_MONITOR Schema
ACTIVE_EVENTS
COLUMN_STORAGE
CONFIGURATION_CHANGES
CONFIGURATION_PARAMETERS
CPU_USAGE
CRITICAL_HOSTS
CRITICAL_NODES
CURRENT_SESSION
DATA_COLLECTOR
DATABASE_BACKUPS
DATABASE_CONNECTIONS
DATABASE_SNAPSHOTS
DELETE_VECTORS
DEPLOY_STATUS
DESIGN_STATUS
DISK_RESOURCE_REJECTIONS
DISK_STORAGE
ERROR_MESSAGES
EVENT_CONFIGURATIONS
EXECUTION_ENGINE_PROFILES
HOST_RESOURCES
IO_USAGE
LOAD_STREAMS
LOCK_USAGE
LOCKS
LOGIN_FAILURES
MEMORY_USAGE
MONITORING_EVENTS
NETWORK_INTERFACES
NETWORK_USAGE
NODE_RESOURCES
NODE_STATES
PARTITION_REORGANIZE_ERRORS
PARTITION_STATUS
PARTITIONS
PROCESS_SIGNALS
PROJECTION_RECOVERIES
PROJECTION_REFRESHES
PROJECTION_STORAGE
PROJECTION_USAGE
QUERY_EVENTS
QUERY_METRICS
QUERY_PLAN_PROFILES
QUERY_PROFILES
QUERY_REQUESTS
REBALANCE_PROJECTION_STATUS
REBALANCE_TABLE_STATUS
RECOVERY_STATUS
RESOURCE_ACQUISITIONS
RESOURCE_POOL_STATUS
RESOURCE_QUEUES
RESOURCE_REJECTION_DETAILS
RESOURCE_REJECTIONS
RESOURCE_USAGE
SESSION_PROFILES
SESSIONS
STORAGE_CONTAINERS
STORAGE_POLICIES
STORAGE_TIERS
STORAGE_USAGE
STRATA
STRATA_STRUCTURES
SYSTEM
SYSTEM_RESOURCE_USAGE
SYSTEM_SERVICES
SYSTEM_SESSIONS
TRANSACTIONS
TUNING_RECOMMENDATIONS
TUPLE_MOVER_OPERATIONS
UDX_FENCED_PROCESSES
USER_LIBRARIES
USER_LIBRARY_MANIFEST
USER_SESSIONS
WOS_CONTAINER_STORAGE
Appendix: Compatibility with Other RDBMS
Data Type Mappings Between Vertica and Oracle
Using HP Vertica on Amazon Web Services
About Using HP Vertica on Amazon Web Services (AWS)
Important Notes on this Release of HP Vertica on AWS
Understanding the AWS Procedure Components
About the HP Vertica 6.1.x Instance Sizing
Installing and Running HP Vertica on AWS: The Detailed Procedure
Creating a Placement Group
Creating a Key Pair
Creating a Virtual Private Cloud (VPC)
Creating and Assigning an Internet Gateway
Creating a Security Group
Adding Rules to a Security Group
Configuring and Launching an Instance
Assigning an Elastic IP
Connecting to an Instance
Forming a Cluster
After Your Cluster is Up and Running
Using Management Console (MC) on AWS
Adding Nodes to a Running AWS Cluster
Launching New Instances to Add to an Existing Cluster
Including the New Instances as Nodes in Your Existing Cluster
Re-Balancing Data
Removing Nodes from a Running AWS Cluster
Preparing to Remove a Node
Removing Hosts from the Database
Removing Nodes from the Cluster
Stopping the AWS Instances (Optional)
Migrating to HP Vertica 6.1.x on AWS
Upgrading from a 6.1 AMI on AWS
Preparing to Upgrade Your AMI
Upgrading Your AMI
Troubleshooting: Checking Open Ports Manually
Using the netcat (nc) Utility
Appendix: Installing and Running HP Vertica on AWS: QuickStart
Best Practices for HP Vertica OEM Customers
Part 1: Developing and Testing the HP Vertica Database to Work with a Customer Application
Running HP Vertica on Multiple Nodes
Installing the HP Vertica Database
Identifying Typical Queries
Loading Representative Data
Optimizing the Database with Database Designer
What Does Database Designer Do?
Results of Running Database Designer
Exporting the Optimized Database
Managing Database Resources
Configuring CPU Resources
Pinning HP Vertica Processes to Certain CPUs
Setting Run-Time Priorities for Resource Pools
Configuring Memory Resources
Dropping Partitions Due to Space Constraints
Loading Data into the Database
How Loading Works
WOS and ROS
Loading Data from a File
Loading Data from Your Application
Parallel Load Streams
Trickle Loading
Monitoring Load Operations
PROJECTION_STORAGE
PARTITIONS
Delete and Update Operations
How HP Vertica Deletes and Updates Data
Buffering Deletes and Updates
Monitoring Deletes and Updates
Purging Deleted Data
Part 2: Packaging the HP Vertica Database with Your Application
Installing HP Vertica at the Command Line
Creating the Database
Configuring the Database
Starting the Database
start_db Option
restart_db Option
Connecting to the Database
Backing Up the Database
Glossary
Access rank
ACID
Administration host
Administration Tools
Agent
AHM
Anchor table
Ancient History Mark
ATM
Authentication
Authorization
Automatic Tuple Mover
Base name
Blade server
Bit
Bitstring
Byte
Buddy projection
Bulk loading
C-Store
Cardinality
Case-folded
Catalog
Catalog path
Checkpoint
Cluster
Comprehensive design
Compression
Connection
Cost
Critical node
CSV
Current epoch
Data Collector
Data path
Data warehouse
Database
Database administrator
Database Designer
Database superuser
DBA
DDL
DELTAVAL (delta encoding)
Derived column
Design
Deterministic
Dialog
Dimension table
Dirty read
DML
Dynamic SQL
EOF
Encoding
Epoch
Epoch map
Equality predicate
ETL
Executor node
Expression
External procedure
Event series
Fact table
FIFO
Foreign key
Flattening (subqueries and views)
Full backup
GENERAL pool
Grid computing
Grouped ROS
Hash function
Hash segmentation
Heuristics
Hexadecimal
Histogram
Historical data
Historical query
Host
Hot backup
ICU
ISO Week-Year
Illegitimate
Immutable (invariant) functions
Incremental backup
Initiator node
Instance
Interpolation
JDBC
K-Safety
Last epoch
Last Good Epoch
LGE
Locale
Logical schema
Location label
LZO
Man-in-the-middle attack
Management Console
MC Super (superuser administrator)
MC-managed database
Manual recovery
Materialized view
Mergeout
Meta-functions
Metadata
Moveout
Multi-homed
NaN
Nibble
Node
Node definition
Nondeterministic
Non-repeatable read
NUL
NULL
Octal
Octet
ODBC
OID
OLAP
OLTP
Out-of-date
Path (quality plan)
Partition key
Partitioning
Phantom read
Physical schema
Physical schema design
Pinned projection
Pre-join projection
Predicate
Primary column
Primary key
Projection
Projection set
Purge
Query cluster level
Query optimizer
Query-specific design
Query-specific projection
RDBMS
RLE (Run Length Encoding)
RM
Range segmentation
Recovery
Referential integrity
Refresh
Replication
Replay attack
Resegmentation
Resource pool
Resource Manager
Role
Rollback
ROS (Read Optimized Store)
ROS container
RPM
Safe
SAN
Salt
Savepoint
Schema
Secure Shell
Seed
Segmentation
Select list
Session
Site
Snapshot isolation
Snowflake schema
Spread
Sort-merge join
Source (table)
SQL
SSH
Stable functions
Star schema
Standalone resource pool
Storage location
Storage policy
Strict
Superprojection
Superuser
TM
Table
Target (table)
Temp location
Temp space
Transaction
Tuple
Tuple Mover
UDF
UDP
User-Defined SQL Function
UTC
UTF-8
Unary operator
Up to date
Up-to-date
User agent
View
Volatile functions
Volatility
vsql
WLA
Webhook
Window (analytic)
Workload Analyzer
Workload management
WOS (Write Optimized Store)
Software Acknowledgments
Copyright Notice
apache-commons-configuration
apache-commons-dbcp
apache-commons-filepload
apache-commons-io
apache-derby
apache-tablibs
ASMJIT
asm.asm
asm.asm-commons
asm.asm-tree
apache-tablibs 1.1.2
avalon.framework.avalon.framework
Boost
bottle
bzip2
com.googlecode.json-simple.json-simple
commons-collections.commons-collections
commons-dbcp
commons-fileupload
commons-io
commons-logging.commons-logging
curl_fopen.c
Daemonize
derby
derbyclient
derbynet
Ganglia Open Source License
httpclient
httpcore
httpmime
ICU (International Components for Unicode) License - ICU 1.8.1 and later
javax.el.el-api
javax.inject
javax.transaction.jta
openlp-maxent
Jetty
jquery
jquery-selectmenu
jquery-sparklines
Keepalived HP Vertica IPVS (IP Virtual Server) Load Balancer
libcsv
libthttpclient-java
libthttpcore-java
libhttpmime-java
Lighttpd Open Source License
log4j.log4j
logkit.logkit
Lpsolve
Lpsolveapi
MersenneTwister.h
MIT Kerberos
Msgpack
net.sf.json
oauth
oauth2
Open LDAP
Open SSL
org.apache.geronimo.specs.geronimo-annotation_1.0_spec
org.apache.geronimo.specs.geronimo-jta_1.1_spec
org.apache.ibatis.ibatis-sqlmap
org.aspectj.aspectjrt
org.aspectj.aspectjweaver
org.codehaus.jackson.jackson-core-asl
org.codehaus.jackson.jackson-mapper-asl
org.eclipse.jdt.core.compiler.ecj
org.glassfish.web.jstl-impl
org.quartz-scheduler.quartz
orion-ssh2
paramiko
paste
PCRE LICENCE
Perl Artistic License
Pexpect
php License
PostgreSQL
protobuf
pybonjour
pyopenssl
pynsymp
Python
Python Dialog
quartz
R
r-cran-rcpp
rinside
RRDTool Open Source License
Rsync
setuptools
signpost-commonshttp4
Sign
signpost-commonshttp 4 1.2.1.1
SLF4J-simple
spring-ldap
Spring MVC
springframework-tx 3.0.5
SNMP
standard
Tecla Command-line Editing
WebOb
WebWare
xerces
zlib
Copyright Notice
Index