Book Contents

Book Index

Next Topic

Home

Create the Physical Schema

  1. Connect to the Database

    Connect to the database. See Connect to Database for details.

    Welcome to the vsql, Vertica_Database v2.1.GA interactive terminal.

    Type: \h for help with SQL commands

    \? for help with vsql commands

    \g or terminate with semicolon to execute query

    \q to quit

    =>

  2. Execute the Database Designer Script

    Using the \i meta-command in vsql, execute the SQL projection script produced by the Database Designer. This scripts creates the projections that make up your Physical Schema.

    You can add and drop projections after data is loaded. However, be aware that adding a projection begins a refresh operation that copies data into the new projection from other projections. The refresh operation may take some time to complete. You can monitor the refresh operation by examining the log files.