Installing and Connecting to the VMart Example Database

Follow the steps in this section to create the fully functioning, multi-schema VMart example database that you’ll use to run sample queries. The number of example databases you create within a single Vertica installation is limited only by the disk space available on your system; however, OpenText strongly recommends that you start only one example database at a time to avoid unpredictable results.

Vertica provides two options to install the example database:

Note: Both installation methods create a database named VMart. If you try both installation methods, you will either need to drop the VMart database you created (see Restoring the Status of Your Host in this guide) or create the subsequent database with a new name. However, OpenText strongly recommends that you start only one example database at a time to avoid unpredictable results

This tutorial uses Vertica-provided queries, but you can follow the same set of procedures later, when you create your own design and use your own queries file.

After you install the VMart database, the database has started. Connect to it using the steps in Step 3: Connecting to the Database.