Using this guide

This guide shows how to set up a Vertica database and run simple queries that perform common database tasks.

This guide shows how to set up a Vertica database and run simple queries that perform common database tasks.

Who should use this guide?

This guide targets anyone who wants to learn how to create and run a Vertica database. This guide requires no special knowledge at this point, although a rudimentary knowledge of basic SQL commands is useful when you begin to run queries.

For short tutorial on how to install Vertica, create a database, and load data, see the Quickstart guide.

What you need

The examples in this guide require one of the following:

  • Vertica installed on one host or a cluster of hosts. Vertica recommends a minimum of three hosts in the cluster.

  • Vertica installed on a virtual machine (VM).

For further instructions about installation, see Installing Vertica.

Accessing your database

You access your database with an SSH client or the terminal utility in your Linux console, such as vsql. Throughout this guide, you use the following user interfaces: