Defining Database Objects

This section covers data definition language (DDL) in HAWQ and how to create and manage database objects.

Creating objects in a HAWQ includes making up-front choices about data distribution, storage options, data loading, and other HAWQ features that will affect the ongoing performance of your database system. Understanding the options that are available and how the database will be used will help you make the right decisions.

Most of the advanced HAWQ features are enabled with extensions to the SQL CREATE DDL statements.

This section contains the topics:

• Creating and Managing Databases
• Creating and Managing Tablespaces
• Creating and Managing Schemas
• Creating and Managing Tables
• Table Storage Model and Distribution Policy
• Partitioning Large Tables
• Creating and Managing Views