Test the Empty Database

1. Test for Sufficient Projections

   Using the \i meta-command in vsql, execute the sample query script that you prepared earlier. No data has been loaded so the queries return empty result sets. If you get an error about insufficient projections, check the Troubleshooting Guide for possible reasons.

   Reads input from the file filename and executes it as though it had been typed on the keyboard.

   Note: To see the lines on the screen as they are read, set the variable ECHO to all.

2. Check the Design for K-Safety

   Using the \i meta-command in vsql, execute the following statement:

   Reads input from the file filename and executes it as though it had been typed on the keyboard.

   Note: To see the lines on the screen as they are read, set the variable ECHO to all.

   => SELECT MARK_DESIGN_KSAFE(1);

   The statement checks the physical schema design (projections) and, if the design meets all requirements, enables recovery. For more information, see SELECT MARK_DESIGN_KSAFE in the SQL Reference Manual).

   Recovery is the process of restoring the database to a fully-functional state after one or more nodes in the system has experienced a software or hardware related failure. Vertica has a unique approach to recovering a node that is based on querying replicas of the data stored on other nodes. For example, a hardware failure may cause a node to lose database objects or to miss changes made to the database (INSERTs, UPDATEs, etc.) while offline. When the node comes back on line, it recovers lost objects and catches up with changes by querying the other nodes.