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
A
About the Documentation
Acrobat
Adding Primary Key and Foreign Key Constraints
Administration Tools Reference
Adobe Acrobat
Advanced
ALTER TABLE
Anchor table
Avoiding WOS Overflow
B
Backing Up the Database
Backslash
Loading Character Data
Typographical Conventions
Berkeley DB
Bold text
Boost
Braces
Brackets
Bulk Loading
Bulk Loading
Loading and Modifying Data
Test a Partial Data Load
C
Cannot shut down while users are connected
Character data
Colored bold text
Complete the Data Load
Configuration
Configuration Procedure
Configuring the Database
Connect to Database
COPY
Loading and Modifying Data
Prepare Sample Data Files
Using Load Scripts
Copyright Notice
Create Database
Create New Database Design
CREATE TABLE
Create the Database
Create the Logical Schema
Create the Physical Schema
Creating Tables
CRITICAL
D
Data Warehouse Schema Types
Database ... did not appear to stop...
Database Designer Dialog
Database did not start cleanly on initiator node!
Database Parameters
Database startup successful, but it may be incomplete
dbLog
DEBUG
DELETE
DELIMITER
Dimension table
Snowflake Schema
Star Schema
DIRECT
DISABLE
Documentation
Drop Database
E
Ellipses
Error starting database, no nodes are up
F
Fact table
file command
Snowflake Schema
Star Schema
Failure Recovery
G
Good epoch logs are available on all nodes
H
Help on Using the Administration Tools
HTML
I
Indentation
INFO
INSERT
Italic text
K
Kill Vertica Process on Node
L
Loading and Modifying Data
Loading Character Data
Log files
Logical schema
Prepare the Logical Schema Script
The Logical Schema (Tables and Constraints)
LZO
M
Managing Database Security
Managing Sessions
Managing Time Zones
Managing Your License Key
Modify Existing Database Design
Modifying Tables
Monitoring Processes
Monitoring System Resource Usage
Monitoring the Database
Monitoring the Log Files
Monospace text
N
No good epoch log available on node
Nodes stuck in INITIALIZING state
Notes for Remote Terminal Users
NULL
O
Operating the Database
Overview
P
Password Authentication
PDF
Performing the Initial Database Load
PostgreSQL
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
Printing the PDF Files
R
Reading the HTML Files
Reading the JavaDoc HTML Files
Restart Database With Catalog Version
Restart Node
Roll Back Database to Earlier Epoch
Rotating the Log Files
Run the Database Designer
S
Script
Prepare Sample Data Files
Prepare the Logical Schema Script
Using Load Scripts
Using the COPY, LCOPY and INSERT Commands
Searching for Information
Set Up Incremental Loads
Set Up Security
Shell script
Shutdown Problems
Snowflake Schema
Spread
Spread is not running
Star Schema
Start Database
Starting and Stopping the Database
Startup Problems
Startup successful, but some nodes are recovering
Stop Database
Stop Vertica on Node
Suggested Reading Paths
Support
Syntax conventions
T
Technical Support
Test a Partial Data Load
Test the Empty Database
The Logical Schema (Tables and Constraints)
The Physical Schema (Projections)
TIMEOUT ERROR: Could not login with SSH
TIMING
TRACE
Trickle Loading
Typographical Conventions
U
UPDATE
Upgrade License Key
Uppercase text
Using INSERT, UPDATE, and DELETE
Using Load Scripts
Using Parallel Load Streams
Using the Administration Tools
Using the COPY, LCOPY and INSERT Commands
Using the Database Designer
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
V
Vertical line
View Database
View Database Cluster State
View Database Cluster State
W
WARNING
Where to Find Additional Information
Where to Find the Vertica Documentation
WOS Overflow
Writing Custom Projections