Contents
1 Overview..................................................................................................4
Who should use this guide.........................................................................................................4
2 The HP CS300 Vertica appliance.................................................................5
Appliance overview..................................................................................................................6
Installation..........................................................................................................................7
Management software..............................................................................................................9
HP Insight Cluster Management Utility....................................................................................9
HP Insight Remote Support..................................................................................................11
3 Using HP Vertica......................................................................................12
Overview..............................................................................................................................12
Learning about HP Vertica.......................................................................................................12
Accessing HP Vertica..............................................................................................................12
Database superuser (dbadmin)............................................................................................12
HP Vertica interfaces..........................................................................................................12
Connecting to HP Vertica....................................................................................................13
Running the HP Vertica Getting Started Tutorial...........................................................................16
Creating the example database...........................................................................................16
Querying tables in the example database.............................................................................17
Using Database Designer to optimize a design......................................................................17
Dropping the example database..........................................................................................17
Performing common database administrator tasks.......................................................................18
Creating a database..........................................................................................................18
Rules for database and password names...............................................................................18
Starting and stopping the database......................................................................................18
Reconnecting to the database..............................................................................................18
Implementing security.........................................................................................................18
Creating new database users..............................................................................................18
Creating tables..................................................................................................................19
Loading data into the database...........................................................................................19
Monitoring the database.....................................................................................................19
Using HP Vertica Management Console................................................................................19
Performing advanced database administrator tasks.....................................................................20
Installing HP Vertica software for third-party tool integration.....................................................20
Managing load balancing for client connections....................................................................20
Managing database resources............................................................................................20
Changing the dbadmin password........................................................................................21
Installing or upgrading an HP Vertica license key...................................................................21
More information for using HP Vertica..................................................................................21
4 Support and other resources......................................................................23
Information to collect before contacting HP.................................................................................23
How to contact HP..................................................................................................................23
Typographic conventions.........................................................................................................23
5 Documentation feedback ..........................................................................24
Contents
3
