Index

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

-c command --command command

-d dbname --dbname dbname

-e --echo-queries

-f filename --file filename

-F separator --field-separator separator

-h hostname --host hostname

-o filename --output filename

-P assignment --pset assignment

-p port --port port

-R separator --record-separator separator

-S --single-line

-s --single-step

-t --tuples-only

-T table_options --table-attr table_options

-U username --username username

-v assignment --set assignment --variable assignment

-X, --no-vsqlrc

\ unset [ name ]

\c (or \connect) [ dbname [ username ] ]

\cd [ directory ]

\d \dj \dn \dp \dt \du

\e \edit [ filename ]

\echo text [ ... ]

\encoding [ encoding ]

\g [ { filename | |command } ]

\h \help [ command ]

\o filename \o | command

\pset parameter [ value ]

\qecho text [ ... ]

\s [ filename ]

\set [ name [ value [ ... ] ] ]

\T table_options

\w { filename | |command }

About the Documentation

AccountType_Dimension

Adding Custom Projections

Adding Primary Key and Foreign Key Constraints

Administration Host

Administration Tools

Administration Tools Errors

Administration Tools Reference

Administration Tools Usable on any Node

Advanced Storage Control

After You Install

Aggregate Expressions

Aggregate function

Aggregate Functions

Allocate Swap Space

ALTER PROJECTION

ALTER TABLE

Prepare the Logical Schema Script

ANALYZE_STATISTICS

Anchor Table

Projection Segmentation

Snowflake Schema

Ancient History Mark

ANSI SQL 92

Using the Transaction Model

Appendix: Time Zones

Arithmetic operators

AT

EPOCH

TIME

Automatic Replication of Unsegmented Projections

AVG

AVG

SELECT

Avoiding WOS Overflow

Back Up Existing Databases

Backing Up the Database

Backslash

COPY

Loading Character Data

Typographical Conventions

Before You Install

BETWEEN-predicate

Boolean Operators

Boolean-predicate

Buddy Projection

Bulk loading

Loading and Modifying Data

Test a Partial Data Load

Call_Termination_Dimension

Cannot find IP address for host...

Cannot shut down while users are connected

CASE Expressions

Catalog

Catalog

Dumping

Using Diagnostic Tools

CHARACTER (CHAR)

CHARACTER VARYING (VARCHAR)

CHARACTER_LENGTH

Check Subnet Masks

Cleanup Procedure

Clickstream Example Database

ClickStream_Fact

clickstream_query_01.sql

clickstream_query_02.sql

clickstream_query_03.sql

clickstream_query_04.sql

clickstream_query_05.sql

CLIENT_ENCODING

Clock skew detected

CLOSE_ALL_SESSIONS

Colored bold text

Column Definition Changed to NOT NULL

Column References

Column Store Architecture

column-constraint

column-definition

column-value-predicate

Command Line Options

Command-Line Editing

Comparison Operators

Complete the Data Load

Compression

Data Encoding and Compression

Configuration Problems

Configuration Procedure

Configure Hostname Resolution

Configuring the Database

Connect to Database

Connecting From a Non-Cluster Host

Connecting From the Administration Tools

Connecting From the Command Line

Connecting to a Database

Connection Problems

Construct a Hardware Platform

COPY

COPY

Loading and Modifying Data

Prepare Sample Data Files

Using Load Scripts

Copyright Notice

could not connect to database

could not connect to server: connection refused

Could not login with SSH

Could not open configuration file

COUNT

COUNT

SELECT

Create Database

Create Database Fails

Create New Database Design

CREATE PROJECTION

CREATE PROJECTION

CREATE PROJECTION Hangs

CREATE TABLE

Prepare the Logical Schema Script

CREATE TEMPORARY TABLE

Create the Database

Create the Logical Schema

Create the Physical Schema

Creating a Connection

Creating a Connection

Creating Tables

Credit History Example Database

CreditCard_Dimension

CreditHistory_Fact

credithistory_query_01.sql

credithistory_query_02.sql

credithistory_query_03.sql

credithistory_query_04.sql

credithistory_query_05.sql

Ctrl-C Distorts Query Result Set Output

CURRENT_DATABASE

CURRENT_TIMESTAMP

Customer_Details_Dimension

Customer_Dimension

Customer_Dimension

Data Disk Spontaneously Remounts

Data Encoding and Compression

Data Type Coercion Operators (CAST)

Data Warehouse Schema Types

Database ... did not appear to stop...

Database Administrator

Database Designer

Database Designer

Database Designer Dialog

Database Designer Errors

Database did not start cleanly on initiator node!

Database Parameters

Database startup successful, but it may be incomplete

Database Superuser

Date/Time Constants

Date/Time Expressions

Date/Time Field Modifiers

Date/Time Functions

Date/Time Operators

Date_Dimension

Day of the Week Names

DBA Guide (Advanced)

DEFAULT

INSERT

Define the Loopback Address

Defining Custom Projections

DELETE

DELETE

Loading and Modifying Data

DELIMITER

COPY

Loading Character Data

DELTAVAL (Delta Encoding)

DEPRECATED syntax

Design Requirements

Determining the Version Number

Diagnostics Utility

Dimension Table

Dimension Table

Snowflake Schema

Dimensional Modeling

DIRECT

COPY

Loading and Modifying Data

Disk Space Management

DISPLAY_LICENSE

Documentation Notes

DOUBLE PRECISION (FLOAT)

DROP PROJECTION

DROP PROJECTION

DUMP_CATALOG

Using Diagnostic Tools

DUMP_LOCKTABLE

CREATE PROJECTION Hangs

Enable Port 5433

Enable Secure Shell (SSH) Logins

ENCODING

CREATE PROJECTION

ENCODING

Environment variable

Epoch

Epoch

SELECT

Equipment_Dimension

Error detected during node verification

Error Handling and Error Codes

Error starting database, no nodes are up

Example Databases

Exchange_Dimension

Executing a Query

Executing a Query

expanded

\ x

\pset parameter [ value ]

Extended Uptime

Fact Table

Snowflake Schema

Failed Dependencies

Failure Recovery

Failure Recovery

Feature_Dimension

Firewall Configuration

Formatting Functions

Functional Dependency

Generating Custom Data Files

GET_PROJECTION_STATUS

GET_TABLE_PROJECTIONS

Getting Started

Glossary of Terms

Glossary of Terms

Good epoch logs are available on all nodes

GROUP BY Clause

HAS_TABLE_PRIVILEGE

Hash Segmentation

Hash Segmentation

hash-segmentation-clause

Help on Using the Administration Tools

Historical Query

Historical Query

SELECT

HOST

HOST

Physical Architecture

Hybrid Storage Model

Increase Free Memory

Increase the Maximum Number of Files Open

INSERT

INSERT

Loading and Modifying Data

Install libreadline.so.4

Install vsql Client Application on Non-Cluster Hosts (Optional)

install_vertica

Installation Guide

Installation Problems

Installing the JDBC Driver (Optional)

Installing the ODBC Driver (Optional)

Installing Vertica

Installing Your License Key

Institution_Dimension

Insufficient Projections to answer query

INTEGER (BIGINT)

INTERRUPT_STATEMENT

Interval Values

IPAddress _Dimension

Isolation level

K-Safety

Failure Recovery

K-Safety

K-Safety Support in Administration Tools

Keywords and Reserved Words

Kill Vertica Process on Node

Known Problems and Workarounds

Last Good Epoch

LD_LIBRARY_PATH

LIKE Predicate Referred to as ~~

Loading and Modifying Data

Loading and Modifying Data

Loading Character Data

Logical Schema

Prepare the Logical Schema Script

The Logical Schema (Tables and Constraints)

Logical Schema Design

LZO

Copyright Notice

CREATE PROJECTION

LZO

Make Sure That /dev/pts is Mounted

Managing Database Security

Managing Sessions

Managing Time Zones

Managing Your License Key

Manual Procedures

MARK_DESIGN_KSAFE

Master Table of Contents and Index

Materialized View

Logical Schema Design

Materialized View

Mathematical Functions

Mathematical Operators

MAX

MAX

SELECT

MIN

MIN

SELECT

Missing FROM-clause entry for table

Modify Existing Database Design

Modifying Tables

Monitoring Framework Enhancements

Monitoring Processes

Monitoring System Resource Usage

Monitoring the Database

Monitoring the Log Files

MortgageType_Dimension

Multi-byte characters

Multi-column key

New and Changed Features

No good epoch log available on node

No such file or directory ... super_projections.tmp.sql

Node Definition

Nodes stuck in INITIALIZING state

Not a Star or Snowflake Query

Not enough open file handles allowed...

Notes for Remote Terminal Users

Notes for Windows users

null

\pset parameter [ value ]

COPY

Loading Character Data

Numbering_Plan_Dimension

Numeric Constants

Numeric Expressions

Obtain a Vertica License Key

Operating the Database

ORDER BY Clause

Output Formatting Examples

Overview

Overview

Password Authentication

Performing the Initial Database Load

Performing Tuple Mover Operations Manually

Permission denied

Physical Architecture

Physical Schema

Platform Problems

Port

Creating a Connection

PORT

PostgreSQL

Copyright Notice

Pre-Join Projection

Preface

Preface

Prepare a Sample Query Script

Prepare Actual Data Files

Prepare Disk Storage Locations

Prepare Load Scripts

Prepare Sample Data Files

Prepare the Logical Schema Script

Prepared Statements in ODBC/JDBC

Printing the PDF Files

Product Overview

Product_Dimension

Projection Replication

Projection Segmentation

Projections

Column Store Architecture

Promotion_Dimension

PROMPT1 PROMPT2 PROMPT3

Purge Deleted Data

Query

Historical

SELECT

SQL Overview

Query Optimizer

Query Performance

Query-Specific Projection

Range Segmentation

Range Segmentation

range-segmentation-clause

Rate_Plan_Dimension

READ COMMITTED Isolation

Reading the HTML Files

Reading the JavaDoc HTML Files

Referential Integrity

Logical Schema Design

Referential Integrity

Remove Non-Essential Applications

Restart Database With Catalog Version

Retail Sales Example Database

retail_query_01.sql

retail_query_02.sql

retail_query_03.sql

Retail_Sales_Fact

REVOKE (Schema)

RLE (Run Length Encoding)

Roll Back Database to Earlier Epoch

ROLLBACK

ALTER PROJECTION

ROLLBACK

ROS (Read Optimized Store)

Hybrid Storage Model

ROS (Read Optimized Store)

Rotating the Log Files

Run the Database Designer

Running Queries

Running Simple Queries

Sample Application

Sample Application

Script

Prepare Sample Data Files

Prepare the Logical Schema Script

Using Load Scripts

Using the COPY, LCOPY and INSERT Commands

Searching for Information

Secure Shell (SSH)

Segmentation

CREATE PROJECTION

Defining Custom Projections

SERIALIZABLE

Using the Transaction Model

SERIALIZABLE Isolation

SESSION CHARACTERISTICS

Session Management

Session_Dimension

Set the Database Locale (Language)

Set the Default Time Zone

Set Up Incremental Loads

Set Up Security

Set Up Time Synchronization

Setting Up a Data Source Name

Setting Up the Database

Settlement_Dimension

Shutdown Problems

SITE

hash-segmentation-clause

Physical Architecture

Site

Site <node-name> got error: Too many groups.

Snapshot isolation

SELECT

Snapshot Isolation

Snowflake Schema

Logical Schema Design

Snowflake Schema

Software Compatibility Issues

Split_Dimension

Spread

Copyright Notice

Spread

Spread is not running

SQL Execution Problems

SQL Interpolation

SQL Language Elements

SQL Programmer's Guide

SQL Reference Manual

SQL Virtual Tables (Monitoring API)

SSH already configured

Star Schema

Logical Schema Design

Starting and Stopping the Database

Startup Problems

Startup successful, but some nodes are recovering

Statistical analysis

STDDEV

VAR_POP

VAR_SAMP

VARIANCE

Stock Dimension

Stock Exchange Example Database

StockTransaction_Fact

Stop Vertica on Node

Store_Dimension

String Concatenation Operators

String Constants (Dollar-Quoted)

String Constants (Standard)

String Functions

Suggested Reading Paths

SUM

SELECT

SUM

Superprojection

Supported Platforms

Syntax conventions

System Information Functions

T

table-constraint

table-reference

tableattr

\pset parameter [ value ]

\T table_options

Technical Support

Telecom Example Database

telecom_query_01.sql

telecom_query_02.sql

telecom_query_03.sql

telecom_query_04.sql

telecom_query_05.sql

Template Pattern Modifiers for Date/Time Formatting

Template Patterns for Date/Time Formatting

Template Patterns for Numeric Formatting

Test a Partial Data Load

Test the Empty Database

The Logical Schema (Tables and Constraints)

The Physical Schema (Projections)

TIME

SELECT

TIME

Time Zone Management

Time Zone Names for Setting TIMEZONE

Time Zone Values

TIMEOUT ERROR: Could not login with SSH

title

\pset parameter [ value ]

Trader_Dimension

Transaction

Loading and Modifying Data

Trickle Loading

Troubleshooting Guide

Tuple Mover

Advanced Storage Control

Hybrid Storage Model

tuples_only

\pset parameter [ value ]

\t

Tutorial Procedure

Two-phase commit

Typographical Conventions

Understanding the Automatic Tuple Mover

Unexpected Query Results

Uninstalling the Vertica Software

UPDATE

Loading and Modifying Data

UPDATE

Update and Delete Performance

Upgrade License Key

USER

USER

UserAgent_Dimension

Using an Artificial Segmentation Column

Using Compound Predicate Joins

Using Diagnostic Tools

Using INSERT, UPDATE, and DELETE

Using Load Scripts

Using Multiple Instances of Dimension Tables in the FROM Clause

Using Outer Joins

Using Parallel Load Streams

Using Temporary Tables

Using the Administration Tools

Using the Administration Tools

Using the COPY, LCOPY and INSERT Commands

Using the Database Designer

Using the Graphical User Interface

Using the Graphical User Interface

Using the Master Table of Contents and Index

Using the Navigation Bar

Using the Online Help

Using the SQL Monitoring API

Using the Transaction Model

UTF-8

COPY

UTF-8

Verifying a Data Source Name

Version Compatibility Issues

Vertica Functions

Vertica® Analytic Database V2.1.GA

View Database Cluster State

View Database Cluster State

VT_COLUMN_STORAGE

VT_DISK_STORAGE

VT_LOAD_STREAMS

VT_PROJECTION_STORAGE

VT_QUERY_METRICS

VT_RESOURCE_USAGE

VT_SESSION (VS_SESSION)

VT_TABLE_STORAGE

Where to Find Additional Information

Where to Find the Vertica Documentation

Working With Large Result Sets

WOS (Write Optimized Store)

Hybrid Storage Model

WOS (Write Optimized Store)

WOS Overload

Loading and Modifying Data

Writing Administration Tools Scripts

Writing Custom Projections

Writing Database Designer Scripts

Writing Queries